Re: [libreoffice-users] Native Connector

Hello Girvin,
Yes, I will keep on using the JDBC-Driver, hoping that the native connector
will support autoreconnect some time in the future. If LO drops JDBC, I
have to look for a different Office system. To suggest restarting LO every time
after having to go away for a short break really is NOT feasible in reality.
Regards
Heinrich
P.S.: What do you guys think of Conchita winning the Eurovision song contest --
but THAT certainly should NOT start a new thread...(smiley!)

On Sun, 11 May 2014 21:53:25 +0200, Girvin Herr <girvin.herr@sbcglobal.net> wrote:

> Yes, if I understand Mr. Stoellinger's problem correctly, it is the
> MySQL server (aka "back-end") which is dropping his connection.
> According to my MySQL documentation, by default, the MySQL server drops
> any connection after 8 hours of continuous connection. However, Mr.
> Stoellinger's admin has reduced that time to 60 seconds!  IMHO, that is
> ridiculous, but it must be the policy at his institution, so he must
> live with it.  The MySQL connector driver that he has been using has a
> workaround by triggering a reconnect operation every so often,
> effectively restarting the 60-second timer.  That is the purpose of the
> "autoReconnect=true" connector driver parameter he talks about.  Now, it
> appears that the new LO Base has a MySQL native driver that replaces the
> Oracle MySQL-connector-java driver that he most likely has been using
> and he needs to know if the new LO native driver supports the reconnect
> schema and if so, how to implement it.  As far as I know, no one on this
> list so far has given him the answer to that question.  I have no
> experience with the new native driver (yet), so I do not have the
> answer.  If the native driver does not support it, or he does not get an
> answer, I would suggest keeping the Oracle JDBC driver until he gets his
> answer, if the new LO still allows replacement of the native built-in
> driver.
>
> BTW: I am my own admin, so my MySQL server is still set to the default
> timeout, if any.  Therefore, I do not experience this disconnect
> problem.  However, every so often, I see a posting about it on this
> forum, so he is not alone.
> HTH.
> Girvin Herr
>
>
> On 05/10/2014 03:37 PM, Tom Davies wrote:
> > Hi :)
> > It's the 2nd one Anne-ology.
> >
> > The connector is some sort of bridge between Base and MySql.  It's the
> > bridge that is timing out rather than the computer afaik.
> > Regards from
> > Tom :)
> >
> >
> >
> >
> > On 10 May 2014 22:13, 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>
> > >
> > >
> > > 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


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