See http://h2database.com/html/grammar.html#set_db_close_delay
On 23 ноя, 23:04, marcolopes <[email protected]> wrote: > Thanks for the reply. > > Is there a way of keeping the database opened (or a keep alive > setting) ? > > On Nov 23, 7:37 pm, Sergi Vladykin <[email protected]> wrote: > > > Hi, > > > The first thing comes to my mind is that H2 by default closes database > > if there is no open connections. May be your application somehow > > closes connection after each database operation? Web console keep its > > connection open all the time and prevents database from being closed > > and reopened each time. > > > regards, > > Sergi > > > On 23 ноя, 21:49, marcolopes <[email protected]> wrote: > > > > H2 is not SLOW. Is one of the fastest RDBMS i have tested to date! > > > > I need help explaining WHY i need to CONNECT to the database using the > > > WEB MANAGER (H2 console) to get the fantastic speed of this DB > > > engine... I accidentally tested my app when CONNECTED through the H2 > > > WEB console "et voilá", problem solved. > > > > Why??? i'm puzzled :-\ > > > > Thanks. > > > > NOTE: App isJAVA EclipseRCP platform + Datanucleus 2.x persistence > > > engine (JDO). No problems at all using MySQL and PostgreSQL (or even > > >MS SQL Server). -- 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.
