[ http://issues.apache.org/jira/browse/DERBY-638?page=comments#action_12448320 ] Deepa Remesh commented on DERBY-638: ------------------------------------
I now see the current implementation will commit the transaction in all cases. The exception was indeed misleading and DERBY-638-v2.diff is more correct. I agree it will be good to fix this misleading exception and open separate JIRAs for the other two issues. It will be good if the repro can be included as a test case in the patch. > setTransactionIsolation behaviour in network client driver is different from > that of embedded driver > ---------------------------------------------------------------------------------------------------- > > Key: DERBY-638 > URL: http://issues.apache.org/jira/browse/DERBY-638 > Project: Derby > Issue Type: Bug > Components: Network Client > Affects Versions: 10.2.1.6 > Reporter: Deepa Remesh > Assigned To: Bernt M. Johnsen > Attachments: d638.java, d638_repro2.java, d638_repro3.java, > DERBY-638-v2.diff, DERBY-638.diff > > > When autocommit is set to false, a call to setTransactionIsolation using > client driver does not end the transaction when the method exits. When a > close() is called on the conection, it throws an exception. > Running the code below: > conn.setAutoCommit(false); > conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); > try{ > conn.close(); > }catch(SQLException se){ > System.out.println("Got exception when closing the > connection"); > se.printStackTrace(); > } > with client driver gives: > Got exception when closing the connection > org.apache.derby.client.am.SqlException: java.sql.Connection.close() > requested while a transaction is in progress on the connection.The > transaction remains active, and the connection cannot be closed. > with embedded driver, it works okay and does not throw any exception. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
