Embedded returns wrong value for 
DatabaseMetaData.autoCommitFailureClosesAllResultSets()
----------------------------------------------------------------------------------------

                 Key: DERBY-3422
                 URL: https://issues.apache.org/jira/browse/DERBY-3422
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.4.0.0
            Reporter: Knut Anders Hatlen
            Assignee: Knut Anders Hatlen
            Priority: Minor


DatabaseMetaData.autoCommitFailureClosesAllResultSets() returns false both on 
the client and on embedded. However, the embedded driver does in fact close all 
open result sets when an error occurs in auto-commit mode. There is a test case 
in jdbc4.TestDbMetaData to test this (testAutoCommitFailure), but it only uses 
ResultSet.isClosed() to check whether or not the result set is closed after the 
failure. Because of DERBY-3404, isClosed() returns false for the result sets 
that have been closed because of the failure, so the test doesn't reveal the 
bug. If the test is changed to invoke methods on the result set (e.g. next()) 
instead of calling isClosed(), we'll see that the result set is in fact closed 
and get an SQLException with SQL state XCL16.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to