db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davi...@apache.org
Subject svn commit: r386169 [26/36] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Date Wed, 15 Mar 2006 21:31:59 GMT
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users.out
Wed Mar 15 13:31:53 2006
@@ -0,0 +1,153 @@
+ij> --
+connect 'wombat;create=true;user=dan;password=MakeItFaster';
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> prepare p1 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION1)> execute p1 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+Statement executed.
+ij(CONNECTION1)> execute p1 using 'values(''derby.database.fullAccessUsers'', ''francois,jeff,howardR,ames,kreg'')';
+Statement executed.
+ij(CONNECTION1)> remove p1;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> autocommit on;
+ij(CONNECTION1)> disconnect;
+ij> connect 'wombat;shutdown=true;user=francois;password=paceesalute';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+ij> connect 'myDB;create=true;user=dan;password=MakeItFaster';
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> prepare p2 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION1)> execute p2 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+Statement executed.
+ij(CONNECTION1)> execute p2 using 'values(''derby.database.fullAccessUsers'', ''jerry,kreg,dan,jamie,ames,francois'')';
+Statement executed.
+ij(CONNECTION1)> remove p2;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> autocommit on;
+ij(CONNECTION1)> disconnect;
+ij> connect 'myDB;shutdown=true;user=dan;password=MakeItFaster';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'myDB' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> -- Specifically test JBMS users.
+-----
+----- check allowed users in wombat db.
+connect 'wombat;user=kreg;password=visualWhat?';
+ij> connect 'wombat;user=jeff;password=HomeRun61';
+ij(CONNECTION1)> connect 'wombat;user=ames;password=AnyVolunteer?';
+ij(CONNECTION2)> connect 'wombat;user=howardR;password=IamBetterAtTennis';
+ij(CONNECTION3)> connect 'wombat;user=francois;password=paceesalute';
+ij(CONNECTION4)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION1 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION2 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION3 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION4* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+* = current connection
+ij(CONNECTION4)> disconnect all;
+ij> -- check allowed users in myDB db.
+----- also check USER flavors
+connect 'myDB;user=jerry;password=SacreBleu';
+ij> create table APP.t1(c1 char(30) check (UPPER(c1) <> 'JAMIE'));
+0 rows inserted/updated/deleted
+ij> insert into APP.t1 values CURRENT_USER;
+1 row inserted/updated/deleted
+ij> connect 'myDB;user=kreg;password=visualWhat?';
+ij(CONNECTION1)> insert into APP.t1 values USER;
+1 row inserted/updated/deleted
+ij(CONNECTION1)> connect 'myDB;user=ames;password=AnyVolunteer?';
+ij(CONNECTION2)> insert into APP.t1 values SESSION_USER;
+1 row inserted/updated/deleted
+ij(CONNECTION2)> connect 'myDB;user=dan;password=MakeItFaster';
+ij(CONNECTION3)> select * from APP.t1;
+C1                            
+-----
+JERRY                         
+KREG                          
+AMES                          
+ij(CONNECTION3)> update APP.t1 set c1 = {fn user() };
+3 rows inserted/updated/deleted
+ij(CONNECTION3)> select * from APP.t1;
+C1                            
+-----
+DAN                           
+DAN                           
+DAN                           
+ij(CONNECTION3)> connect 'myDB;user=francois;password=paceesalute';
+ij(CONNECTION4)> update APP.t1 set c1 = USER;
+3 rows inserted/updated/deleted
+ij(CONNECTION4)> connect 'myDB;user=jamie;password=MrNamePlates';
+ij(CONNECTION5)> select * from APP.t1;
+C1                            
+-----
+FRANCOIS                      
+FRANCOIS                      
+FRANCOIS                      
+ij(CONNECTION5)> update APP.t1 set c1 = USER;
+ERROR 23513: The check constraint 'xxxxGENERATED-IDxxxx' was violated while performing an
INSERT or UPDATE on table 'APP.T1'. : 
+ij(CONNECTION5)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION1 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION2 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION3 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION4 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION5* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+* = current connection
+ij(CONNECTION5)> disconnect all;
+ij> --
+----- some negative cases
+-----
+----- Invalid login's
+connect 'wombat';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=badUser1;password=YeeHa!';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=badUser2;password=YeeHa!';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'myDB;user=dan;password=MakeItSlower';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'myDB;user=jamie;password=LetMeIn';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=francois;password=Corsica';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> -- Invalid database users
+connect 'myDB;user=howardR;password=IamBetterAtTennis';
+ERROR 04501: DERBY SQL error: SQLCODE: -1, SQLSTATE: 04501, SQLERRMC: Database connection
refused.
+ij> connect 'wombat;user=jerry;password=SacreBleu';
+ERROR 04501: DERBY SQL error: SQLCODE: -1, SQLSTATE: 04501, SQLERRMC: Database connection
refused.
+ij> connect 'wombat;user=jamie;password=MrNamePlates';
+ERROR 04501: DERBY SQL error: SQLCODE: -1, SQLSTATE: 04501, SQLERRMC: Database connection
refused.
+ij> show connections;
+No connections available.
+ij> connect 'wombat;user=francois;password=paceesalute';
+ij> connect 'myDB;user=jerry;password=SacreBleu';
+ij(CONNECTION1)> -- Database shutdown - check user - should fail
+connect 'myDB;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION1)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION1)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
+ERROR 04501: DERBY SQL error: SQLCODE: -1, SQLSTATE: 04501, SQLERRMC: Database connection
refused.
+ij(CONNECTION1)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION1* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+* = current connection
+ij(CONNECTION1)> -- Database shutdown - check user - should succeed
+----- beetle 5367
+connect 'wombat;user=francois;password=paceesalute;shutdown=true';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+ij(CONNECTION1)> connect 'myDB;user=jerry;password=SacreBleu;shutdown=true';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'myDB' shutdown.
+ij(CONNECTION1)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION1* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+* = current connection
+ij(CONNECTION1)> -- JBMS System shutdown - check user - should fail
+connect ';user=jamie;password=LetMeIn;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION1)> disconnect all;
+ij> -- JBMS System shutdown - check user - should succeed
+connect ';user=francois;password=paceesalute;shutdown=true';
+ERROR XJ015: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ015, SQLERRMC: Derby system shutdown.
+ij> -- beetle 5390
+----- the server does not shut down properly in network server
+;
+ij> 

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users2.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users2.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users2.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users2.out
Wed Mar 15 13:31:53 2006
@@ -0,0 +1,241 @@
+ij> --
+----- Specifically test Derby users using DERBY scheme
+----- and by only looking at database properties for authentication
+----- The only user at the system level is system/manager
+-----
+----- check allowed users in wombat db.
+----- initial connection in sysprop was:
+----- connect 'wombat;create=true;user=system;password=manager';
+-----
+----- Default to: derby.authentication.provider=BUILTIN
+-----
+autocommit off;
+ij> prepare p1 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij> execute p1 using 'values(''derby.connection.requireAuthentication'', ''true'')';
+Statement executed.
+ij> commit;
+ij> remove p1;
+ij> autocommit on;
+ij> disconnect all;
+ij> connect 'wombat;shutdown=true;user=system;password=manager';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> connect 'wombat;user=system;password=manager';
+ij> --
+----- set authentication config for 'wombat' database
+-----
+autocommit off;
+ij> prepare p2 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij> execute p2 using 'values(''derby.user.kreg'', ''visualWhat?'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.user.jeff'', ''HomeRun61'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.user.ames'', ''AnyVolunteer?'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.user.jamie'', ''MrNamePlates'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.user.howardR'', ''IamBetterAtTennis'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.user.francois'', ''paceesalute'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.database.fullAccessUsers'', ''jeff,howardR,ames,francois,kreg'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.database.readOnlyAccessUsers'', ''jamie'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+Statement executed.
+ij> execute p2 using 'values(''derby.database.propertiesOnly'', ''true'')';
+Statement executed.
+ij> commit;
+ij> autocommit on;
+ij> -- Check that the passwords are encrypted
+----- values getDatabaseProperty('derby.user.francois');
+----- values getDatabaseProperty('derby.user.ames');
+----- values getDatabaseProperty('derby.user.kreg');
+----- values getDatabaseProperty('derby.user.jeff');
+----- values getDatabaseProperty('derby.user.howardR');
+----- values getDatabaseProperty('derby.user.jamie');
+connect 'wombat;user=kreg;password=visualWhat?';
+ij(CONNECTION1)> connect 'wombat;user=jeff;password=HomeRun61';
+ij(CONNECTION2)> connect 'wombat;user=ames;password=AnyVolunteer?';
+ij(CONNECTION3)> connect 'wombat;user=howardR;password=IamBetterAtTennis';
+ij(CONNECTION4)> -- should succeed
+create table APP.t1(c1 char(30));
+0 rows inserted/updated/deleted
+ij(CONNECTION4)> insert into APP.t1 values CURRENT_USER;
+1 row inserted/updated/deleted
+ij(CONNECTION4)> connect 'wombat;user=jamie;password=MrNamePlates';
+ij(CONNECTION5)> -- should fail as readOnly user
+insert into APP.t1 values CURRENT_USER;
+ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
: 
+ij(CONNECTION5)> create table APP.t2(c1 char(30));
+ERROR 25503: DDL is not permitted for a read-only connection, user or database. : 
+ij(CONNECTION5)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION1 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION2 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION3 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION4 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION5* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+* = current connection
+ij(CONNECTION5)> disconnect all;
+ij> -- check allowed users in myDB db.
+-----
+connect 'myDB;create=true;user=system;password=manager';
+ij> autocommit off;
+ij> prepare p3 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij> execute p3 using 'values(''derby.connection.requireAuthentication'', ''true'')';
+Statement executed.
+ij> remove p3;
+ij> autocommit on;
+ij> disconnect all;
+ij> connect 'myDB;shutdown=true;user=system;password=manager';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'myDB' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> connect 'myDB;user=system;password=manager';
+ij> --
+----- set authentication config for 'myDB' database
+-----
+autocommit off;
+ij> prepare p4 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij> execute p4 using 'values(''derby.user.kreg'', ''visualWhat?'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.user.dan'', ''MakeItFaster'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.user.ames'', ''AnyVolunteer?'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.user.jerry'', ''SacreBleu'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.user.jamie'', ''MrNamePlates'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.user.francois'', ''paceesalute'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.database.fullAccessUsers'', ''jerry,dan,kreg,ames,francois,jamie'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+Statement executed.
+ij> execute p4 using 'values(''derby.database.propertiesOnly'', ''true'')';
+Statement executed.
+ij> commit;
+ij> autocommit on;
+ij> -- Check that the passwords are encrypted
+----- values getDatabaseProperty('derby.user.francois');
+----- values getDatabaseProperty('derby.user.ames');
+----- values getDatabaseProperty('derby.user.kreg');
+----- values getDatabaseProperty('derby.user.dan');
+----- values getDatabaseProperty('derby.user.jerry');
+----- values getDatabaseProperty('derby.user.jamie');
+-----
+----- also check USER flavors
+-----
+connect 'myDB;user=jerry;password=SacreBleu';
+ij(CONNECTION1)> create table APP.t1(c1 char(30) check (UPPER(c1) <> 'JAMIE'));
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> insert into APP.t1 values CURRENT_USER;
+1 row inserted/updated/deleted
+ij(CONNECTION1)> connect 'myDB;user=kreg;password=visualWhat?';
+ij(CONNECTION2)> insert into APP.t1 values USER;
+1 row inserted/updated/deleted
+ij(CONNECTION2)> connect 'myDB;user=ames;password=AnyVolunteer?';
+ij(CONNECTION3)> insert into APP.t1 values SESSION_USER;
+1 row inserted/updated/deleted
+ij(CONNECTION3)> connect 'myDB;user=dan;password=MakeItFaster';
+ij(CONNECTION4)> select * from APP.t1;
+C1                            
+-----
+JERRY                         
+KREG                          
+AMES                          
+ij(CONNECTION4)> update APP.t1 set c1 = USER;
+3 rows inserted/updated/deleted
+ij(CONNECTION4)> select * from APP.t1;
+C1                            
+-----
+DAN                           
+DAN                           
+DAN                           
+ij(CONNECTION4)> connect 'myDB;user=francois;password=paceesalute';
+ij(CONNECTION5)> update APP.t1 set c1 = USER;
+3 rows inserted/updated/deleted
+ij(CONNECTION5)> connect 'myDB;user=jamie;password=MrNamePlates';
+ij(CONNECTION6)> select * from APP.t1;
+C1                            
+-----
+FRANCOIS                      
+FRANCOIS                      
+FRANCOIS                      
+ij(CONNECTION6)> update APP.t1 set c1 = USER;
+ERROR 23513: The check constraint 'xxxxGENERATED-IDxxxx' was violated while performing an
INSERT or UPDATE on table 'APP.T1'. : 
+ij(CONNECTION6)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION1 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION2 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION3 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION4 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION5 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+CONNECTION6* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+* = current connection
+ij(CONNECTION6)> disconnect all;
+ij> --
+----- some negative cases
+-----
+----- Invalid login's
+connect 'wombat';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=badUser1;password=YeeHa!';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=badUser2;password=YeeHa!';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'myDB;user=dan;password=MakeItSlower';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'myDB;user=jamie;password=LetMeIn';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=francois;password=Corsica';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> -- Invalid database users
+connect 'myDB;user=howardR;password=IamBetterAtTennis';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=jerry;password=SacreBleu';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> connect 'wombat;user=jamie;password=MrNamePlates';
+ij> show connections;
+CONNECTION0* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+* = current connection
+ij> connect 'wombat;user=francois;password=paceesalute';
+ij(CONNECTION1)> connect 'myDB;user=jerry;password=SacreBleu';
+ij(CONNECTION2)> -- Database shutdown - check user - should fail
+connect 'myDB;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION2)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION2)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij(CONNECTION2)> show connections;
+CONNECTION0 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION1 - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat
+CONNECTION2* - 	jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB
+* = current connection
+ij(CONNECTION2)> disconnect all;
+ij> show connections;
+No connections available.
+ij> -- Database shutdown - check user - should succeed
+connect 'wombat;user=francois;password=paceesalute;shutdown=true';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> connect 'myDB;user=jerry;password=SacreBleu;shutdown=true';
+ERROR 08006: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'myDB' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> -- there should be no connections left here
+show connections;
+No connections available.
+ij> -- JBMS System shutdown - check user - should fail
+connect ';user=jamie;password=LetMeIn;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred.  Reason: userid invalid.
+ij> -- JBMS System shutdown - check user - should succeed
+connect ';user=system;password=manager;shutdown=true';
+ERROR XJ015: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ015, SQLERRMC: Derby system shutdown.
+ij> 

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/xaSimplePositive.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/xaSimplePositive.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/xaSimplePositive.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/xaSimplePositive.out
Wed Mar 15 13:31:53 2006
@@ -0,0 +1,238 @@
+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 syscs_diag.transaction_table;
+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)> drop table APP.foo;
+0 rows inserted/updated/deleted
+ij(XA)> xa_end xa_success 5;
+ij(XA)> xa_prepare 5;
+ij(XA)> xa_commit xa_2Phase 5;
+ij(XA)> ---------------------------------------------
+----- Test procedure with server-side JDBC
+-----
+----- local transaction
+create table t1(i int not null primary key, b char(15));
+0 rows inserted/updated/deleted
+ij(XA)> insert into t1 values (1,'one'), (2, 'two'), (3,'three');
+3 rows inserted/updated/deleted
+ij(XA)> create procedure DRS(p1 int) parameter style JAVA READS SQL DATA dynamic result
sets 1 language java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows';
+0 rows inserted/updated/deleted
+ij(XA)> call DRS(1);
+I |B              
+-----
+1 |one            
+ij(XA)> drop table t1;
+0 rows inserted/updated/deleted
+ij(XA)> drop procedure DRS;
+0 rows inserted/updated/deleted
+ij(XA)> commit;
+ij(XA)> --- global transaction
+xa_start xa_noflags 6;
+ij(XA)> create table t1(i int not null primary key, b char(15));
+0 rows inserted/updated/deleted
+ij(XA)> insert into t1 values (1,'one'), (2, 'two'), (3,'three');
+3 rows inserted/updated/deleted
+ij(XA)> create procedure DRS(p1 int) parameter style JAVA READS SQL DATA dynamic result
sets 1 language java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows';
+0 rows inserted/updated/deleted
+ij(XA)> call DRS(1);
+I |B              
+-----
+1 |one            
+ij(XA)> drop procedure DRS;
+0 rows inserted/updated/deleted
+ij(XA)> drop table t1;
+0 rows inserted/updated/deleted
+ij(XA)> drop view APP.global_xacttable;
+0 rows inserted/updated/deleted
+ij(XA)> drop schema sku restrict;
+0 rows inserted/updated/deleted
+ij(XA)> xa_end xa_success 6;
+ij(XA)> xa_commit xa_1Phase 6;
+ij(XA)> 

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/SURTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/SURTest.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/SURTest.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/SURTest.out
Wed Mar 15 13:31:53 2006
@@ -0,0 +1,68 @@
+.............E.E.E.E.E.E.E.E......F.E.F.E.E.E.E.........
+....E.E.E.E.E.E.E.E......F.E.F.E.E.E.E.............E.E.E.E.E.
+E.E.E......F.E.F.E.E.E.E.............E.E.E.E.E.E.E.E......F.
+E.F.E.E.E.E
+There were 52 errors:
+1) testIndexedScrollInsensitiveUpdateCursorWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+2) testIndexedScrollInsensitiveUpdateCursorWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+3) testPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+4) testOtherPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+5) testOtherAndOwnPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+6) testMultipleKeyUpdates(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+7) testSecondaryIndexKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+8) testOtherSecondaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+9) testScrollInsensitiveConcurUpdatableWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+10) testScrollInsensitiveConcurUpdatableWithForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+11) testScrollInsensitiveConcurUpdatableWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+12) testScrollInsensitiveConcurUpdatableWithoutForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+13) testScrollInsensitiveConcurUpdatableWithoutForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+14) testIndexedScrollInsensitiveUpdateCursorWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+15) testIndexedScrollInsensitiveUpdateCursorWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+16) testPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+17) testOtherPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+18) testOtherAndOwnPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+19) testMultipleKeyUpdates(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+20) testSecondaryIndexKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+21) testOtherSecondaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+22) testScrollInsensitiveConcurUpdatableWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+23) testScrollInsensitiveConcurUpdatableWithForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+24) testScrollInsensitiveConcurUpdatableWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+25) testScrollInsensitiveConcurUpdatableWithoutForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+26) testScrollInsensitiveConcurUpdatableWithoutForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+27) testIndexedScrollInsensitiveUpdateCursorWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+28) testIndexedScrollInsensitiveUpdateCursorWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+29) testPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+30) testOtherPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+31) testOtherAndOwnPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+32) testMultipleKeyUpdates(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+33) testSecondaryIndexKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+34) testOtherSecondaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+35) testScrollInsensitiveConcurUpdatableWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+36) testScrollInsensitiveConcurUpdatableWithForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+37) testScrollInsensitiveConcurUpdatableWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+38) testScrollInsensitiveConcurUpdatableWithoutForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+39) testScrollInsensitiveConcurUpdatableWithoutForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+40) testIndexedScrollInsensitiveUpdateCursorWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+41) testIndexedScrollInsensitiveUpdateCursorWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+42) testPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+43) testOtherPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+44) testOtherAndOwnPrimaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+45) testMultipleKeyUpdates(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+46) testSecondaryIndexKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+47) testOtherSecondaryKeyUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+48) testScrollInsensitiveConcurUpdatableWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+49) testScrollInsensitiveConcurUpdatableWithForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+50) testScrollInsensitiveConcurUpdatableWithoutForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+51) testScrollInsensitiveConcurUpdatableWithoutForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+52) testScrollInsensitiveConcurUpdatableWithoutForUpdate3(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)java.sql.SQLException:
'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
+There were 8 failures:
+1) testScrollablePositionedUpdateWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Expected row to be updated by own change,  however did not get updated value for column a
expected:<666> but was:<0>
+2) testScrollInsensitiveConcurUpdatableWithForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Invalid resultset concurrency on statement expected:<1008> but was:<1007>
+3) testScrollablePositionedUpdateWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Expected row to be updated by own change,  however did not get updated value for column a
expected:<666> but was:<0>
+4) testScrollInsensitiveConcurUpdatableWithForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Invalid resultset concurrency on statement expected:<1008> but was:<1007>
+5) testScrollablePositionedUpdateWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Expected row to be updated by own change,  however did not get updated value for column a
expected:<666> but was:<0>
+6) testScrollInsensitiveConcurUpdatableWithForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Invalid resultset concurrency on statement expected:<1008> but was:<1007>
+7) testScrollablePositionedUpdateWithForUpdate1(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Expected row to be updated by own change,  however did not get updated value for column a
expected:<666> but was:<0>
+8) testScrollInsensitiveConcurUpdatableWithForUpdate2(org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest)junit.framework.AssertionFailedError:
Invalid resultset concurrency on statement expected:<1008> but was:<1007>
+FAILURES!!!
+Tests run: 128,  Failures: 8,  Errors: 52

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/Stream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/Stream.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/Stream.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/Stream.out
Wed Mar 15 13:31:53 2006
@@ -0,0 +1,16 @@
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
+Expected exception may happen.
+java.sql.SQLException: Stream of column value in result cannot be retrieved twice
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
+Expected exception may happen.
+java.sql.SQLException: Stream of column value in result cannot be retrieved twice
+get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
+get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
+Expected exception may happen.
+java.sql.SQLException: Stream of column value in result cannot be retrieved twice
+get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
+get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
+Expected exception may happen.
+java.sql.SQLException: Stream of column value in result cannot be retrieved twice



Mime
View raw message