[ http://issues.apache.org/jira/browse/DERBY-1148?page=comments#action_12412241 ]
Deepa Remesh commented on DERBY-1148: ------------------------------------- Yes, the VALUES CURRENT ISOLATION statement that is called upon getTransactionIsolation() can cause a commit when autocommit is on. Does this mean we cannot use this to get the isolation from the server? For other comments from Kathey, I will make the changes if we decide we can use this approach. Otherwise, I will go back to my first approach which partly solves this problem. Any pointers/suggestions are welcome. > Client XA getTransactionIsolation() does not return the correct isolation > level when rejoining a global transaction > --------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1148 > URL: http://issues.apache.org/jira/browse/DERBY-1148 > Project: Derby > Type: Bug > Components: Network Client > Versions: 10.2.0.0 > Reporter: Kathey Marsden > Assignee: Deepa Remesh > Fix For: 10.2.0.0 > Attachments: SetIsolationUsingSQL.java, XACheckIsolation.java, > XACheckIsolation_2.java, derby-1148_v1.diff, derby-1148_v1.status > > When rejoining a global transaction, client does not report the correct > isolation level with a > getTransactionIsolation(). The server side isolation should be ok I think. > This was discovered when testing the fix for DERBY-1044. After the fix for > DERBY-1044, there is a new diff in the test, but the fix for DERBY-1044 just > exposed this issue. The output for the test was correct before by > circumstance. > I will put comments with this bug in checkDataSource test. > // now re-join the transaction, should pick up the read-only > // and isolation level from the transaction, > // holdability remains that of this handle. > xar.start(xid, XAResource.TMJOIN); > printState("re-join X1", cs1); > xar.end(xid, XAResource.TMSUCCESS); -- 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
