First time here? Check out the FAQ!
answered 2012-06-21 10:35:38 +0200Alex Thurgood
Well, seeing as you don't mention which db backend you are using, it makes it kinda hard to offer a reply. Most server backend connections have inactivity timeouts to avoid a given user from hogging a connection, and using in-process memory, when nothing is actually being asked of the server. You would have to look at these parameters if you wanted to maintain a connection to such a server backend, assuming that you had the admin rights to do so, or else fiddle with your driver parameters (if at all supported) :
The link above mentions connection pooling. You can actually turn this on in LO, and sometimes it can help.
answered 2012-05-23 23:41:13 +0200mariosv
Maybe you have to take look for a parameters to set in the connection, to avoid lose the connection.
is the an url in jdbc connection to Firebir, without the "?defaultHoldable" the connection was losing even while a query is in execution.
answered 2012-07-23 12:15:41 +0200Alex Thurgood
In your comment, you say "I would just prefer to click on one button the next day to reconnect"
The only other alternative I can think of at the moment, would be to write a LO basic macro, associated with a button in the Main LibreOffice application window, which would close the ODB database file, and re-open it to re-establish the connection.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-23 16:50:17 +0200
Seen: 299 times
Last updated: Jul 23 '12