You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/03/02 05:48:48 UTC
[jira] Resolved: (DERBY-1006) Client allows setHoldability to
HOLD_CURSORS_OVER_COMMIT on both connection and statement in a global
transaction
[ http://issues.apache.org/jira/browse/DERBY-1006?page=all ]
Daniel John Debrunner resolved DERBY-1006:
------------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Changes submitted and tests added to XATest.java
> Client allows setHoldability to HOLD_CURSORS_OVER_COMMIT on both connection and statement in a global transaction
> ------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1006
> URL: http://issues.apache.org/jira/browse/DERBY-1006
> Project: Derby
> Type: Bug
> Versions: 10.1.2.2, 10.3.0.0
> Reporter: Kathey Marsden
> Assignee: Daniel John Debrunner
> Fix For: 10.2.0.0
>
> Client allows holdability to be set to HOLD_CURSORS_OVER_COMMIT in a global transaction.
> I am not sure of the impact on the server side.
> To reproduce look for this code in checkDataSource30 and take out the return for client.
> if (!TestUtil.isEmbeddedFramework())
> {
> // Don't run the rest of the test for client
> // Network XA BUG: Client allows set HOLD_CURSORS_OVER_COMMIT
> // to be set in a a global transaction on the connection and
> // statements
> conn.close();
> return;
> }
>
> xid = getXid(24, (byte) 21, (byte) 01);
> xr.start(xid, XAResource.TMNOFLAGS);
> System.out.println("CONNECTION(xa) HOLDABILITY " + (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
> try {
> conn.setHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT);
> System.out.println("FAIL allowed to set hold mode in xa transaction");
> } catch (SQLException sqle) {
> System.out.println("Expected SQLException(setHoldability) " + sqle.getMessage());
> }
--
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