Ok, that's what I originally thought as well.... I appreciate the reply... the post above confused me... for my info what is the negative result of NOT disable the automatic database close.... if I do disable it... do I need to manually close the database somehow when the connection's container is disposed? (if so, how :)
On Fri, Nov 14, 2008 at 10:38 AM, Thomas Mueller < [EMAIL PROTECTED]> wrote: > > Hi, > > > Should we be creating (opening) and closing a db connection every time > > we want to execute a query? > > No, unless performance is not an issue. It's usually easier to just > always use the same connection. If you do open and close the > connection each time, make sure you disable the automatic database > close, see http://www.h2database.com/html/grammar.html#setdbclosedelay > > 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 -~----------~----~----~----~------~----~------~--~---
