jdbcapi/xaStateTran test fails with 10.1 client and derbyTesting.jar with 10.2
server.
--------------------------------------------------------------------------------------
Key: DERBY-1084
URL: http://issues.apache.org/jira/browse/DERBY-1084
Project: Derby
Type: Bug
Components: Regression Test Failure
Versions: 10.2.0.0
Reporter: Sunitha Kambhampati
This new failure was noticed in the nightly testrun with jdk15. Looks like
some xa changes have gone in to 10.2 Is this related to those changes, if so -
is this diff ok ? Please comment. Thanks.
********* Diff file
derbynetclientmats/DerbyNetClient/derbynetclientmats/xaStateTran.diff
*** Start: xaStateTran jdk1.5.0_02 DerbyNetClient
derbynetclientmats:derbynetclientmats 2006-03-07 10:15:59 ***
28 del
< GXID |STATUS |READ& |USERNAME |TYPE
29 del
< -----
30 del
< (1 |IDLE |NULL |APP |UserTransaction
30a28
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
170a169,183
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
> ij> -- the following should error XAER_PROTO
> xa_start xa_noflags 40;
> IJ ERROR: XAER_PROTO
> ij> -- the following should error XAER_PROTO
> xa_start xa_join 40;
> IJ ERROR: XAER_PROTO
> ij> -- the following should error (transaction wasn't suspended) XAER_PROTO
> xa_start xa_resume 40;
> IJ ERROR: XAER_PROTO
> ij> select * from global_xactTable where gxid is not null order by gxid;
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
> ij> -- the following should work
> xa_end xa_success 40;
> ij> select * from global_xactTable where gxid is not null order by gxid;
174,192d186
< ij> -- the following should error XAER_PROTO
< xa_start xa_noflags 40;
< IJ ERROR: XAER_PROTO
< ij> -- the following should error XAER_PROTO
< xa_start xa_join 40;
< IJ ERROR: XAER_PROTO
< ij> -- the following should error (transaction wasn't suspended) XAER_PROTO
< xa_start xa_resume 40;
< IJ ERROR: XAER_PROTO
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
< ij> -- the following should work
< xa_end xa_success 40;
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
196a191,195
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
> ij> -- the following should work
> xa_end xa_fail 40;
> IJ ERROR: XA_RBROLLBACK
> ij> select * from global_xactTable where gxid is not null order by gxid;
199a199,203
> ij> xa_rollback 40;
> ij> -- get back in associated state
> xa_start xa_noflags 40;
> ij> select * from global_xactTable where gxid is not null order by gxid;
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
201,214d204
< xa_end xa_fail 40;
< IJ ERROR: XA_RBROLLBACK
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
< ij> xa_rollback 40;
< ij> -- get back in associated state
< xa_start xa_noflags 40;
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
< ij> -- the following should work
225 del
< GXID |STATUS |READ& |USERNAME |TYPE
226 del
< -----
227 del
< (4 |IDLE |NULL |APP |UserTransaction
227a215
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
252a241,244
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
> ij> xa_end xa_fail 40;
> IJ ERROR: XA_RBROLLBACK
> ij> select * from global_xactTable where gxid is not null order by gxid;
256,261d247
< ij> xa_end xa_fail 40;
< IJ ERROR: XA_RBROLLBACK
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
265a252,256
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
> ij> -- set up dead state
> xa_end xa_fail 40;
> IJ ERROR: XA_RBROLLBACK
> ij> select * from global_xactTable where gxid is not null order by gxid;
269,275d259
< ij> -- set up dead state
< xa_end xa_fail 40;
< IJ ERROR: XA_RBROLLBACK
< ij> select * from global_xactTable where gxid is not null order by gxid;
< GXID |STATUS |READ& |USERNAME |TYPE
< -----
< (4 |IDLE |NULL |APP |UserTransaction
390 del
< GXID |STATUS |READ& |USERNAME |TYPE
391 del
< -----
392 del
< (6 |IDLE |NULL |APP |UserTransaction
392a374
> ERROR XJ05C: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a
> global transaction.
Test Failed.
*** End: xaStateTran jdk1.5.0_02 DerbyNetClient
derbynetclientmats:derbynetclientmats 2006-
--
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
