Thanks Thomas, AUTO_SERVER worked very well, and we'll be using that solution.
I also found a workaround for pre 1.1.100. Using the web.xml to start the H2 server with DbStarter did work, I just needed to change my H2 console JDBC URL to use tcp instead of file format. However the workaround was still undesirable, as a support tech would need to use the embedded mode when the H2 server was down, and tcp/server connection when it was up. So I'm mighty thankful for AUTO_SERVER. As a heads up, it needs to be added to the JDBC URL documentation. =) On Oct 7, 2:39 pm, Mike Monkiewicz <[EMAIL PROTECTED]> wrote: > On a whim, I tried adding the DbStarter listener to our web.xml file. > > Web.xml relevant code: > > <context-param> > <param-name>db.url</param-name> > <param-value>jdbc:h2:file:$PATH</param-value> > </context-param> > <context-param> > <param-name>db.user</param-name> > <param-value>$USER</param-value> > </context-param> > <context-param> > <param-name>db.password</param-name> > <param-value>$PASSWD</param-value> > </context-param> > <context-param> > <param-name>db.tcpServer</param-name> > <param-value>-tcpAllowOthers</param-value> > </context-param> > > <listener> > <listener-class>org.h2.server.web.DbStarter</listener-class> > </listener> > > It didn't work, as the H2 db directory still contained a lock file > after the server established a connection. Still hoping someone can > point me in the right direction. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
