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]