Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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 <laginnis@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.stoellinger@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.