[
https://issues.apache.org/jira/browse/DERBY-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13958735#comment-13958735
]
Dag H. Wanvik commented on DERBY-6516:
--------------------------------------
We have sometimes an error after the conversion, e.g. cf. here:
http://download.java.net/javadesktop/derby/request_5589368/javadb-task-3833992.html
{code}
java.sql.SQLException: The exception 'java.sql.SQLException: Invalid
transaction state - held cursor requires same isolation level' was thrown while
evaluating an expression.
at
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:112)
at
org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:321)
at
org.apache.derby.client.am.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:404)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.assertUpdateCount(BaseJDBCTestCase.java:1403)
at
org.apache.derbyTesting.functionTests.tests.lang.NestedCommitTest.testNestedCommit(NestedCommitTest.java:179)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: ERROR 38000: The exception 'java.sql.SQLException: Invalid
transaction state - held cursor requires same isolation level' was thrown while
evaluating an expression.
at
org.apache.derby.client.am.ClientStatement.completeExecute(ClientStatement.java:1861)
at
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(NetStatementReply.java:323)
at
org.apache.derby.client.net.NetStatementReply.readExecuteCall(NetStatementReply.java:107)
at
org.apache.derby.client.net.StatementReply.readExecuteCall(StatementReply.java:84)
at
org.apache.derby.client.net.NetStatement.readExecuteCall_(NetStatement.java:193)
at
org.apache.derby.client.am.ClientStatement.readExecuteCall(ClientStatement.java:1824)
at
org.apache.derby.client.am.ClientPreparedStatement.flowExecute(ClientPreparedStatement.java:2175)
at
org.apache.derby.client.am.ClientPreparedStatement.executeUpdateX(ClientPreparedStatement.java:409)
at
org.apache.derby.client.am.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:395)
Caused by: ERROR X0X03: Invalid transaction state - held cursor requires same
isolation level
{code}
> Convert lang/nestedCommit.sql to JUnit NestedCommitTest
> -------------------------------------------------------
>
> Key: DERBY-6516
> URL: https://issues.apache.org/jira/browse/DERBY-6516
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Reporter: Dag H. Wanvik
> Assignee: Dag H. Wanvik
> Priority: Minor
> Fix For: 10.11.0.0
>
> Attachments: DERBY-6516.diff, DERBY-6516.stat
>
>
> Uploading a patch to convert this test to JUnit; also wires into lang/_Suite
> and removed it from the harness tests.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
