[
https://issues.apache.org/jira/browse/DERBY-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12485386
]
Rick Hillegas commented on DERBY-2502:
--------------------------------------
Committed derby-2502-01.diff at subversion revision 523887. JUnit tests pass
cleanly for me under jdk1.4. Under 1.6 with insane+debug jars, I see the
following error. I also see this error in that environment even without this
change when I run the jdbcapi JUnit suite:
1)
testIsolation(org.apache.derbyTesting.functionTests.tests.jdbcapi.SetTransactionIsolationTest)java.sql.SQLException:
Invalid transaction state - held cursor requires same isolation level
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:380)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:345)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1511)
at
org.apache.derby.impl.jdbc.EmbedConnection.setTransactionIsolation(EmbedConnection.java:1365)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SetTransactionIsolationTest.checkIsolationLevelTimeout(SetTransactionIsolationTest.java:78)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SetTransactionIsolationTest.testIsolation(SetTransactionIsolationTest.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
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)
Caused by: java.sql.SQLException: Invalid transaction state - held cursor
requires same isolation level
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:295)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.setIsolationLevel(GenericLanguageConnectionContext.java:2397)
at
org.apache.derby.impl.jdbc.EmbedConnection.setTransactionIsolation(EmbedConnection.java:1363)
... 28 more
> Unclosed ResultSets choke JUnit lang _Suite on java 6
> -----------------------------------------------------
>
> Key: DERBY-2502
> URL: https://issues.apache.org/jira/browse/DERBY-2502
> Project: Derby
> Issue Type: Bug
> Components: SQL, Test
> Affects Versions: 10.3.0.0
> Environment: solaris, java 6 build 105, insane+debug jars
> Reporter: Rick Hillegas
> Attachments: derby-2502-01.diff
>
>
> The lang suite fail for me from UnaryArithmeticParameterTest on. The tests
> can't drop table T1 because a ResultSet is open.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
