You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2006/04/11 16:49:53 UTC
svn commit: r393239 [1/4] - in /db/derby/code/trunk/java:
drda/org/apache/derby/impl/drda/ engine/org/apache/derby/impl/jdbc/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/o...
Author: rhillegas
Date: Tue Apr 11 07:49:30 2006
New Revision: 393239
URL: http://svn.apache.org/viewcvs?rev=393239&view=rev
Log:
Commit patch for DERBY-1178: fix DRDA serialization of SQLExceptions for JDBC4 exception subclasses. Eliminate many jdk16-specific test canons.
Added:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/dblook_test.out (with props)
Removed:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/LOBTest.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/csPrepStmt.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/forupdate.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/holdCursorIJ.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/holdCursorJDBC30.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/holdCursorJavaReflection.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/nullSQLText.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/odbc_metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/optimizerOverrides.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/prepStmt.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/savepointJdbc30_JSR169.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/secureUsers.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/setTransactionIsolation.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/supersimple.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/syscat.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/testij.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/unaryArithmeticDynamicParameter.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/users.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/users2.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/Stream.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/Stream.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/LOBTest.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/Stream.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/XATest.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/csPrepStmt.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/forupdate.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/holdCursorIJ.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/holdCursorJDBC30.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/holdCursorJava.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/holdCursorJavaReflection.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/nullSQLText.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/odbc_metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/optimizerOverrides.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/prepStmt.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/savepointJdbc30_JSR169.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/savepointJdbc30_XA.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/secureUsers.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/setTransactionIsolation.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/supersimple.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/syscat.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/testij.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/unaryArithmeticDynamicParameter.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/users2.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/xaSimplePositive.out
Modified:
db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java
db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory.java
db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory40.java
db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/Util.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/Stream.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/checkSecMgr.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/importExport.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/checkSecMgr.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/importExport.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/updatableResultSet.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/closed.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/releaseCompileLocks.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/Stream.java
Modified: db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java (original)
+++ db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java Tue Apr 11 07:49:30 2006
@@ -5324,6 +5324,10 @@
{
boolean severe = (se.getErrorCode() >= ExceptionSeverity.SESSION_SEVERITY);
String sqlerrmc = null;
+
+ // get exception which carries Derby messageID and args, per DERBY-1178
+ se = Util.getExceptionFactory().getArgumentFerry( se );
+
if (se instanceof EmbedSQLException && ! severe)
sqlerrmc = buildTokenizedSqlerrmc((EmbedSQLException) se);
else {
@@ -5341,7 +5345,6 @@
return sqlerrmc;
}
-
/**
* Build preformatted SQLException text
* for severe exceptions or SQLExceptions that are not EmbedSQLExceptions.
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory.java?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory.java Tue Apr 11 07:49:30 2006
@@ -44,4 +44,18 @@
return new EmbedSQLException(message, messageId, next, severity,
t, args);
}
+
+ /**
+ * Unpack a SQL exception, looking for an EmbedSQLException which carries
+ * the Derby messageID and args which we will serialize across DRDA so
+ * that the client can reconstitute a SQLException with appropriate text.
+ * If we are running JDBC3 or JDBC2, then we hope that the passed-in
+ * exception is already an EmbedSQLException, which carries all the
+ * information we need.
+ */
+ public SQLException getArgumentFerry(SQLException se)
+ {
+ return se;
+ }
+
}
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory40.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory40.java?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory40.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/SQLExceptionFactory40.java Tue Apr 11 07:49:30 2006
@@ -63,7 +63,14 @@
public SQLException getSQLException(String message, String messageId,
SQLException next, int severity, Throwable t, Object[] args) {
String sqlState = StandardException.getSQLStateFromIdentifier(messageId);
- SQLException ex = new SQLException(message, sqlState, severity, t);
+
+ //
+ // Create dummy exception which ferries arguments needed to serialize
+ // SQLExceptions across the DRDA network layer.
+ //
+ t = wrapArgsForTransportAcrossDRDA( message, messageId, next, severity, t, args );
+
+ SQLException ex = new SQLException(message, sqlState, severity, t);
if (sqlState.startsWith(SQLState.CONNECTIVITY_PREFIX)) {
//none of the sqlstate supported by derby belongs to
//NonTransientConnectionException
@@ -95,4 +102,38 @@
}
return ex;
}
+
+ /**
+ * Unpack the exception, looking for an EmbedSQLException which carries
+ * the Derby messageID and args which we will serialize across DRDA so
+ * that the client can reconstitute a SQLException with appropriate text.
+ * If we are running JDBC4, then the
+ * passed-in exception will hopefully wrap an informative EmbedSQLException.
+ * See wrapArgsForTransportAcrossDRDA() below.
+ */
+ public SQLException getArgumentFerry(SQLException se)
+ {
+ Throwable cause = se.getCause();
+
+ if ( (cause == null) || !(cause instanceof EmbedSQLException )) { return se; }
+ else { return (SQLException) cause; }
+ }
+
+ /**
+ * <p>
+ * The following method helps handle DERBY-1178. The problem is that we may
+ * need to serialize our final SQLException across the DRDA network layer.
+ * That serialization involves some clever encoding of the Derby messageID and
+ * arguments. Unfortunately, once we create one of the
+ * JDBC4-specific subclasses of SQLException, we lose the messageID and
+ * args. This method creates a dummy EmbedSQLException which preserves that
+ * information. We return the dummy exception.
+ * </p>
+ */
+ private SQLException wrapArgsForTransportAcrossDRDA
+ ( String message, String messageId, SQLException next, int severity, Throwable t, Object[] args )
+ {
+ return super.getSQLException( message, messageId, next, severity, t, args );
+ }
+
}
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/Util.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/Util.java?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/Util.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/Util.java Tue Apr 11 07:49:30 2006
@@ -257,8 +257,13 @@
exceptionFactory = factory;
}
+ /**
+ * Get the exception factory specific to the version of JDBC which
+ * we are running.
+ */
+ public static SQLExceptionFactory getExceptionFactory() { return exceptionFactory; }
- public static String typeName(int jdbcType) {
+ public static String typeName(int jdbcType) {
switch (jdbcType) {
case Types.BIT : return TypeId.BIT_NAME;
case JDBC30Translation.SQL_TYPES_BOOLEAN : return TypeId.BOOLEAN_NAME;
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/Stream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/Stream.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/Stream.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/Stream.out Tue Apr 11 07:49:30 2006
@@ -1,12 +1,12 @@
-get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
-get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
-Expected exception did not happen.
-get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
-get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
-Expected exception did not happen.
-get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
-get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
-Expected exception did not happen.
-get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
-get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
-Expected exception did not happen.
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
+Expected exception did not happen.
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
+Expected exception did not happen.
+get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
+get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
+Expected exception did not happen.
+get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
+get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
+Expected exception did not happen.
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out Tue Apr 11 07:49:30 2006
@@ -1,771 +1,771 @@
-Test blobclob starting
-START: prepareCLOBMAIN
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: prepareSearchClobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-prepareSearchClobTable finished
-START: prepareUnicodeTable
-START: prepareUnicodeFile
-unicode string 0 correct
-unicode string 1 correct
-unicode string 2 correct
-Finished prepareUnicodeFile
-START: setCharacterStreamTest
-Length of clob is 5009
-unicode string 0 matched
-unicode string 1 matched
-unicode string 2 matched
-EOF matched
-setCharacterStreamTest finished
-START: clobTest0
-clobTest0 finished
-START: clobTest1
-clobTest11 finished
-START: clobTest12
-Succeeded to match, row 1
-PASSED, row 1, length was 3
-Succeeded to match, row 2
-PASSED, row 2, length was 3
-Succeeded to match, row 3
-PASSED, row 3, length was 3
-Succeeded to match, row 4
-PASSED, row 4, length was 5016
-Succeeded to match, row 5
-PASSED, row 5, length was 5016
-Succeeded to match, row 6
-PASSED, row 6, length was 5016
-clobTest12 finished
-START: clobTest2
-CLOB getSubString 9905 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 1 > 0
-1(5) (len 50)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 1 > 0
-1(6) (len 1)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 9905 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 65
-EXPECTED Out of bounds exception
-2(5) (len 50) you can lead a horse to water but you can't form i
-2(6) (len 1) y
-CLOB getSubString 9905 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 26
-EXPECTED Out of bounds exception
-3(5) (len 50) a stitch in time says ouch
-3(6) (len 1) a
-CLOB getSubString 9905 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 42
-EXPECTED Out of bounds exception
-4(5) (len 50) here is a string with a return
- character
-4(6) (len 1) h
-CLOB getSubString 9905 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 56
-EXPECTED Out of bounds exception
-5(5) (len 50) test data: a string column inserted as an Ascii st
-5(6) (len 1) t
-6(0) (len 50) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
-6(1) (len 150) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(2) (len 50) I-am-hiding-here-at-position-5910-in-this-little-c
-6(3) (len 50) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(4) (len 50) wposition-69-end-of-the-first-l
-ine-we-are-now-on
-6(5) (len 50) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(6) (len 1) B
-6(7)
-wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-CLOB getSubString 9905 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 1 > 0
-7(5) (len 50)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 1 > 0
-7(6) (len 1)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 9905 > 5000
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 5000
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 5000
-EXPECTED Out of bounds exception
-8(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-8(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(6) (len 1) w
-8(7)
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(0) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(1) (len 150) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(2) (len 50) I-am-hiding-here-at-position-5910-in-this-humungus
-9(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-9(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(6) (len 1) w
-9(7)
-wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-clobTest2 finished
-START: clobTest22
-Row 1 : Succeeded
-Row 2 : Succeeded
-Row 3 : Succeeded
-Row 4 : Succeeded
-Second time Succeeded
-Row 5 : Succeeded
-Second time Succeeded
-Row 6 : Succeeded
-Second time Succeeded
-clobTest22 finished
-START: clobTest3
-Found horse in row 1 starting from position 1 at position NOTFOUND
-Found ouch in row 1 starting from position 1 at position NOTFOUND
-Found
- in row 1 starting from position 1 at position NOTFOUND
-Found in row 1 starting from position 1 at position 1
-Found Beginning in row 1 starting from position 1 at position NOTFOUND
-Found Beginning in row 1 starting from position 2 at position NOTFOUND
-Found position-69 in row 1 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 1 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 1 starting from position 1 at position NOTFOUND
-Found horse in row 2 starting from position 1 at position 16
-Found ouch in row 2 starting from position 1 at position NOTFOUND
-Found
- in row 2 starting from position 1 at position NOTFOUND
-Found in row 2 starting from position 1 at position 1
-Found Beginning in row 2 starting from position 1 at position NOTFOUND
-Found Beginning in row 2 starting from position 2 at position NOTFOUND
-Found position-69 in row 2 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 2 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 2 starting from position 1 at position NOTFOUND
-Found horse in row 3 starting from position 1 at position NOTFOUND
-Found ouch in row 3 starting from position 1 at position 23
-Found
- in row 3 starting from position 1 at position NOTFOUND
-Found in row 3 starting from position 1 at position 1
-Found Beginning in row 3 starting from position 1 at position NOTFOUND
-Found Beginning in row 3 starting from position 2 at position NOTFOUND
-Found position-69 in row 3 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 3 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 3 starting from position 1 at position NOTFOUND
-Found horse in row 4 starting from position 1 at position NOTFOUND
-Found ouch in row 4 starting from position 1 at position NOTFOUND
-Found
- in row 4 starting from position 1 at position 32
-Found in row 4 starting from position 1 at position 1
-Found Beginning in row 4 starting from position 1 at position NOTFOUND
-Found Beginning in row 4 starting from position 2 at position NOTFOUND
-Found position-69 in row 4 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 4 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 4 starting from position 1 at position NOTFOUND
-Found horse in row 5 starting from position 1 at position NOTFOUND
-Found ouch in row 5 starting from position 1 at position NOTFOUND
-Found
- in row 5 starting from position 1 at position 56
-Found in row 5 starting from position 1 at position 1
-Found Beginning in row 5 starting from position 1 at position NOTFOUND
-Found Beginning in row 5 starting from position 2 at position NOTFOUND
-Found position-69 in row 5 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 5 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 5 starting from position 1 at position NOTFOUND
-Found horse in row 6 starting from position 1 at position NOTFOUND
-Found ouch in row 6 starting from position 1 at position NOTFOUND
-Found
- in row 6 starting from position 1 at position 100
-Found in row 6 starting from position 1 at position 1
-Found Beginning in row 6 starting from position 1 at position 1
-Found Beginning in row 6 starting from position 2 at position NOTFOUND
-Found position-69 in row 6 starting from position 1 at position 69
-Found This-is-position-204 in row 6 starting from position 1 at position 204
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 6 starting from position 1 at position 9907
-Found horse in row 7 starting from position 1 at position NOTFOUND
-Found ouch in row 7 starting from position 1 at position NOTFOUND
-Found
- in row 7 starting from position 1 at position NOTFOUND
-Found in row 7 starting from position 1 at position 1
-Found Beginning in row 7 starting from position 1 at position NOTFOUND
-Found Beginning in row 7 starting from position 2 at position NOTFOUND
-Found position-69 in row 7 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 7 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 7 starting from position 1 at position NOTFOUND
-Found horse in row 8 starting from position 1 at position NOTFOUND
-Found ouch in row 8 starting from position 1 at position NOTFOUND
-Found
- in row 8 starting from position 1 at position 100
-Found in row 8 starting from position 1 at position 1
-Found Beginning in row 8 starting from position 1 at position NOTFOUND
-Found Beginning in row 8 starting from position 2 at position NOTFOUND
-Found position-69 in row 8 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 8 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 8 starting from position 1 at position NOTFOUND
-clobTest3 finished
-START: clobTest32
-Succeeded: Found unicode string 0 at position 1,row 1
-Succeeded: Found unicode string 0 at position -1,row 1
-Succeeded: Found unicode string 1 at position 1,row 2
-Succeeded: Found unicode string 1 at position -1,row 2
-Succeeded: Found unicode string 2 at position 1,row 3
-Succeeded: Found unicode string 2 at position -1,row 3
-Succeeded: Found unicode string 0 at position 1,row 4
-Succeeded: Found unicode string 0 at position 5004,row 4
-Succeeded: Found unicode string 1 at position 1,row 5
-Succeeded: Found unicode string 1 at position 5004,row 5
-Succeeded: Found unicode string 2 at position 1,row 6
-Succeeded: Found unicode string 2 at position 5004,row 6
-clobTest32 finished
-START: clobTest4
-position(clob) NOT FOUND 1 searchStr horse
-position(clob) NOT FOUND 1 searchStr ouch
-position(clob) NOT FOUND 1 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 1 searchStr Beginning
-position(clob) NOT FOUND 1 searchStr position-69
-position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 1 searchStr Position-9907
-position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 1 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 1 searchStr >150chars
-searchClob row 13 skipped (too large)
-Found horse in row 2 at position 16
-position(clob) NOT FOUND 2 searchStr ouch
-position(clob) NOT FOUND 2 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 65
-position(clob) NOT FOUND 2 searchStr Beginning
-position(clob) NOT FOUND 2 searchStr position-69
-position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 2 searchStr Position-9907
-position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 2 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 65
-position(clob) NOT FOUND 2 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 3 searchStr horse
-Found ouch in row 3 at position 23
-position(clob) NOT FOUND 3 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 26
-position(clob) NOT FOUND 3 searchStr Beginning
-position(clob) NOT FOUND 3 searchStr position-69
-position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 3 searchStr Position-9907
-position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 3 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 26
-position(clob) NOT FOUND 3 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 4 searchStr horse
-position(clob) NOT FOUND 4 searchStr ouch
-Found
- in row 4 at position 32
-position(clob) FOUND @ 1 with empty search clob in clob of length 42
-position(clob) NOT FOUND 4 searchStr Beginning
-position(clob) NOT FOUND 4 searchStr position-69
-position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 4 searchStr Position-9907
-position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 4 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 42
-position(clob) NOT FOUND 4 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 5 searchStr horse
-position(clob) NOT FOUND 5 searchStr ouch
-Found
- in row 5 at position 56
-position(clob) FOUND @ 1 with empty search clob in clob of length 56
-position(clob) NOT FOUND 5 searchStr Beginning
-position(clob) NOT FOUND 5 searchStr position-69
-position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 5 searchStr Position-9907
-Found test data: a string column inserted as an Ascii stream
- in row 5 at position 1
-position(clob) NOT FOUND 5 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 56
-position(clob) NOT FOUND 5 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 6 searchStr horse
-position(clob) NOT FOUND 6 searchStr ouch
-Found
- in row 6 at position 100
-position(clob) FOUND @ 1 with empty search clob in clob of length 10000
-Found Beginning in row 6 at position 1
-Found position-69 in row 6 at position 69
-Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
-Found Position-9907 in row 6 at position 9907
-position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream
-Found clob (row 10) in row 6 at position 1
-position(clob) FOUND @ 1 with empty search clob in clob of length 10000
-Found clob (row 12) in row 6 at position 301
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 7 searchStr horse
-position(clob) NOT FOUND 7 searchStr ouch
-position(clob) NOT FOUND 7 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 7 searchStr Beginning
-position(clob) NOT FOUND 7 searchStr position-69
-position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 7 searchStr Position-9907
-position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 7 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 7 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 8 searchStr horse
-position(clob) NOT FOUND 8 searchStr ouch
-Found
- in row 8 at position 100
-position(clob) FOUND @ 1 with empty search clob in clob of length 5000
-position(clob) NOT FOUND 8 searchStr Beginning
-position(clob) NOT FOUND 8 searchStr position-69
-position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 8 searchStr Position-9907
-position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 8 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 5000
-Found clob (row 12) in row 8 at position 1
-searchClob row 13 skipped (too large)
-testCLOB_MAIN row 9 skipped (too large)
-clobTest4 finished
-START: clobTest42
-Succeeded: Found clob at position 1,row 0
-Succeeded: Found clob at position 1,row 1
-Succeeded: Found clob at position 1,row 2
-clobTest42 finished
-START: clobTest51
-clobTest51 finished
-START: clobTest52
-create table testInteger (a integer)
-insert into testInteger values('158')
-select a from testInteger
-getClob(1)
-52: SQLException
-EXPECTED SQL Exception: Invalid data conversion: Wrong result column type for requested conversion.
-START: clobTest53
-clobTest53 finished
-START: clobTest54
-EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER. :
-end clobTest54
-START: clobTest6
- negative tests for clob.getSubstring won't run for network server until 5243 is fixed
-START: clobTest7
-clobTest7 finished
-START: clobTest8
-small string pattern
-@1 position MATCH(129)
-@2 position MATCH(2074)
-@3 position MATCH(4595)
-@4 position MATCH(34584)
-@5 position MATCH(67918)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-small java.sql.Clob pattern
-@1 position MATCH(129)
-@2 position MATCH(2074)
-@3 position MATCH(4595)
-@4 position MATCH(34584)
-@5 position MATCH(67918)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-medium string pattern
-@1 position MATCH(11253)
-@2 position MATCH(12225)
-@3 position MATCH(13478)
-@4 position MATCH(43467)
-@5 position MATCH(76801)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-medium java.sql.Clob pattern
-@1 position MATCH(11253)
-@2 position MATCH(12225)
-@3 position MATCH(13478)
-@4 position MATCH(43467)
-@5 position MATCH(76801)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-long string pattern
-@1 position MATCH(287875)
-@2 position MATCH(288847)
-@3 position MATCH(290108)
-@4 position MATCH(305102)
-@5 position MATCH(321769)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-long java.sql.Clob pattern
-@1 position MATCH(287875)
-@2 position MATCH(288847)
-@3 position MATCH(290108)
-@4 position MATCH(305102)
-@5 position MATCH(321769)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-complete clobTest8
-START: clobTest91
-done row 0, length was 0
-done row 1, length was 65
-done row 2, length was 26
-done row 3, length was 42
-done row 4, length was 56
-done row 5, length was 10000
-done row 6, length was 0
-done row 7, length was 5000
-done row 8, length was 300000
-row 9 is null, skipped
-clobTest91 finished
-START: clobTest92
-clobTest92 finished
-START: clobTest93
-clobTest92 finished
-START: clobTest94
-shortClob length after commit is 26
-clobTest94 finished
-START: clobTest95
-shortClob length after closing connection is 26
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-clobTest95 finished
-START: clobTest96
-clobTest96 finished
-START: prepareBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: prepareSearchBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: blobTest0
-blobTest0 finished
-START: blobTest2
-testing Blob.getBytes() with pos 9905 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 1 > 0
-1(5)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 1 > 0
-1(6)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 9905 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 65
-Known JCC Bug 5914
-2(5) you can lead a horse to water but you can't form i
-2(6) y
-testing Blob.getBytes() with pos 9905 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 26
-Known JCC Bug 5914
-3(5) a stitch in time says ouch
-3(6) a
-testing Blob.getBytes() with pos 9905 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 42
-Known JCC Bug 5914
-4(5) here is a string with a return
- character
-4(6) h
-testing Blob.getBytes() with pos 9905 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 56
-Known JCC Bug 5914
-5(5) test data: a string column inserted as an Ascii st
-5(6) t
-6(0) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
-6(1) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(2) I-am-hiding-here-at-position-5910-in-this-little-c
-6(3) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(4) wposition-69-end-of-the-first-l
-ine-we-are-now-on
-6(5) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(6) B
-6(7)
-wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-testing Blob.getBytes() with pos 9905 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 1 > 0
-7(5)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 1 > 0
-7(6)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 9905 > 5000
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 5000
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 5000
-Known JCC Bug 5914
-8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(6) w
-8(7)
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(0) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(1) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(2) I-am-hiding-here-at-position-5910-in-this-humungus
-9(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-9(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(6) w
-9(7)
-wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-blobTest2 finished
-START: blobTest3
-Found horse in row 2 starting from position 1 at position 16
-Found ouch in row 3 starting from position 1 at position 23
-Found
- in row 4 starting from position 1 at position 32
-Found
- in row 5 starting from position 1 at position 56
-Found
- in row 6 starting from position 1 at position 100
-Found Beginning in row 6 starting from position 1 at position 1
-Found position-69 in row 6 starting from position 1 at position 69
-Found This-is-position-204 in row 6 starting from position 1 at position 204
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
-Found Position-9907 in row 6 starting from position 1 at position 9907
-Found
- in row 8 starting from position 1 at position 100
-blobTest3 finished
-START: blobTest4
-searchBlob row 13 skipped (too large)
-Found horse in row 2 at position 16
-searchBlob row 13 skipped (too large)
-Found ouch in row 3 at position 23
-searchBlob row 13 skipped (too large)
-Found
- in row 4 at position 32
-searchBlob row 13 skipped (too large)
-Found
- in row 5 at position 56
-Found test data: a string column inserted as an Ascii stream
- in row 5 at position 1
-searchBlob row 13 skipped (too large)
-Found
- in row 6 at position 100
-Found Beginning in row 6 at position 1
-Found position-69 in row 6 at position 69
-Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
-Found Position-9907 in row 6 at position 9907
-Found blob (row 10) in row 6 at position 1
-Found blob (row 12) in row 6 at position 301
-searchBlob row 13 skipped (too large)
-searchBlob row 13 skipped (too large)
-Found
- in row 8 at position 100
-Found blob (row 12) in row 8 at position 1
-searchBlob row 13 skipped (too large)
-testBlob row 9 skipped (too large)
-blobTest4 finished
-START: blobTest51
-blobTest51 finished
-START: blobTest52
-EXPECTED SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
-START: blobTest53
-blobTest53 finished
-START: blobTest54
-EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. :
-START: blobTest6
-EXPECTED SQLSTATE(null): Invalid position 0 or length 5
-EXPECTED SQLSTATE(null): Invalid position 1 or length -76
-EXPECTED SQLSTATE(null): Search pattern cannot be null.
-EXPECTED SQLSTATE(null): Search pattern cannot be null.
-blobTest6 finished
-START: blobTest7
-blobTest7 finished
-START: blobTest91
-done row 0, length was 0
-done row 1, length was 65
-done row 2, length was 26
-done row 3, length was 42
-done row 4, length was 56
-done row 5, length was 10000
-done row 6, length was 0
-done row 7, length was 5000
-done row 8, length was 300000
-row 9 is null, skipped
-blobTest91 finished
-START: blobTest92
-Locks not held by Network Server for Blobs since they are materialized on client
-blobTest92 finished
-START: blobTest93
-blobTest93 finished
-START: blobTest94
-shortBlob length after commit is 26
-blobTest94 finished
-START: blobTest95
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-blobTest95 finished
-START: blobTest96
-blobTest96 finished
-START: clobTestSelfDestructive
-length of clob chosen is 10000
-After update
-Row 1 value.substring(0,50) is jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
-10000 total bytes read
-clobTestSelfDestructive finished
-START: clobTestSelfDestructive2
-length of clob chosen is 10000
-After drop
-Expect to get an IOException, container has been closed
-10000 total bytes read
-clobTestSelfDestructive2 finished
-START: clobNegativeTest_Derby265
------
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.::SQLSTATE: XJ001Java exception: 'ERROR 40XD0: Container has been closed: java.io.IOException'. :
-START: blobTestNegativeTest_Derby265
------
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.::SQLSTATE: XJ001Java exception: 'ERROR 40XD0: Container has been closed: java.io.IOException'. :
-FINISHED TEST blobclob :-)
-Test blobclob finished
+Test blobclob starting
+START: prepareCLOBMAIN
+===> inserting short.txt length = 56
+===> inserting littleclob.txt length = 10000
+===> inserting empty.txt length = 0
+===> inserting searchclob.txt length = 5000
+===> inserting aclob.txt length = 300000
+START: prepareSearchClobTable
+===> inserting short.txt length = 56
+===> inserting littleclob.txt length = 10000
+===> inserting empty.txt length = 0
+===> inserting searchclob.txt length = 5000
+===> inserting aclob.txt length = 300000
+prepareSearchClobTable finished
+START: prepareUnicodeTable
+START: prepareUnicodeFile
+unicode string 0 correct
+unicode string 1 correct
+unicode string 2 correct
+Finished prepareUnicodeFile
+START: setCharacterStreamTest
+Length of clob is 5009
+unicode string 0 matched
+unicode string 1 matched
+unicode string 2 matched
+EOF matched
+setCharacterStreamTest finished
+START: clobTest0
+clobTest0 finished
+START: clobTest1
+clobTest11 finished
+START: clobTest12
+Succeeded to match, row 1
+PASSED, row 1, length was 3
+Succeeded to match, row 2
+PASSED, row 2, length was 3
+Succeeded to match, row 3
+PASSED, row 3, length was 3
+Succeeded to match, row 4
+PASSED, row 4, length was 5016
+Succeeded to match, row 5
+PASSED, row 5, length was 5016
+Succeeded to match, row 6
+PASSED, row 6, length was 5016
+clobTest12 finished
+START: clobTest2
+CLOB getSubString 9905 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 1 > 0
+1(5) (len 50)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 1 > 0
+1(6) (len 1)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 9905 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 65
+EXPECTED Out of bounds exception
+2(5) (len 50) you can lead a horse to water but you can't form i
+2(6) (len 1) y
+CLOB getSubString 9905 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 26
+EXPECTED Out of bounds exception
+3(5) (len 50) a stitch in time says ouch
+3(6) (len 1) a
+CLOB getSubString 9905 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 42
+EXPECTED Out of bounds exception
+4(5) (len 50) here is a string with a return
+ character
+4(6) (len 1) h
+CLOB getSubString 9905 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 56
+EXPECTED Out of bounds exception
+5(5) (len 50) test data: a string column inserted as an Ascii st
+5(6) (len 1) t
+6(0) (len 50) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
+6(1) (len 150) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(2) (len 50) I-am-hiding-here-at-position-5910-in-this-little-c
+6(3) (len 50) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(4) (len 50) wposition-69-end-of-the-first-l
+ine-we-are-now-on
+6(5) (len 50) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(6) (len 1) B
+6(7)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+CLOB getSubString 9905 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 1 > 0
+7(5) (len 50)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 1 > 0
+7(6) (len 1)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 9905 > 5000
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 5000
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 5000
+EXPECTED Out of bounds exception
+8(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) (len 1) w
+8(7)
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(0) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(1) (len 150) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(2) (len 50) I-am-hiding-here-at-position-5910-in-this-humungus
+9(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+9(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(6) (len 1) w
+9(7)
+wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+clobTest2 finished
+START: clobTest22
+Row 1 : Succeeded
+Row 2 : Succeeded
+Row 3 : Succeeded
+Row 4 : Succeeded
+Second time Succeeded
+Row 5 : Succeeded
+Second time Succeeded
+Row 6 : Succeeded
+Second time Succeeded
+clobTest22 finished
+START: clobTest3
+Found horse in row 1 starting from position 1 at position NOTFOUND
+Found ouch in row 1 starting from position 1 at position NOTFOUND
+Found
+ in row 1 starting from position 1 at position NOTFOUND
+Found in row 1 starting from position 1 at position 1
+Found Beginning in row 1 starting from position 1 at position NOTFOUND
+Found Beginning in row 1 starting from position 2 at position NOTFOUND
+Found position-69 in row 1 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 1 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 1 starting from position 1 at position NOTFOUND
+Found horse in row 2 starting from position 1 at position 16
+Found ouch in row 2 starting from position 1 at position NOTFOUND
+Found
+ in row 2 starting from position 1 at position NOTFOUND
+Found in row 2 starting from position 1 at position 1
+Found Beginning in row 2 starting from position 1 at position NOTFOUND
+Found Beginning in row 2 starting from position 2 at position NOTFOUND
+Found position-69 in row 2 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 2 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 2 starting from position 1 at position NOTFOUND
+Found horse in row 3 starting from position 1 at position NOTFOUND
+Found ouch in row 3 starting from position 1 at position 23
+Found
+ in row 3 starting from position 1 at position NOTFOUND
+Found in row 3 starting from position 1 at position 1
+Found Beginning in row 3 starting from position 1 at position NOTFOUND
+Found Beginning in row 3 starting from position 2 at position NOTFOUND
+Found position-69 in row 3 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 3 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 3 starting from position 1 at position NOTFOUND
+Found horse in row 4 starting from position 1 at position NOTFOUND
+Found ouch in row 4 starting from position 1 at position NOTFOUND
+Found
+ in row 4 starting from position 1 at position 32
+Found in row 4 starting from position 1 at position 1
+Found Beginning in row 4 starting from position 1 at position NOTFOUND
+Found Beginning in row 4 starting from position 2 at position NOTFOUND
+Found position-69 in row 4 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 4 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 4 starting from position 1 at position NOTFOUND
+Found horse in row 5 starting from position 1 at position NOTFOUND
+Found ouch in row 5 starting from position 1 at position NOTFOUND
+Found
+ in row 5 starting from position 1 at position 56
+Found in row 5 starting from position 1 at position 1
+Found Beginning in row 5 starting from position 1 at position NOTFOUND
+Found Beginning in row 5 starting from position 2 at position NOTFOUND
+Found position-69 in row 5 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 5 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 5 starting from position 1 at position NOTFOUND
+Found horse in row 6 starting from position 1 at position NOTFOUND
+Found ouch in row 6 starting from position 1 at position NOTFOUND
+Found
+ in row 6 starting from position 1 at position 100
+Found in row 6 starting from position 1 at position 1
+Found Beginning in row 6 starting from position 1 at position 1
+Found Beginning in row 6 starting from position 2 at position NOTFOUND
+Found position-69 in row 6 starting from position 1 at position 69
+Found This-is-position-204 in row 6 starting from position 1 at position 204
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 6 starting from position 1 at position 9907
+Found horse in row 7 starting from position 1 at position NOTFOUND
+Found ouch in row 7 starting from position 1 at position NOTFOUND
+Found
+ in row 7 starting from position 1 at position NOTFOUND
+Found in row 7 starting from position 1 at position 1
+Found Beginning in row 7 starting from position 1 at position NOTFOUND
+Found Beginning in row 7 starting from position 2 at position NOTFOUND
+Found position-69 in row 7 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 7 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 7 starting from position 1 at position NOTFOUND
+Found horse in row 8 starting from position 1 at position NOTFOUND
+Found ouch in row 8 starting from position 1 at position NOTFOUND
+Found
+ in row 8 starting from position 1 at position 100
+Found in row 8 starting from position 1 at position 1
+Found Beginning in row 8 starting from position 1 at position NOTFOUND
+Found Beginning in row 8 starting from position 2 at position NOTFOUND
+Found position-69 in row 8 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 8 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 8 starting from position 1 at position NOTFOUND
+clobTest3 finished
+START: clobTest32
+Succeeded: Found unicode string 0 at position 1,row 1
+Succeeded: Found unicode string 0 at position -1,row 1
+Succeeded: Found unicode string 1 at position 1,row 2
+Succeeded: Found unicode string 1 at position -1,row 2
+Succeeded: Found unicode string 2 at position 1,row 3
+Succeeded: Found unicode string 2 at position -1,row 3
+Succeeded: Found unicode string 0 at position 1,row 4
+Succeeded: Found unicode string 0 at position 5004,row 4
+Succeeded: Found unicode string 1 at position 1,row 5
+Succeeded: Found unicode string 1 at position 5004,row 5
+Succeeded: Found unicode string 2 at position 1,row 6
+Succeeded: Found unicode string 2 at position 5004,row 6
+clobTest32 finished
+START: clobTest4
+position(clob) NOT FOUND 1 searchStr horse
+position(clob) NOT FOUND 1 searchStr ouch
+position(clob) NOT FOUND 1 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 1 searchStr Beginning
+position(clob) NOT FOUND 1 searchStr position-69
+position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 1 searchStr Position-9907
+position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 1 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 1 searchStr >150chars
+searchClob row 13 skipped (too large)
+Found horse in row 2 at position 16
+position(clob) NOT FOUND 2 searchStr ouch
+position(clob) NOT FOUND 2 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 65
+position(clob) NOT FOUND 2 searchStr Beginning
+position(clob) NOT FOUND 2 searchStr position-69
+position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 2 searchStr Position-9907
+position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 2 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 65
+position(clob) NOT FOUND 2 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 3 searchStr horse
+Found ouch in row 3 at position 23
+position(clob) NOT FOUND 3 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 26
+position(clob) NOT FOUND 3 searchStr Beginning
+position(clob) NOT FOUND 3 searchStr position-69
+position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 3 searchStr Position-9907
+position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 3 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 26
+position(clob) NOT FOUND 3 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 4 searchStr horse
+position(clob) NOT FOUND 4 searchStr ouch
+Found
+ in row 4 at position 32
+position(clob) FOUND @ 1 with empty search clob in clob of length 42
+position(clob) NOT FOUND 4 searchStr Beginning
+position(clob) NOT FOUND 4 searchStr position-69
+position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 4 searchStr Position-9907
+position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 4 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 42
+position(clob) NOT FOUND 4 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 5 searchStr horse
+position(clob) NOT FOUND 5 searchStr ouch
+Found
+ in row 5 at position 56
+position(clob) FOUND @ 1 with empty search clob in clob of length 56
+position(clob) NOT FOUND 5 searchStr Beginning
+position(clob) NOT FOUND 5 searchStr position-69
+position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 5 searchStr Position-9907
+Found test data: a string column inserted as an Ascii stream
+ in row 5 at position 1
+position(clob) NOT FOUND 5 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 56
+position(clob) NOT FOUND 5 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 6 searchStr horse
+position(clob) NOT FOUND 6 searchStr ouch
+Found
+ in row 6 at position 100
+position(clob) FOUND @ 1 with empty search clob in clob of length 10000
+Found Beginning in row 6 at position 1
+Found position-69 in row 6 at position 69
+Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
+Found Position-9907 in row 6 at position 9907
+position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream
+Found clob (row 10) in row 6 at position 1
+position(clob) FOUND @ 1 with empty search clob in clob of length 10000
+Found clob (row 12) in row 6 at position 301
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 7 searchStr horse
+position(clob) NOT FOUND 7 searchStr ouch
+position(clob) NOT FOUND 7 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 7 searchStr Beginning
+position(clob) NOT FOUND 7 searchStr position-69
+position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 7 searchStr Position-9907
+position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 7 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 7 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 8 searchStr horse
+position(clob) NOT FOUND 8 searchStr ouch
+Found
+ in row 8 at position 100
+position(clob) FOUND @ 1 with empty search clob in clob of length 5000
+position(clob) NOT FOUND 8 searchStr Beginning
+position(clob) NOT FOUND 8 searchStr position-69
+position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 8 searchStr Position-9907
+position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 8 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 5000
+Found clob (row 12) in row 8 at position 1
+searchClob row 13 skipped (too large)
+testCLOB_MAIN row 9 skipped (too large)
+clobTest4 finished
+START: clobTest42
+Succeeded: Found clob at position 1,row 0
+Succeeded: Found clob at position 1,row 1
+Succeeded: Found clob at position 1,row 2
+clobTest42 finished
+START: clobTest51
+clobTest51 finished
+START: clobTest52
+create table testInteger (a integer)
+insert into testInteger values('158')
+select a from testInteger
+getClob(1)
+52: SQLException
+EXPECTED SQL Exception: Invalid data conversion: Wrong result column type for requested conversion.
+START: clobTest53
+clobTest53 finished
+START: clobTest54
+EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
+end clobTest54
+START: clobTest6
+ negative tests for clob.getSubstring won't run for network server until 5243 is fixed
+START: clobTest7
+clobTest7 finished
+START: clobTest8
+small string pattern
+@1 position MATCH(129)
+@2 position MATCH(2074)
+@3 position MATCH(4595)
+@4 position MATCH(34584)
+@5 position MATCH(67918)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+small java.sql.Clob pattern
+@1 position MATCH(129)
+@2 position MATCH(2074)
+@3 position MATCH(4595)
+@4 position MATCH(34584)
+@5 position MATCH(67918)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+medium string pattern
+@1 position MATCH(11253)
+@2 position MATCH(12225)
+@3 position MATCH(13478)
+@4 position MATCH(43467)
+@5 position MATCH(76801)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+medium java.sql.Clob pattern
+@1 position MATCH(11253)
+@2 position MATCH(12225)
+@3 position MATCH(13478)
+@4 position MATCH(43467)
+@5 position MATCH(76801)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+long string pattern
+@1 position MATCH(287875)
+@2 position MATCH(288847)
+@3 position MATCH(290108)
+@4 position MATCH(305102)
+@5 position MATCH(321769)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+long java.sql.Clob pattern
+@1 position MATCH(287875)
+@2 position MATCH(288847)
+@3 position MATCH(290108)
+@4 position MATCH(305102)
+@5 position MATCH(321769)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+complete clobTest8
+START: clobTest91
+done row 0, length was 0
+done row 1, length was 65
+done row 2, length was 26
+done row 3, length was 42
+done row 4, length was 56
+done row 5, length was 10000
+done row 6, length was 0
+done row 7, length was 5000
+done row 8, length was 300000
+row 9 is null, skipped
+clobTest91 finished
+START: clobTest92
+clobTest92 finished
+START: clobTest93
+clobTest92 finished
+START: clobTest94
+shortClob length after commit is 26
+clobTest94 finished
+START: clobTest95
+shortClob length after closing connection is 26
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+clobTest95 finished
+START: clobTest96
+clobTest96 finished
+START: prepareBlobTable
+===> inserting short.txt length = 56
+===> inserting littleclob.txt length = 10000
+===> inserting empty.txt length = 0
+===> inserting searchclob.txt length = 5000
+===> inserting aclob.txt length = 300000
+START: prepareSearchBlobTable
+===> inserting short.txt length = 56
+===> inserting littleclob.txt length = 10000
+===> inserting empty.txt length = 0
+===> inserting searchclob.txt length = 5000
+===> inserting aclob.txt length = 300000
+START: blobTest0
+blobTest0 finished
+START: blobTest2
+testing Blob.getBytes() with pos 9905 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 1 > 0
+1(5)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 1 > 0
+1(6)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 9905 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 65
+Known JCC Bug 5914
+2(5) you can lead a horse to water but you can't form i
+2(6) y
+testing Blob.getBytes() with pos 9905 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 26
+Known JCC Bug 5914
+3(5) a stitch in time says ouch
+3(6) a
+testing Blob.getBytes() with pos 9905 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 42
+Known JCC Bug 5914
+4(5) here is a string with a return
+ character
+4(6) h
+testing Blob.getBytes() with pos 9905 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 56
+Known JCC Bug 5914
+5(5) test data: a string column inserted as an Ascii st
+5(6) t
+6(0) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
+6(1) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(2) I-am-hiding-here-at-position-5910-in-this-little-c
+6(3) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(4) wposition-69-end-of-the-first-l
+ine-we-are-now-on
+6(5) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(6) B
+6(7)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+testing Blob.getBytes() with pos 9905 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 1 > 0
+7(5)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 1 > 0
+7(6)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 9905 > 5000
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 5000
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 5000
+Known JCC Bug 5914
+8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) w
+8(7)
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(0) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(1) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(2) I-am-hiding-here-at-position-5910-in-this-humungus
+9(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+9(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(6) w
+9(7)
+wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+blobTest2 finished
+START: blobTest3
+Found horse in row 2 starting from position 1 at position 16
+Found ouch in row 3 starting from position 1 at position 23
+Found
+ in row 4 starting from position 1 at position 32
+Found
+ in row 5 starting from position 1 at position 56
+Found
+ in row 6 starting from position 1 at position 100
+Found Beginning in row 6 starting from position 1 at position 1
+Found position-69 in row 6 starting from position 1 at position 69
+Found This-is-position-204 in row 6 starting from position 1 at position 204
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
+Found Position-9907 in row 6 starting from position 1 at position 9907
+Found
+ in row 8 starting from position 1 at position 100
+blobTest3 finished
+START: blobTest4
+searchBlob row 13 skipped (too large)
+Found horse in row 2 at position 16
+searchBlob row 13 skipped (too large)
+Found ouch in row 3 at position 23
+searchBlob row 13 skipped (too large)
+Found
+ in row 4 at position 32
+searchBlob row 13 skipped (too large)
+Found
+ in row 5 at position 56
+Found test data: a string column inserted as an Ascii stream
+ in row 5 at position 1
+searchBlob row 13 skipped (too large)
+Found
+ in row 6 at position 100
+Found Beginning in row 6 at position 1
+Found position-69 in row 6 at position 69
+Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
+Found Position-9907 in row 6 at position 9907
+Found blob (row 10) in row 6 at position 1
+Found blob (row 12) in row 6 at position 301
+searchBlob row 13 skipped (too large)
+searchBlob row 13 skipped (too large)
+Found
+ in row 8 at position 100
+Found blob (row 12) in row 8 at position 1
+searchBlob row 13 skipped (too large)
+testBlob row 9 skipped (too large)
+blobTest4 finished
+START: blobTest51
+blobTest51 finished
+START: blobTest52
+EXPECTED SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
+START: blobTest53
+blobTest53 finished
+START: blobTest54
+EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'.
+START: blobTest6
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Search pattern cannot be null.
+EXPECTED SQLSTATE(null): Search pattern cannot be null.
+blobTest6 finished
+START: blobTest7
+blobTest7 finished
+START: blobTest91
+done row 0, length was 0
+done row 1, length was 65
+done row 2, length was 26
+done row 3, length was 42
+done row 4, length was 56
+done row 5, length was 10000
+done row 6, length was 0
+done row 7, length was 5000
+done row 8, length was 300000
+row 9 is null, skipped
+blobTest91 finished
+START: blobTest92
+Locks not held by Network Server for Blobs since they are materialized on client
+blobTest92 finished
+START: blobTest93
+blobTest93 finished
+START: blobTest94
+shortBlob length after commit is 26
+blobTest94 finished
+START: blobTest95
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+blobTest95 finished
+START: blobTest96
+blobTest96 finished
+START: clobTestSelfDestructive
+length of clob chosen is 10000
+After update
+Row 1 value.substring(0,50) is jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
+10000 total bytes read
+clobTestSelfDestructive finished
+START: clobTestSelfDestructive2
+length of clob chosen is 10000
+After drop
+Expect to get an IOException, container has been closed
+10000 total bytes read
+clobTestSelfDestructive2 finished
+START: clobNegativeTest_Derby265
+-----
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.
+START: blobTestNegativeTest_Derby265
+-----
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.
+FINISHED TEST blobclob :-)
+Test blobclob finished
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/checkSecMgr.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/checkSecMgr.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/checkSecMgr.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/checkSecMgr.out Tue Apr 11 07:49:30 2006
@@ -1,4 +1,4 @@
-testIllegalPropertySet
-execute the procedure setting illegal property
-Expected Security Exception
-ERROR 38000: The exception 'java.security.AccessControlException: access denied (java.util.PropertyPermission notAllowed write)' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: 'access denied (java.util.PropertyPermission notAllowed write): java.security.AccessControlException'. :
+testIllegalPropertySet
+execute the procedure setting illegal property
+Expected Security Exception
+ERROR 38000: The exception 'java.security.AccessControlException: access denied (java.util.PropertyPermission notAllowed write)' was thrown while evaluating an expression.