Stop H2 database programmatically

Question

Consider we have a H2 database which is started from a web-application under Tomcat using Hibernate. In other words it is an embedded H2 database into the application.

The question: is it possible to programmatically stop this H2 server from this application and then start it again?

P.S. Server.createTcpServer(args).start(); or Server.shutdown(...) is not the way, because it is in the embedded mode.

Answer 1

In this particular case such an approach will be a workable solution:

1. To stop H2 database just use SHUTDOWN sql command:

   session.createSQLQuery("SHUTDOWN").executeUpdate();

2. To restart H2 you don't need to do anything: the Tomcat's connection pool will do it automatically.