derby database source code.good for you.

				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:SQL Exception: Input stream cannot have negative length.				===> testing using setCharacterStream with -1 as length				PASS -- expected exception:SQL Exception: Input stream cannot have negative length.				===> testing using setBinaryStream with -1 as length				PASS -- expected exception:SQL Exception: 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				======================================				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