blobclob4blob.out

derby database source code.good for you.

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 extin/short.utf length = 56
===> inserting extin/littleclob.utf length = 10000
===> inserting extin/empty.utf length = 0
===> inserting extin/searchclob.utf length = 5000
===> inserting extin/aclob.utf length = 300000
START: prepareSearchBlobTable
===> inserting extin/short.utf length = 56
===> inserting extin/littleclob.utf length = 10000
===> inserting extin/empty.utf length = 0
===> inserting extin/searchclob.utf length = 5000
===> inserting extin/aclob.utf 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: XJ001: Java 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: XJ001: Java exception: 'ERROR 40XD0: Container has been closed: java.io.IOException'.
FINISHED TEST blobclob :-)
Test blobclob finished