Hi,
The attached diff file is a patch to add a canon for the test tools/importExport.java when running with ibm14 jvm.
I'm attaching the actual file for good measure.
Thx, Myrna
Index: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/importExport.out =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/importExport.out (revision 0) +++ java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/importExport.out (revision 0) @@ -0,0 +1,25 @@ +Test importExport starting +testing non-existing data file +The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not found: extinout/Z.dat +testing null data file +The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE05: Data file can not be null. +testing empty table +testing empty table with Delimited format +testing empty table import Field/Char Delimiters +PASS: setup complete +testing import/export with default options +testing IE with code set 8859_1 +testing IE with delimiter and codeset +testing IE with delimiters(%, &) and Cp1252 +testing IE with delimiters(%, &) and UTF-16 +testing IE with delimiters(^, #) and WRONG ENCODEINGH +The exception 'java.lang.ExceptionInInitializerError' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.ExceptionInInitializerError'. SQLSTATE: XJ001: Java exception: 'access denied (java.lang.RuntimePermission charsetProvider): java.security.AccessControlException'. +testing datatypes that does not have Export Supprt +Column 'C1' in the table is of type BLOB, it is not supported by import/export. +Column 'C1' in the table is of type BLOB, it is not supported by import/export. +The exception 'SQL Exception: Read endOfFile at unexpected place on line 2' was thrown while evaluating an expression. SQLSTATE: XIE0E: Read endOfFile at unexpected place on line 2 +PASS: finished testing import and export +PASS: teardown complete +PASS: finished cleaning up the temporary objects from database +PASS +Test importExport finished
Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/importExport.out ___________________________________________________________________ Name: svn:eol-style + native
Test importExport starting testing non-existing data file The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not found: extinout/Z.dat testing null data file The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE05: Data file can not be null. testing empty table testing empty table with Delimited format testing empty table import Field/Char Delimiters PASS: setup complete testing import/export with default options testing IE with code set 8859_1 testing IE with delimiter and codeset testing IE with delimiters(%, &) and Cp1252 testing IE with delimiters(%, &) and UTF-16 testing IE with delimiters(^, #) and WRONG ENCODEINGH The exception 'java.lang.ExceptionInInitializerError' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.ExceptionInInitializerError'. SQLSTATE: XJ001: Java exception: 'access denied (java.lang.RuntimePermission charsetProvider): java.security.AccessControlException'. testing datatypes that does not have Export Supprt Column 'C1' in the table is of type BLOB, it is not supported by import/export. Column 'C1' in the table is of type BLOB, it is not supported by import/export. The exception 'SQL Exception: Read endOfFile at unexpected place on line 2' was thrown while evaluating an expression. SQLSTATE: XIE0E: Read endOfFile at unexpected place on line 2 PASS: finished testing import and export PASS: teardown complete PASS: finished cleaning up the temporary objects from database PASS Test importExport finished
