db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r477196 - in /db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/ DerbyNet/ibm15/ DerbyNetClient/ibm15/ ibm15/
Date Mon, 20 Nov 2006 14:32:03 GMT
Author: myrnavl
Date: Mon Nov 20 06:32:02 2006
New Revision: 477196

URL: http://svn.apache.org/viewvc?view=rev&rev=477196
Log:
DERBY-859 - resolve failures in LOBTest, ijConnName, parameterMapping, dcl and checkSecMgr
with ibm15 by creating corresponding new masters


Added:
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/
      - copied from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out
  (props changed)
      - copied unchanged from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/checkSecMgr.out
  (props changed)
      - copied unchanged from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/checkSecMgr.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/parameterMapping.out
  (props changed)
      - copied unchanged from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/parameterMapping.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm15/
      - copied from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm15/
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm15/checkSecMgr.out
  (props changed)
      - copied unchanged from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm15/checkSecMgr.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/
      - copied from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
  (contents, props changed)
      - copied, changed from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/ijConnName.out
  (props changed)
      - copied unchanged from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/ijConnName.out
Modified:
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out

Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out?view=diff&rev=477196&r1=477195&r2=477196
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
(original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
Mon Nov 20 06:32:02 2006
@@ -68,7 +68,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (null)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -77,7 +77,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102
is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (null)
 === Columntype long varchar
 select col_3 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -91,7 +91,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (null)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -100,7 +100,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103
is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (null)
 === Columntype char(10) for bit data
 select col_4 from bit_table
 	4 getObject            ->Object'   	: byte[]
@@ -630,7 +630,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (null)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -639,7 +639,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102
is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (null)
 === Columntype long varchar
 select col_3 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -653,7 +653,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (null)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -662,7 +662,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103
is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (null)
 === Columntype char(10) for bit data
 select col_4 from bit_table
 	4 getObject            ->Object'   	: byte[]
@@ -1192,7 +1192,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (null)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -1201,7 +1201,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102
is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (null)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -1215,7 +1215,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (null)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -1224,7 +1224,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103
is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (null)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]
@@ -1733,7 +1733,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (null)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -1742,7 +1742,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102
is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (null)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -1756,7 +1756,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (null)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -1765,7 +1765,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103
is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (null)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]
@@ -2274,7 +2274,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (null)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -2283,7 +2283,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102
is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (null)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -2297,7 +2297,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type
for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (null)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -2306,7 +2306,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103
is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (null)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/checkSecMgr.out
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/parameterMapping.out
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm15/checkSecMgr.out
------------------------------------------------------------------------------
    svn:eol-style = native

Copied: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
(from r373038, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out)
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out?view=diff&rev=477196&p1=db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out&r1=373038&p2=db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out&r2=477196
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
(original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
Mon Nov 20 06:32:02 2006
@@ -185,12 +185,13 @@
 ij> -- Replace with a signed jar
 -- (self signed certificate)
 --
+-- Commands used to sign jar
 -- keytool -delete -alias emccto -keystore emcks -storepass ab987c
 -- keytool -genkey -dname "cn=EMC CTO, ou=EMC APP, o=Easy Mail Company, c=US" -alias emccto
-keypass kpi135 -keystore emcks -storepass ab987c
 -- keytool -selfcert -alias emccto -keypass kpi135 -validity 36500 -keystore emcks -storepass
ab987c
 -- keytool -keystore emcks -storepass ab987c -list -v
 -- jarsigner -keystore emcks -storepass ab987c -keypass kpi135 -signedjar dcl_emc2s.jar dcl_emc2.jar
emccto
--- keytool -delete -alias emccto -keystore emcks -storepass ab987c
+--
 --
 CALL SQLJ.REPLACE_JAR('file:extin/dcl_emc2s.jar', 'EMC.MAIL_APP');
 0 rows inserted/updated/deleted
@@ -203,22 +204,6 @@
 1                                                                                       
                                                                                         
                                                                                         
                               
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 NULL                                                                                    
                                                                                         
                                                                                         
                               
-ij> -- Jar up this database (wombat) for use in database in a jar testing
--- at the end of this script.
-disconnect;
-ij> connect 'jdbc:derby:wombat;shutdown=true';
-ERROR 08006: Database 'wombat' shutdown.
-ij> -- jar up the database
-connect 'jdbc:derby:db1;create=true';
-ij> create procedure CREATEARCHIVE(jarName VARCHAR(20), path VARCHAR(20), dbName VARCHAR(20))
-LANGUAGE JAVA PARAMETER STYLE JAVA
-NO SQL
-EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.dbjarUtil.createArchive';
-0 rows inserted/updated/deleted
-ij> call CREATEARCHIVE('ina.jar', 'wombat', 'db7');
-0 rows inserted/updated/deleted
-ij> disconnect;
-ij> connect 'jdbc:derby:wombat';
 ij> -- replace with a hacked jar file, emc.class modified to diable
 -- valid e-mail address check but using same signatures.
 -- ie direct replacement of the .class file.
@@ -236,7 +221,7 @@
 ERROR XJ001: Java exception: 'org.apache.derbyTesting.databaseclassloader.emc : (org/apache/derbyTesting/databaseclassloader/emc)
unknown constant pool entry tag at offset=10: java.lang.ClassNotFoundException'.
 ij> -- cleanup
 CALL SQLJ.REMOVE_JAR('EMC.MAIL_APP', 0);
-ERROR X0X07: Cannot remove jar file '"EMC"."MAIL_APP"' because it is on your derby.database.classpath
'"EMC"."MAIL_APP"'.
+ERROR X0X07: Cannot drop jar file '"EMC"."MAIL_APP"' because its on your db2j.database.classpath
'"EMC"."MAIL_APP"'.
 ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath', '"emcAddOn"."MailAddOn"');
 0 rows inserted/updated/deleted
 ij> CALL EMC.ADDCONTACT(99, 'cash@venture.com');
@@ -267,132 +252,4 @@
 0 rows inserted/updated/deleted
 ij> DROP TABLE EMC.CONTACTS;
 0 rows inserted/updated/deleted
-ij> disconnect;
-ij> -- test reading a database from a jar file and loading
--- classes etc. from the jars within the database.
--- first using the jar protocol and then the classpath option.
-connect 'jdbc:derby:jar:(ina.jar)db7' AS DB7;
-ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
-select * from EMC.CONTACTS;
-ID         |E_MAIL                        |OK    
--------------------------------------------------
-1          |bill@ruletheworld.com         |NULL  
-2          |penguin@antartic.com          |NULL  
-3          |big@blue.com                  |NULL  
-4          |spammer@ripoff.com            |0     
-5          |open@source.org               |1     
-ij> select e_mail, "emcAddOn".VALIDCONTACT(e_mail) from EMC.CONTACTS;
-E_MAIL                        |2     
--------------------------------------
-bill@ruletheworld.com         |0     
-penguin@antartic.com          |0     
-big@blue.com                  |0     
-spammer@ripoff.com            |0     
-open@source.org               |1     
-ij> insert into EMC.CONTACTS values(3, 'no@is_read_only.gov', NULL);
-ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
-ij> CALL EMC.ADDCONTACT(3, 'really@is_read_only.gov');
-ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
-ij> -- same set as dcl.sql for reading resources
--- VALUES EMC.GETARTICLE('graduate.txt');
--- VALUES EMC.GETARTICLE('/article/release.txt');
--- VALUES EMC.GETARTICLE('/article/fred.txt');
--- VALUES EMC.GETARTICLE('barney.txt');
--- VALUES EMC.GETARTICLE('emc.class');
--- VALUES EMC.GETARTICLE('/org/apache/derbyTesting/databaseclassloader/emc.class');
--- signed
-VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.emc');
-1                                                                                       
                                                                                         
                                                                                         
                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL                                                                                    
                                                                                         
                                                                                         
                               
-ij> -- not signed
-VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.addon.vendor.util');
-1                                                                                       
                                                                                         
                                                                                         
                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL                                                                                    
                                                                                         
                                                                                         
                               
-ij> -- ensure that a read-only database automatically gets table locking
-autocommit off;
-ij> select * from EMC.CONTACTS WITH RR;
-ID         |E_MAIL                        |OK    
--------------------------------------------------
-1          |bill@ruletheworld.com         |NULL  
-2          |penguin@antartic.com          |NULL  
-3          |big@blue.com                  |NULL  
-4          |spammer@ripoff.com            |0     
-5          |open@source.org               |1     
-ij> select TYPE, MODE, TABLENAME from syscs_diag.lock_table ORDER BY 1,2,3;
-TYPE |MODE|TABLENAME                                                                    
                                                  
--------------------------------------------------------------------------------------------------------------------------------------------
-TABLE|S   |CONTACTS                                                                     
                                                  
-ij> disconnect;
-ij> -- connect to database in jar file via classpath
--- should fail as it is not on the classpath yet.
-connect 'jdbc:derby:classpath:db7' AS DB7CLF;
-ERROR XJ004: Database 'classpath:db7' not found.
-ij> -- create a class loader for this current thread
-connect 'jdbc:derby:db1';
-ij> create procedure setDBContextClassLoader(JARNAME VARCHAR(20))
-LANGUAGE JAVA PARAMETER STYLE JAVA
-NO SQL
-EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.dbjarUtil.setDBContextClassLoader';
-0 rows inserted/updated/deleted
-ij> call setDBContextClassLoader('ina.jar');
-0 rows inserted/updated/deleted
-ij> disconnect;
-ij> connect 'jdbc:derby:classpath:db7' AS DB7CL;
-ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
-select * from EMC.CONTACTS;
-ID         |E_MAIL                        |OK    
--------------------------------------------------
-1          |bill@ruletheworld.com         |NULL  
-2          |penguin@antartic.com          |NULL  
-3          |big@blue.com                  |NULL  
-4          |spammer@ripoff.com            |0     
-5          |open@source.org               |1     
-ij> select e_mail, "emcAddOn".VALIDCONTACT(e_mail) from EMC.CONTACTS;
-E_MAIL                        |2     
--------------------------------------
-bill@ruletheworld.com         |0     
-penguin@antartic.com          |0     
-big@blue.com                  |0     
-spammer@ripoff.com            |0     
-open@source.org               |1     
-ij> insert into EMC.CONTACTS values(3, 'no@is_read_only.gov', NULL);
-ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
-ij> CALL EMC.ADDCONTACT(3, 'really@is_read_only.gov');
-ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
-ij> -- same set as dcl.sql for reading resources
--- VALUES EMC.GETARTICLE('graduate.txt');
--- VALUES EMC.GETARTICLE('/article/release.txt');
--- VALUES EMC.GETARTICLE('/article/fred.txt');
--- VALUES EMC.GETARTICLE('barney.txt');
--- VALUES EMC.GETARTICLE('emc.class');
--- VALUES EMC.GETARTICLE('/org/apache/derbyTesting/databaseclassloader/emc.class');
--- signed
-VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.emc');
-1                                                                                       
                                                                                         
                                                                                         
                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL                                                                                    
                                                                                         
                                                                                         
                               
-ij> -- not signed
-VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.addon.vendor.util');
-1                                                                                       
                                                                                         
                                                                                         
                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL                                                                                    
                                                                                         
                                                                                         
                               
-ij> -- ensure that a read-only database automatically gets table locking
-autocommit off;
-ij> select * from EMC.CONTACTS WITH RR;
-ID         |E_MAIL                        |OK    
--------------------------------------------------
-1          |bill@ruletheworld.com         |NULL  
-2          |penguin@antartic.com          |NULL  
-3          |big@blue.com                  |NULL  
-4          |spammer@ripoff.com            |0     
-5          |open@source.org               |1     
-ij> select TYPE, MODE, TABLENAME from syscs_diag.lock_table ORDER BY 1,2,3;
-TYPE |MODE|TABLENAME                                                                    
                                                  
--------------------------------------------------------------------------------------------------------------------------------------------
-TABLE|S   |CONTACTS                                                                     
                                                  
-ij> disconnect;
 ij> 

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/ijConnName.out
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message