blobclob4blob.out

derby database source code.good for you.

START: blobTest2
testing Blob.getBytes() with pos 9905 > 0
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 0
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 0
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 9905 > 65
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 65
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 65
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 65
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 65
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
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
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 26
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 26
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 26
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 26
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
3(5) a stitch in time says ouch
3(6) a
testing Blob.getBytes() with pos 9905 > 42
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 42
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 42
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 42
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 42
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
4(5) here is a string with a return 
 character
4(6) h
testing Blob.getBytes() with pos 9905 > 56
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 56
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 56
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 56
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 56
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
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
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 204 > 0
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 68 > 0
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 9905 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
testing Blob.getBytes() with pos 5910 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
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
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found horse in row 2 at position 16
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found ouch in row 3 at position 23
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found 
 in row 4 at position 32
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found 
 in row 5 at position 56
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
Found test data: a string column inserted as an Ascii stream
 in row 5 at position 1
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found 
 in row 6 at position 100
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
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
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
Found blob (row 12)  in row 6 at position 301
searchBlob row 13 skipped (too large)
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
searchBlob row 13 skipped (too large)
Found 
 in row 8 at position 100
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
FAIL -- unexpected exception ****************
SQLSTATE(XJ077): Got an exception when trying to read the first byte/character of the BLOB/CLOB pattern using getBytes/getSubString.
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
FAIL -- unexpected exception ****************
SQLSTATE(22005): An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'INTEGER'.
START: blobTest53
blobTest53 finished
START: blobTest54
FAIL -- unexpected exception ****************
SQLSTATE(22005): An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Blob'.
START: blobTest6
EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method.
EXPECTED SQLSTATE(XJ071): Zero or negative length argument '-76' passed in a BLOB or CLOB method.
EXPECTED SQLSTATE(XJ071): Zero or negative length argument '0' passed in a BLOB or CLOB method.
EXPECTED SQLSTATE(XJ070): Negative or zero position argument '-4,000' passed in a Blob or Clob method.
EXPECTED SQLSTATE(XJ072): Null pattern or searchStr passed in to a BLOB or CLOB position method.
EXPECTED SQLSTATE(XJ070): Negative or zero position argument '-42' passed in a Blob or Clob method.
EXPECTED SQLSTATE(XJ072): Null pattern or searchStr passed in to a BLOB or CLOB position method.
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
FAIL -- unexpected exception ****************
SQLSTATE(40XL1): A lock could not be obtained within the time requested
START: blobTest93
blobTest93 finished
START: blobTest94
shortBlob length after commit is 26
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
blobTest94 finished
START: blobTest95
shortBlob length after closing the connection is 26
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is 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
EXPECTED IO Exception:ERROR 40XD0: Container has been closed
START: clobNegativeTest_Derby265
-----------------------------
EXPECTED SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
START: blobTestNegativeTest_Derby265
-----------------------------
EXPECTED SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.  The BLOB or CLOBs transaction may be committed, or its connection is closed.
FINISHED TEST blobclob :-)
Test blobclob finished