@Dear Thomas, First and foremost: A million heartfelt thanks for your impressive work on H2. I've been using it for the last 2 years to run a nice little concurrent user (server mode) LibreOffice database.
@All, However over the last month the database appears to disconnect itself. To be specific: I'll leave the LibreOffice database open, then come back to after 15 minutes, scroll down some records and the database will freeze (note: this did not happen before). I have fixed this by inserting "AUTO_RECONNECT=TRUE" in the LibreOffice Base Database Properties - Datasource URL. Now the database will reconnect automatically, however there'll be a short period of waiting during this time which is annoying... I also worry about the other "users" which are non-technical people and consequently finicky. Note: on the Windows OS, cmd screen I initiate the H2 Server by running a script with the following: java -cp h2*.jar org.h2.tools.Server -tcpAllowOthers -webAllowOthers Question: Is there a way to keep the database "open", or a way to avoid this waiting time for the LibreOffice database to "Auto-Reconnect"? More notes: The database was running perfectly for 2 years... I was running the H2 database server mode on an exclusively dedicated old desktop box. Only changes have been the upgrade of the Java version which I think (though this is simply my guess and I could be wrong) that the Java upgrade is to blame. Any ideas? Thanks in advance, Jorge Alberch -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
