Page 1 of 1
Driver closed connection
Posted: Mon Apr 11, 2011 7:06 pm
by TerryDactyl
Have connected to remote MySQL database through JDBC. Tables retrieved, editable, but only for a very short time. OOo seems to drop the connection, with the following error, which appears when I try to save changes or reload my tables.
SQL Status: 08003
No operations allowed after connection closed.Connection was implicitly closed by the driver.
+
SQL Status: 08S01
Communications link failure
The last packet successfully received from the server was 106,219 milliseconds ago. The last packet sent successfully to the server was 16 milliseconds ago.
Re: Driver closed connection
Posted: Mon Apr 11, 2011 8:37 pm
by rudolfo
How
remote is your database? If you have to pass through routers (and firewalls) I would not be surprised to get such issues? What kind of connection do you use? Secured SSL connection might have additional issues with key certificatons (although I would think that this kind of problems should inhibit all requests).
That about the database/driver part. Additionally you might check the Options Menu and OpenOffice Base - Connections: Make sure Connection Pooling is enabled (ticked). For me it says:
Code: Select all
| Driver Name | Pool | Timeout |
+------------------------------+------+---------+
| com.sun.star.sdbc.ODBCDriver | No | |
| com.sun.star.sdbc.JDBCDriver | Yes | 300 |
| com.sun.star.sdbc.MozabDriver| No | |
Can't say it for sure, but I think I did not have to change something from the defaults in this dialog.
Re: Driver closed connection
Posted: Sun Feb 23, 2014 6:52 am
by renato.pierri
Hi dear.
I know that is a bit old topic but I could circunvent that issue adding a '?autoReconnect=true' statement after the name of database.
Check below the steps I did:
Open the 'Database properties - Advanced Properties' dialog box:
Edit -> Database -> Connetion Type
Ensure MySQL (JDBC) is selected
Click Next and you'll get the 'Database properties - Connection settings' dialog box.
Ensure you have added the '?autoReconnect=true' statement right after the name of the MySQL database.
Remaining configuration properties stay as your connecton requires.
In time: If you have downloaded, installed and still not being able to recognize your MySQL connector, ensure you have created an environment variable called CLASSPATH in the advanced configurations of your Windows. Such variable must contain
the path of your MySQL connector, only the path;
do not set the path and file name in that variable like I did
.
One more print to help you.
Dears hope help you guys and please do not hesitate in fix or improve my answer.
"
When everything more fails, please read and follow the instruction manual - Nelson Zart"