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

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


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.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.