[DERBY-2780] 10.2 client procedure.java test fails when run against 10.3 server with ERROR X0X03: Invalid transaction state - held cursor requires same isolation level

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.3.1.4
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 07/Jun/07 20:47
• Updated: 12/Jun/07 19:53
• Resolved: 12/Jun/07 19:52

Description

10.2.1.6 derbyTesting.jar run against 10.3 product jars fails for client for lang/procedure.java with:
It is not clear to me what change caused the difference.

ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
java.sql.SQLException: Invalid transaction state - held cursor requires same isolation level
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:46)
at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
at org.apache.derby.client.am.Statement.executeUpdate(Statement.java:440)
at org.apache.derby.client.am.Connection.setTransactionIsolation(Connection.java:975)
at org.apache.derbyTesting.functionTests.tests.lang.procedure.multipleRSTests(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.lang.procedure.runTests(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.lang.procedure.main(Unknown Source)
Caused by: org.apache.derby.client.am.SqlException: Invalid transaction state - held cursor requires same isolation level
at org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1713)
at org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:1322)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:207)
at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:58)
at org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:45)
at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:125)
at org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:1318)
at org.apache.derby.client.am.Statement.flowExecute(Statement.java:2014)
at org.apache.derby.client.am.Statement.executeUpdateX(Statement.java:445)
at org.apache.derby.client.am.Statement.executeUpdate(Statement.java:431)
... 4 more

Issue Links

• is related to: DERBY-2743 Run 10.2 tests against 10.3 and evaluate to identify incompatibilities