In Base, when I connect to a remote MYSQL database using JDBC, I usually get to run one query okay, then the second query that I try gets "SQL Status: 08003 No operations allowed after connection closed.Connection was implicitly closed by the driver".
I then have to exit Base and restart it to run another query. I must be doing something wrong, but I don't know what. I believe I am using com.mysql.jdbc.driver, although I notice that when I look at Tools > Options >LibreOffice Base > Connections I do not see it in the list of drivers known to LibreOffice.
So...
What can I do to get rid of this continaul "connection implicitly closed by driver"?
In case I can't fix the above, is there any way to reconnect to the DB without exiting and restarting Base?
I am running on Ubuntu 11.04, and the following version of LibreOffice:
LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1
Thanks very much.
To fix the problem, add "?autoReconnect=true" (without the quotes) immediately after the name of the database (no intervening spaces).
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-25 20:40:02 +0200
Seen: 454 times
Last updated: May 28 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
The following COULD be the cause of my problem: I went through the whole connection process again from scratch (that is, creating a new ODB). When I got to the point where the is a button to test the class com.mysql.jdbc.driver, it could not be loaded. (Though I could still connect okay.)
RichA ( 2012-05-25 22:34:08 +0200 )editDownloading the mysql connector and adding it to my classpath...(it was there two weeks ago, what happened to it?)...did seem to improve things. I can stay connected for awhile, though I notice if I walk away for 10 minutes I will be disconnected.
RichA ( 2012-05-25 22:57:59 +0200 )edit