Re: *** SPAM *** [libreoffice-users] Re: Native Connector

On Mon, 12 May 2014 06:37:09 +0200, Alex Thurgood <alex.thurgood@gmail.com> wrote:

> Le 10/05/2014 15:08, Heinrich Stoellinger a écrit :
>
> Hi Heinrich,
>
> You do not give the whole story :
>
> - which connector are you talking about, where did you get it ? It is
> not supplied by default with official builds of LO, so either it has
> been included as a packet with your Linux distribution, or else you have
> got it from somewhere else ;
I use JDBC-Connector mysql-connector-java-5.1.30-bin.jar; can't tell you
where I got it from, certainly not from a Linux-distribution (I run
Debian-Wheezy and Mint-16 respectively).
> - as for the autoreconnect, have you tried adding this as a parameter in
> the database URL when you set up the connection (i.e. as you would with
> the JDBC connector) - alternatively, is there anything in the Advanced
> Properties of the database connection ?
Yes, with a JDBC-Connection (not in the native connection case!) one can
specify "?autoReconnect=true" right after the database name. The connector
obviously uses this parameter to automatically reconnect to the server
when the latter closes the connection after the idle time specified in
my.cnf (or defaulted to the MUCH higher value mentioned by Girvin).

> If there isn't, or if the suggestion I made above doesn't work, then I
> doubt that it is possible. The only other alternative is to shut down
> the ODB and re-open it periodically.
I don't have to shut down the ODB --- see above!
Heinrich
> Alex


--
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