Documentation says that this setting is persistent.You can get its value using this query select * from INFORMATION_SCHEMA.SETTINGS where name = 'DB_CLOSE_ON_EXIT'
But it seems to me that it would be better to dont rely on such hacky options and use connection pool or something like. This will impove performance not only for H2 but for other databases too. On 24 ноя, 00:32, marcolopes <[email protected]> wrote: > Thanks! That solved the problem (at least for now!) > > Can you please tell me: > > if i set the value on the console, where is the value "stored"? > And if i set it through the Connection URL, does it get "stored" the > same way? > How can i consult the actual value of the "parameter"? > > On Nov 23, 8:15 pm, Sergi Vladykin <[email protected]> wrote: > > > Seehttp://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.
