Re: H2, LibreOffice and Java
Hi Noel, No, I don't think so. I'm checking the LibreOffice Base - Connections settings and I have the Connection pooling enabled unchecked... however, since you mention it... would it be a good idea to have checked instead? But then which driver would I select? the JDBCDriver? Note: regarding H2 itself, 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 Thanks again, Jorge On Thursday, May 30, 2013 10:33:12 AM UTC+4, Noel Grandin wrote: Network problems are always a pain. You could try using Wireshark or Microsoft Network Monitor to capture the connection, that might provide some more information. You aren't by any chance using some kind of Connection Pool are you? Some of those have timeout logic in them to kill off stale connections, and that might be accidentally triggering. On 2013-05-30 06:36, Jorge Alberch wrote: As a temporary measure I'm thinking of running a little robot to simple go up and down the database records to maintain the session open (I know: very crude solution, but it should work as a temporary measure). -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
H2, LibreOffice and Java
@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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.