Hi, > I stop Tomcat using $CATALINA_HOME/bin/shutdown.sh and I occusionally > expererience that the .lock.db file is not deleted.
What happens if you delete this file? Does it stay deleted, or does it re-appear after a few seconds? If it stays deleted, then the database was not closed but the process was stopped. If it re-appears, then the process is still running. > You are saying: >>>This is a bit strange. Tomcat should dispose the connection pool, >>>which in turn should close all connections to the database. That would >>>delete the .lock.db file. If it's not deleted, then at least one >>>database connection remains open during the Tomcat shutdown. > But this is the issue of this thread. Well, it's a problem... It might not be your problem. > My application closes all the > connections, which are returned to Tomcat's pool and on shutdown Tomcat does > not dispose all of the connections before shutting down the web app and so > on and as a result the .lock.db file remains. Well, at the beginning of the mail you wrote you shut down *Tomcat*, not just the web app. If the web app is stopped, then the database stays open, that's correct and OK. > Does your solution solve this issue as well? No. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
