Re: [libreoffice-users] Native Connector

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