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

On 6-9-2014 19:03, Heinrich Stöllinger wrote:

After changing the structure of a MySQL-table (deleting ONE column and
inserting another
column) I cannot access the table anymore through LO-Base. LO-Base still
keeps looking
for the old column.

Since everything works just fine when using the mysql-client
(Linux.Mint) through the
command-line, I assume that the problem might have to do with some kind
of cache that
persists across LO-restart and/or system boot. If this is so - can
anybody tell me where
such a cache might be stored under LO 4.2.5 or LO 4.3.1?

On the other hand, this only happens when using the JDBC-Connector.
However, I HAVE to use
this connector since the "wait_timeout" global value specification on
the server is too
low for "decent" work in my case and I cannot increase this value. The
MySQL-connector works fine, except that it doesn't have the possibility
to specify an
"auto-reconnect" parameter in the connection, so, again I cannot use it.
In MY case one
solution would be to have such a parameter also in the native connector

Thanks a lot for any ideas

I don't have such a problem.

What OS is the database on, and what OS is LibreOffice on? What version of MySQL, and what version of the JDBC-driver?

I tested this with:
- LibreOffice on Windows7
- JDBC driver: mysql-connector-java-5.1.30-bin.jar
- Mariadb 5.5.33 on Opensuse

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.