To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=41239
Issue #:|41239
Summary:|OOo defeated by dropped JDBC connection
Component:|Database access
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|msc
Reported by:|osavill
------- Additional comments from [EMAIL PROTECTED] Mon Jan 24 15:11:42 -0800
2005 -------
I wish to use OOo with an external MySQL database. Setting up the connection is
fine. I start to create a form with the Form Wizard, all this works too. I
finish the Wizard with the data entry option. The fields duely appear and I
start to enter data. I press "Save" and I get the message:
"Error inserting the new record
No operations allowed after connection closed"
If I try to do anything further with the data base I get a dialog with:
SQL Status: 08S01
Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1895)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2342)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2838)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1584)
at com.mysql.jdbc.Connection.serverPrepare(Connection.java:4932)
at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1312)
** END NESTED EXCEPTION **
In fact all I have to do is wait a while before hitting 'Save' and this will
happen. The assertion I presume is because the connection has died and OOo is
trying to talk over it. Would it be possible to trap this exception and
reconnect or do periodic keep alive type transactions ? The time period would
either have to be frequent or used adjustable.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
