Sorry... ignore my questions... I just read the answer via the link your provided...
On Fri, Nov 14, 2008 at 10:53 AM, Kevin Edwards <[EMAIL PROTECTED]>wrote: > 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 -~----------~----~----~----~------~----~------~--~---
