Problem with MySQL tables

users
#1

Hello,

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 native
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 case...

Thanks a lot for any ideas
Heinrich

#2

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 4.3.1.2 on Windows7
- JDBC driver: mysql-connector-java-5.1.30-bin.jar
- Mariadb 5.5.33 on Opensuse