Hi :) That might be another neat work-around, perhaps as a 'temporary' system while waiting for more devs to join in with working on Base. Regards from Tom :)
On Wednesday, 27 January 2016, Dries Feys <dries.f...@tvh.com> wrote: > Hello Heinrich, > > I never used Base, though for other projects I use MySQL and other db's. > As a workaround, I wonder whether it is possible to disconnect the > database from within LO after each query? Then, you should be able to > reconnect when a new query is requested. This also has the advantage > you won't have many simultaneous connections on the db. > > Met vriendelijke groeten, Salutations distinguées, Kind Regards, > > DRIES FEYS > CORPORATE SERVICES • Specialist Software Developer > > TVH GROUP NV > Brabantstraat 15 • BE-8790 WAREGEM > T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com > Watch our company movies on www.tvh.tv > > > > Business Innovation > through > Information Technology > bi2t.tvh.com > > > On 27 January 2016 at 11:29, Heinrich Stoellinger <hc.stoellin...@aon.at > <javascript:;>> wrote: > > Hello, > > I have been an avid user of LO/OO-Base for years, using it to connect to > a > > MySQL database for everyday work --- couldn't do without it. I am > convinced > > that a good connection to a DB-backend like MySQL/MariaDB is essential > for > > LO to be successful in a "real" business environment. > > As I have mentioned in earlier messages to the list, I use JDBC to > connect > > to my remote DB-server as well as the native MySQL-connector for my local > > test server. > > Unfortunately I don't have access to the remote server and therefore > cannot > > change its idle-timeout, which is set at 60 seconds. > > On my Linux-Mint system I also connect to the server via the command line > > MySQL client. If - after going away for more than 60 seconds - I come > back > > to do more work, the client reports the timeout, but reconnects > > automatically. > > This is kind of acceptable, even in a business production environment. > > Unfortunately the native connector does not support "autoreconnect". This > > means that one would have to restart LO in case of a timeout > (unacceptable > > for "serious" work!) On the other hand, JDBC does allow the > specification of > > "autoreconnect=true" as part of a connect string. However, unlike in the > > case > > of the MySQL command-line client, LO-Base doesn't simply reconnect > > AUTOMATICALLY, > > but displays a message such as "The last package sent to the server was x > > seconds ago, the lase received packed was y seconds ago". > > This means that whenever a timeout occurs, one has to confirm the wish to > > reconnect - even though one has specified that one wants to do this in > the > > connect string when defining the DB-connection properties in the first > > place! > > I wonder how difficult it would be to implement such a REALLY automatic > > reconnection... > > Regards (and I appologise for the lengthy description...) > > H. Stoellinger > > > > > > -- > > Erstellt mit Operas revolutionärem E-Mail-Modul: > http://www.opera.com/mail/ > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > <javascript:;> > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > -- > > > **** DISCLAIMER **** > > http://www.tvh.com/glob/en/email-disclaimer > > "This message is delivered to all addressees subject to the conditions > set forth in the attached disclaimer, which is an integral part of this > message." > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > <javascript:;> > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted