Re: [libreoffice-users] Problem with MySQL tables

On 6-9-2014 19:03, Heinrich Stöllinger wrote:
> 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

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



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