Test characterStreams starting Test setAsciiStream into CHAR CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 1 |Lieberman ran with Gore |23 |NULL |NULL |NULL |NULL 4 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 1,Lieberman ran with Gore ,, 4,,, Results from Character Stream (read char) stream 1,Lieberman ran with Gore ,, 4,,, Results from Character Stream (read block) stream 1,Lieberman ran with Gore ,, 4,,, Test setAsciiStream into VARCHAR CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 5 |NULL |NULL |Lieberman ran with Gore |23 |NULL |NULL 8 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 5,,Lieberman ran with Gore, 8,,, Results from Character Stream (read char) stream 5,,Lieberman ran with Gore, 8,,, Results from Character Stream (read block) stream 5,,Lieberman ran with Gore, 8,,, Test setAsciiStream into LONG VARCHAR CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 9 |NULL |NULL |NULL |NULL |Lieberman ran with Gore |23 12 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 9,,,Lieberman ran with Gore 12,,, Results from Character Stream (read char) stream 9,,,Lieberman ran with Gore 12,,, Results from Character Stream (read block) stream 9,,,Lieberman ran with Gore 12,,, Test setCharacterStream into CHAR MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 13 |A Mississippi Republican |24 |NULL |NULL |NULL |NULL 14 |Lott has apologized |19 |NULL |NULL |NULL |NULL 17 |NULL |NULL |NULL |NULL |NULL |NULL Test setCharacterStream into VARCHAR MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 18 |NULL |NULL |A Mississippi Republican |24 |NULL |NULL 19 |NULL |NULL |Lott has apologized |19 |NULL |NULL 22 |NULL |NULL |NULL |NULL |NULL |NULL Test setCharacterStream into LONG VARCHAR MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 23 |NULL |NULL |NULL |NULL |A Mississippi Republican |24 24 |NULL |NULL |NULL |NULL |Lott has apologized |19 27 |NULL |NULL |NULL |NULL |NULL |NULL setAsciiStream(LONG ASCII STREAMS) AS-CHAR-18 DONE AS-VARCHAR-104 DONE AS-LONG VARCHAR-67 DONE CS-CHAR-18 DONE CS-VARCHAR-104 DONE CS-LONG VARCHAR-67 DONE ST-CHAR-18 DONE ST-VARCHAR-104 DONE ST-LONG VARCHAR-67 DONE AS-CHAR-25 DONE AS-VARCHAR-16732 DONE AS-LONG VARCHAR-14563 DONE CS-CHAR-25 DONE CS-VARCHAR-16732 DONE CS-LONG VARCHAR-14563 DONE ST-CHAR-25 DONE ST-VARCHAR-16732 DONE ST-LONG VARCHAR-14563 DONE AS-CHAR-1 DONE AS-VARCHAR-32433 DONE AS-LONG VARCHAR-32673 DONE CS-CHAR-1 DONE CS-VARCHAR-32433 DONE CS-LONG VARCHAR-32673 DONE ST-CHAR-1 DONE ST-VARCHAR-32433 DONE ST-LONG VARCHAR-32673 DONE AS-CHAR-0 DONE AS-VARCHAR-32532 DONE AS-LONG VARCHAR-32700 DONE CS-CHAR-0 DONE CS-VARCHAR-32532 DONE CS-LONG VARCHAR-32700 DONE ST-CHAR-0 DONE ST-VARCHAR-32532 DONE ST-LONG VARCHAR-32700 DONE setCharacterStream(LONG CHARACTER STREAMS WITH UNICODE) AS-CHAR-14 DONE AS-VARCHAR-93 DONE AS-LONG VARCHAR-55 DONE CS-CHAR-14 DONE CS-VARCHAR-93 DONE CS-LONG VARCHAR-55 DONE ST-CHAR-14 DONE ST-VARCHAR-93 DONE ST-LONG VARCHAR-55 DONE AS-CHAR-25 DONE AS-VARCHAR-19332 DONE AS-LONG VARCHAR-18733 DONE CS-CHAR-25 DONE CS-VARCHAR-19332 DONE CS-LONG VARCHAR-18733 DONE ST-CHAR-25 DONE ST-VARCHAR-19332 DONE ST-LONG VARCHAR-18733 DONE AS-CHAR-1 DONE AS-VARCHAR-32433 DONE AS-LONG VARCHAR-32673 DONE CS-CHAR-1 DONE CS-VARCHAR-32433 DONE CS-LONG VARCHAR-32673 DONE ST-CHAR-1 DONE ST-VARCHAR-32433 DONE ST-LONG VARCHAR-32673 DONE AS-CHAR-0 DONE AS-VARCHAR-32532 DONE AS-LONG VARCHAR-32700 DONE CS-CHAR-0 DONE CS-VARCHAR-32532 DONE CS-LONG VARCHAR-32700 DONE ST-CHAR-0 DONE ST-VARCHAR-32532 DONE ST-LONG VARCHAR-32700 DONE run test with clob column Test setAsciiStream into CHAR CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 1 |Lieberman ran with Gore |23 |NULL |NULL |NULL |NULL 4 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 1,Lieberman ran with Gore ,, 4,,, Results from Character Stream (read char) stream 1,Lieberman ran with Gore ,, 4,,, Results from Character Stream (read block) stream 1,Lieberman ran with Gore ,, 4,,, Test setAsciiStream into VARCHAR CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 5 |NULL |NULL |Lieberman ran with Gore |23 |NULL |NULL 8 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 5,,Lieberman ran with Gore, 8,,, Results from Character Stream (read char) stream 5,,Lieberman ran with Gore, 8,,, Results from Character Stream (read block) stream 5,,Lieberman ran with Gore, 8,,, Test setAsciiStream into CLOB CORRECT NUMBER OF BYTES IN STREAM MORE BYTES IN STREAM THAN PASSED IN VALUE MORE BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS BYTES IN STREAM THAN PASSED IN VALUE LESS BYTES IN ASCII STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. NULL ASCII STREAM ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 9 |NULL |NULL |NULL |NULL |Lieberman ran with Gore |23 12 |NULL |NULL |NULL |NULL |NULL |NULL Results from ASCII stream 9,,,Lieberman ran with Gore 12,,, Results from Character Stream (read char) stream 9,,,Lieberman ran with Gore 12,,, Results from Character Stream (read block) stream 9,,,Lieberman ran with Gore 12,,, Test setCharacterStream into CHAR MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 13 |A Mississippi Republican |24 |NULL |NULL |NULL |NULL 14 |Lott has apologized |19 |NULL |NULL |NULL |NULL 17 |NULL |NULL |NULL |NULL |NULL |NULL Test setCharacterStream into VARCHAR MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XCL30) An IOException was thrown when reading a 'java.sql.String' from an InputStream. EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 18 |NULL |NULL |A Mississippi Republican |24 |NULL |NULL 19 |NULL |NULL |Lott has apologized |19 |NULL |NULL 22 |NULL |NULL |NULL |NULL |NULL |NULL Test setCharacterStream into CLOB MORE CHARACTERS IN READER THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. LESS CHARACTERS IN READER STREAM THAN SPECIFIED LENGTH - REJECTED EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown EXPECTED SQL Exception: (XJ001) Java exception: 'Input stream did not have exact amount of data as the requested length.: org.apache.derby.iapi.services.io.DerbyIOException'. ID |C |CLEN |VC |VCLEN |LVC |LVCLEN ----------------------------------------------------------------------------------------------------------------------------- 23 |NULL |NULL |NULL |NULL |A Mississippi Republican |24 24 |NULL |NULL |NULL |NULL |Lott has apologized |19 27 |NULL |NULL |NULL |NULL |NULL |NULL setAsciiStream(LONG ASCII STREAMS) AS-CHAR-18 DONE AS-VARCHAR-104 DONE AS-CLOB-67 DONE CS-CHAR-18 DONE CS-VARCHAR-104 DONE CS-CLOB-67 DONE ST-CHAR-18 DONE ST-VARCHAR-104 DONE ST-CLOB-67 DONE AS-CHAR-25 DONE AS-VARCHAR-16732 DONE AS-CLOB-14563 DONE CS-CHAR-25 DONE CS-VARCHAR-16732 DONE CS-CLOB-14563 DONE ST-CHAR-25 DONE ST-VARCHAR-16732 DONE ST-CLOB-14563 DONE AS-CHAR-1 DONE AS-VARCHAR-32433 DONE AS-CLOB-32673 DONE CS-CHAR-1 DONE CS-VARCHAR-32433 DONE CS-CLOB-32673 DONE ST-CHAR-1 DONE ST-VARCHAR-32433 DONE ST-CLOB-32673 DONE AS-CHAR-0 DONE AS-VARCHAR-32532 DONE AS-CLOB-32700 DONE CS-CHAR-0 DONE CS-VARCHAR-32532 DONE CS-CLOB-32700 DONE ST-CHAR-0 DONE ST-VARCHAR-32532 DONE ST-CLOB-32700 DONE setCharacterStream(LONG CHARACTER STREAMS WITH UNICODE) AS-CHAR-14 DONE AS-VARCHAR-93 DONE AS-CLOB-55 DONE CS-CHAR-14 DONE CS-VARCHAR-93 DONE CS-CLOB-55 DONE ST-CHAR-14 DONE ST-VARCHAR-93 DONE ST-CLOB-55 DONE AS-CHAR-25 DONE AS-VARCHAR-19332 DONE AS-CLOB-18733 DONE CS-CHAR-25 DONE CS-VARCHAR-19332 DONE CS-CLOB-18733 DONE ST-CHAR-25 DONE ST-VARCHAR-19332 DONE ST-CLOB-18733 DONE AS-CHAR-1 DONE AS-VARCHAR-32433 DONE AS-CLOB-32673 DONE CS-CHAR-1 DONE CS-VARCHAR-32433 DONE CS-CLOB-32673 DONE ST-CHAR-1 DONE ST-VARCHAR-32433 DONE ST-CLOB-32673 DONE AS-CHAR-0 DONE AS-VARCHAR-32532 DONE AS-CLOB-32700 DONE CS-CHAR-0 DONE CS-VARCHAR-32532 DONE CS-CLOB-32700 DONE ST-CHAR-0 DONE ST-VARCHAR-32532 DONE ST-CLOB-32700 DONE PASS Test characterStreams finished