Test streamingColumn starting ===> testing extin/short.data length = 56 No truncation and hence no error ===> testing extin/shortbanner length = 8282 No truncation and hence no error ===> testing extin/derby.banner length = 414000 expected exception for data > 32700 in length ===> testing extin/empty.data length = 0 No truncation and hence no error ===> verified length 56 ===> verified length 8282 ===> verified length 0 ===> verified length 56 ===> verified length 8282 ===> verified length 0 ===> verified length 56 ===> verified length 8282 ===> verified length 0 ===> verified length 56 ===> verified length 8282 ===> verified length 0 expect to get null string back a = -1 got null string back a = -1 got null string back ===> testing extin/short.data length = 56 ===> testing extin/shortbanner length = 8282 ===> testing extin/derby.banner length = 414000 ===> testing extin/empty.data length = 0 streamTest7 Starting streamTest8(conn, 10, 2500) Finishing streamTest8(conn, 10, 2500) Starting streamTest9(conn, 10, 2500) Finishing streamTest9(conn, 10, 2500) Starting streamTest8(conn, 2500, 10) Finishing streamTest8(conn, 2500, 10) Starting streamTest9(conn, 2500, 10) Finishing streamTest9(conn, 2500, 10) Testing 10 starts from here ===> testing extin/short.data length = 56 No truncation and hence no error ===> testing extin/shortbanner length = 8282 No truncation and hence no error ===> testing extin/derby.banner length = 414000 expected exception for data > 32700 in length ===> testing extin/empty.data length = 0 No truncation and hence no error Testing 10 ends in here Test 11 - Can't pass negative length as the stream length for various setXXXStream methods ===> testing using setAsciiStream with -2 as length PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length. ===> testing using setCharacterStream with -1 as length PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length. ===> testing using setBinaryStream with -1 as length PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length. Test 11 - negative stream length tests end in here Test 12 - varchar truncation tests start from here ===> testing(using setAsciiStream) extin/char32675trailingblanks.data length = 32675 No truncation and hence no error ===> testing(using setCharacterStream) extin/char32675trailingblanks.data length = 32675 No truncation and hence no error ===> testing trailing blanks(using setString) length = 32675 No truncation and hence no error ===> testing trailing blanks(using setObject) length = 32675 No truncation and hence no error ===> testing trailing blanks using concatenation No truncation and hence no error. ===> testing(using setAsciiStream) extin/char32675.data length = 32675 expected exception for data > 32672 in length ===> testing(using setCharacterStream) extin/char32675.data length = 32675 expected exception for data > 32672 in length ===> testing trailing non-blanks(using setString) length = 32675 expected exception for data > 32672 in length ===> testing trailing non-blanks(using setObject) length = 32675 expected exception for data > 32672 in length ===> testing trailing non-blank characters using concatenation expected exception for data > 32672 in length ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 Test 12 - varchar truncation tests end in here Test 13 - long varchar truncation tests start from here ===> testing(using setAsciiStream) extin/char32703trailingblanks.data length = 32703 expected exception for data > 32700 in length ===> testing(using setCharacterStream) extin/char32703trailingblanks.data length = 32703 expected exception for data > 32700 in length ===> testing trailing blanks(using setString) length = 32703 expected exception for data > 32700 in length ===> testing trailing blanks(using setObject) length = 32703 expected exception for data > 32700 in length ===> testing(using setAsciiStream) extin/char32703.data length = 32703 expected exception for data > 32700 in length ===> testing(using setCharacterStream) extin/char32703.data length = 32703 expected exception for data > 32700 in length ===> testing trailing non-blanks(using setString) length = 32703 expected exception for data > 32700 in length ===> testing trailing non-blanks(using setObject) length = 32703 expected exception for data > 32700 in length Test 13 - long varchar truncation tests end in here Test 14 - clob truncation tests start from here ===> testing(using setAsciiStream) extin/char32675trailingblanks.data length = 32675 No truncation and hence no error ===> testing(using setCharacterStream) extin/char32675trailingblanks.data length = 32675 No truncation and hence no error ===> testing trailing blanks(using setString) length = 32675 No truncation and hence no error ===> testing trailing blanks(using setObject) length = 32675 No truncation and hence no error ===> testing trailing blanks using concatenation No truncation and hence no error. ===> testing(using setAsciiStream) extin/char32675.data length = 32675 EXPECTED SQLSTATE(XSDA4): An unexpected exception was thrown EXPECTED SQLSTATE(XJ001): Java exception: 'A truncation error was encountered trying to shrink CLOB 'XXXX' to length 32672.: org.apache.derby.iapi.services.io.DerbyIOException'. ===> testing(using setCharacterStream) extin/char32675.data length = 32675 EXPECTED SQLSTATE(XSDA4): An unexpected exception was thrown EXPECTED SQLSTATE(XJ001): Java exception: 'A truncation error was encountered trying to shrink CLOB 'XXXX' to length 32672.: org.apache.derby.iapi.services.io.DerbyIOException'. ===> testing trailing non-blanks(using setString) length = 32675 expected exception for data > 32672 in length ===> testing trailing non-blanks(using setObject) length = 32675 expected exception for data > 32672 in length ===> testing trailing non-blank characters using concatenation expected exception for data > 32672 in length ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 ===> verified length 32672 Test 14 - clob truncation tests end in here ====================================== START DERBY-500 TEST Inserting rows Rows inserted =10 Rows selected =10 Update qualifies many rows + streams EXPECTED EXCEPTION - streams cannot be re-used EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'. Rows selected =10 DERBY500 #2 Rows updated =1 Rows selected =1 DERBY500 #3 Rows deleted =10 Rows selected =0 DERBY500 #4 Rows deleted =0 Rows selected =0 EXPECTED EXCEPTION - streams cannot be re-used EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'. END DERBY-500 TEST ====================================== ====================================== START DERBY-500 TEST for varchar Rows inserted =10 Rows selected =10 DERBY500 for varchar #1 Rows updated =11 Rows selected =10 DERBY500 for varchar #2 Rows updated =1 Rows selected =1 DERBY500 for varchar #3 Rows deleted =11 Rows selected =0 DERBY500 for varchar #4 Rows deleted =0 Rows selected =0 END DERBY-500 TEST for varchar ====================================== Test streamingColumn finished