RE: [libreoffice-users] Problem with MySQL tables

     You might need to close Base and then open it again. 

Dan

-------- Original message --------
From: Heinrich Stöllinger <hc.stoellinger@aon.at> 
Date:09/06/2014  1:03 PM  (GMT-05:00) 
To: users@global.libreoffice.org 
Subject: [libreoffice-users] Problem with MySQL tables 

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

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

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