Hello,
I am NOT referring to the server-side machine shutting down but - as I
mentioned already earlier - to the MySQL-Server-parameter "wait_timeout"
which is specified in my.cnf. It simply defines the interval of "no request"
from a particular client to the server it is connected to. The server shuts
down the connection if that period has expired without further hearing
from the client. My problem is that I am NOT the system administrator
of the server and the sysadmin of the server won't increase that
wait_timeout value. JDBC has a way around this by auto-reconnecting the
client if this is specified when establishing the connection. This is
NOT an ideal situation (re-establishing the connection takes time...) but
it is certainly better than having to shutdown/restart LO...
Regards
H. S.
On Sat, 10 May 2014 23:13:38 +0200, anne-ology <lagin...@gmail.com> wrote:
If you're referring to the computer-machine shutting down and/or
entering sleep-mode, then there's a simple solution;
if you're referring to something else - well, I haven't a clue.
If the 1st - go to properties/options/ and re-set the timing
mechanism to never shut down
you can also do similarly in various programs - as LO -
which otherwise decide they want to save every so often, causing
me to lose my train of thought while writing ;-)
If the 2nd - I'll be awaiting someone else's response on this list;
and will attempt to figure out what's what ;-)
From: Heinrich Stoellinger <hc.stoellin...@aon.at>
Date: Sat, May 10, 2014 at 8:08 AM
Subject: [libreoffice-users] Native Connector
To: "users@global.libreoffice.org" <users@global.libreoffice.org>
on
Hello,
It's good to see a native connector for MySQL under 4.2.
One question: In the server my.cnf the value for wait_timeout
is set to 60 seconds and will not be increased. This is a nuisance
if one needs to be connected over longer periods but sometimes
has to go away from there client for more than a minute.
Under the JDBC-connector there is a possibility to specify
"?auto-reconnect=true" after the database name.
Is there some facility like that under the native connector?
Regards
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
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
