db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r192968 - in /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNetClient/ suites/ tests/derbynet/
Date Wed, 22 Jun 2005 18:09:02 GMT
Author: kmarsden
Date: Wed Jun 22 11:09:01 2005
New Revision: 192968

URL: http://svn.apache.org/viewcvs?rev=192968&view=rev
Log:
Replace abbreviated test netxaPositive with  xaSimplePositive  in the derbynetclientmats suite.
Tests fix for DERBY-346 which was actually fixed by Mamta's fix of DERBY-8



Added:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out
  (with props)
Removed:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/netxaPositive.sql
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/netxaPositive_app.properties
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/netxaPositive_sed.properties
Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/copyfiles.ant

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out?rev=192968&view=auto
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out
(added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out
Wed Jun 22 11:09:01 2005
@@ -0,0 +1,195 @@
+ij> xa_datasource 'wombat';
+ij> ---------------------------------------------
+----- a single connection and 1 phase commit
+-----
+xa_connect ;
+ij> xa_start xa_noflags 0;
+ij> xa_getconnection;
+ij(XA)> drop table foo;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO' because it does not exist.
+ij(XA)> create table foo (a int);
+0 rows inserted/updated/deleted
+ij(XA)> insert into foo values (0);
+1 row inserted/updated/deleted
+ij(XA)> select * from foo;
+A          
+-----
+0          
+ij(XA)> run resource '/org/apache/derbyTesting/functionTests/tests/store/global_xactTable.view';
+ij(XA)> create view global_xactTable as
+select 
+    cast(global_xid as char(2)) as gxid,
+    status,
+    case when first_instant is NULL then 'NULL' else 'false' end as readOnly,
+    cast (username as char(10)) as username,
+    type 
+from new org.apache.derby.diag.TransactionTable() t;
+0 rows inserted/updated/deleted
+ij(XA)> select * from global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(0 |ACTIVE |false |APP |UserTransaction               
+ij(XA)> xa_end xa_success 0;
+ij(XA)> xa_commit xa_1phase 0;
+ij(XA)> xa_datasource 'wombat' shutdown;
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+ij(XA)> ---------------------------------------------
+----- two interleaving connections and prepare/commit prepare/rollback
+-----
+xa_datasource 'wombat';
+ij(XA)> xa_connect user 'sku' password 'testxa' ;
+ij(XA)> xa_start xa_noflags 1;
+ij(XA)> xa_getconnection;
+ij(XA)> insert into APP.foo values (1);
+1 row inserted/updated/deleted
+ij(XA)> xa_end xa_suspend 1;
+ij(XA)> xa_start xa_noflags 2;
+ij(XA)> insert into APP.foo values (2);
+1 row inserted/updated/deleted
+ij(XA)> xa_end xa_suspend 2;
+ij(XA)> xa_start xa_resume 1;
+ij(XA)> insert into APP.foo values (3);
+1 row inserted/updated/deleted
+ij(XA)> xa_end xa_suspend 1;
+ij(XA)> xa_start xa_resume 2;
+ij(XA)> insert into APP.foo values (4);
+1 row inserted/updated/deleted
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(1 |ACTIVE |false |SKU |UserTransaction               
+(2 |ACTIVE |false |SKU |UserTransaction               
+ij(XA)> -- this prepare won't work since transaction 1 has been suspended - XA_PROTO
+xa_prepare 1;
+IJ ERROR: XAER_PROTO 
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(1 |ACTIVE |false |SKU |UserTransaction               
+(2 |ACTIVE |false |SKU |UserTransaction               
+ij(XA)> xa_end xa_success 2;
+ij(XA)> -- this assumes a resume
+xa_end xa_success 1;
+ij(XA)> xa_prepare 1;
+ij(XA)> xa_prepare 2;
+ij(XA)> -- both transactions should be prepared
+select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(1 |PREPARED |false |SKU |UserTransaction               
+(2 |PREPARED |false |SKU |UserTransaction               
+ij(XA)> -- NOTE: The following call to "xa_recover xa_startrscan" is apt to
+----- return the result set rows in reverse order when changes to
+----- the Derby engine affect the number of transactions that it takes
+----- to create a database.  The transactions are stored in a hash table
+----- based on a global and local id, and when the number of transactions
+----- changes, the (internal) local id can change, which may lead to a
+----- change in the result set order.  This order is determined by the
+----- JVM's hashing algorithm. Examples of changes to the engine that
+----- can affect this include ones that cause more commits or that
+----- change the amount of data being stored, such as changes to the
+----- metadata statements (which is what prompted this explanation in
+----- the first place).  Ultimately, the problem is that there is no
+----- way to order the return values from "xa_recover" since it is an
+----- ij internal statement, not SQL...
+xa_recover xa_startrscan;
+Recovered 2 in doubt transactions
+Transaction 1 : {ClientXid: formatID(2), gtrid_length(6), bqual_length(6), data(776F6D62
6174776F 6D626174)}
+Transaction 2 : {ClientXid: formatID(1), gtrid_length(6), bqual_length(6), data(776F6D62
6174776F 6D626174)}
+ij(XA)> xa_recover xa_noflags;
+Recovered 0 in doubt transactions
+ij(XA)> xa_commit xa_2Phase 1;
+ij(XA)> xa_rollback 2;
+ij(XA)> -- check results
+xa_start xa_noflags 3;
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(3 |IDLE |NULL |SKU |UserTransaction               
+ij(XA)> select * from APP.foo;
+A          
+-----
+0          
+1          
+3          
+ij(XA)> xa_end xa_success 3;
+ij(XA)> xa_prepare 3;
+ij(XA)> -- should fail with XA_NOTA because we prepared a read only transaction 
+xa_commit xa_1Phase 3;
+IJ ERROR: XAER_NOTA 
+ij(XA)> disconnect;
+ij> ---------------------------------------------
+----- 3 interleaving xa connections and a local connection
+-----
+xa_start xa_noflags 4;
+ij> xa_end xa_suspend 4;
+ij> xa_start xa_noflags 5;
+ij> xa_end xa_suspend 5;
+ij> xa_start xa_noflags 6;
+ij> xa_end xa_suspend 6;
+ij> connect 'wombat' as local;
+ij(LOCAL)> select * from foo;
+A          
+-----
+0          
+1          
+3          
+ij(LOCAL)> xa_start xa_resume 4;
+ij(LOCAL)> xa_getconnection;
+ij(XA)> insert into APP.foo values (4);
+1 row inserted/updated/deleted
+ij(XA)> disconnect;
+ij> set connection local;
+ij(LOCAL)> insert into foo values (77);
+1 row inserted/updated/deleted
+ij(LOCAL)> xa_end xa_suspend 4;
+ij(LOCAL)> xa_end xa_success 4;
+ij(LOCAL)> -- this getconnection should get a local connection
+----- this has problems
+-----xa_getconnection;
+-----insert into APP.foo values (88);
+-----commit;
+-----disconnect;
+xa_start xa_resume 5;
+ij(LOCAL)> xa_getconnection;
+ij(XA)> insert into APP.foo values (5);
+1 row inserted/updated/deleted
+ij(XA)> xa_end xa_success 5;
+ij(XA)> xa_start xa_resume 6;
+ij(XA)> insert into APP.foo values (6);
+1 row inserted/updated/deleted
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(4 |ACTIVE |false |SKU |UserTransaction               
+(5 |ACTIVE |false |SKU |UserTransaction               
+(6 |ACTIVE |false |SKU |UserTransaction               
+ij(XA)> xa_commit xa_1Phase 4;
+ij(XA)> insert into APP.foo values (6);
+1 row inserted/updated/deleted
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(5 |ACTIVE |false |SKU |UserTransaction               
+(6 |ACTIVE |false |SKU |UserTransaction               
+ij(XA)> xa_end xa_fail 6;
+IJ ERROR: XA_RBROLLBACK 
+ij(XA)> xa_rollback 6;
+ij(XA)> xa_start xa_join 5;
+ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid;
+GXID |STATUS |READ& |USERNAME |TYPE                          
+-----
+(5 |ACTIVE |false |SKU |UserTransaction               
+ij(XA)> select * from APP.foo;
+A          
+-----
+0          
+1          
+3          
+4          
+77         
+5          
+ij(XA)> xa_end xa_success 5;
+ij(XA)> xa_prepare 5;
+ij(XA)> xa_commit xa_2Phase 5;
+ij(XA)> 

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/xaSimplePositive.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall?rev=192968&r1=192967&r2=192968&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
Wed Jun 22 11:09:01 2005
@@ -1,2 +1,2 @@
-derbynet/netxaPositive.sql
+jdbcapi/xaSimplePositive.sql
 jdbcapi/xaStateTran.sql

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/copyfiles.ant?rev=192968&r1=192967&r2=192968&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/copyfiles.ant
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/copyfiles.ant
Wed Jun 22 11:09:01 2005
@@ -7,9 +7,6 @@
 dataSourcePermissions_net_sed.properties
 default_app.properties
 default_derby.properties
-netxaPositive.sql
-netxaPositive_app.properties
-netxaPositive_sed.properties
 runtimeinfo_sed.properties
 sysinfo_sed.properties
 testij.sql



Mime
View raw message