Re: [libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

On 10/03/2014 06:07 AM, Heinrich Stöllinger wrote:
> Alex Thurgood schrieb:
> > Le 03/10/2014 07:27, Alan B a écrit :
> >
> > Hi Alan,
> >
> > > I have a database from the US gov't, npidata freely available, with 
> > > about
> > > 3.5 million rows and around 350 columns. Actually the gov't provides 
> > > a csv.
> > > Imported it into a MySQL db using the MySQL command line. Never been 
> > > able
> > > to read the primary table using the Java connector. With the native 
> > > MySQL
> > Yeah, the whole Java connector thing within LibreOffice and large record
> > sets is a very bad combination, even with a mysql backend ! I'm not
> > surprised you couldn't read it with an array of data that big, even if
> > each field only contained 1 byte :-)
> >
> > Glad that the native connector at least allows you to load the 
> > records :-))
> >
> >
> > Alex
> Hi Alex,
> I do have a long-time "connection" with ALL 3 kinds of MySQL connectors.
> Only the native one REALLY works o.k...
> There is one problem in MY case, however: My DB-Hosting facility 
> specifies
> a connection time-out value of 1 minute. With the Java connector one can
> specify "reconnect-true" (or yes?) when defining the DB under LO. This
> means that LO at least re-connects after a termination of the connection
> by the server. This is NOT a good situation, but it is kind of 
> acceptable.
> The native connector does NOT allow such a specification. This makes it
> unusable to me unfortunately. I hope that it might be possible to change
> this limitation of the native connector.
> Regards
> Heinrich
     This may not be much of a work a round. I have a database using 
MySQL 5.5 server that I leave open for long periods of time. So when I 
come back the database, I get the message: MySQL has gone away. Since 
the database is the only thing that I am using LibreOffice for at the 
time, I close the database rather than LibreOffice. This opens the Start 
window which contains a list of previously used files. I double click 
the name of the database, and I am reconnected. It even remembers the 
user name and password, so the database is opened and ready to use.
     Have you filed a bug report about this?

Dan

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