First time here? Check out the FAQ!
asked 2012-05-25 20:40:02 +0200RichA
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.
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-126.96.36.199, Ubuntu package 1:3.3.4-0ubuntu1
Thanks very much.
answered 2012-05-28 21:15:54 +0200RichA
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