blobclob4blob.out

derby database source code.good for you.

Test blobclob starting
START: prepareCLOBMAIN
===> 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: prepareSearchClobTable
===> 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
prepareSearchClobTable finished
START: prepareUnicodeTable
START: prepareUnicodeFile
unicode string 0 correct
unicode string 1 correct
unicode string 2 correct
Finished prepareUnicodeFile
START: setCharacterStreamTest
Length of clob is 5009
unicode string 0 matched
unicode string 1 matched
unicode string 2 matched
EOF matched
setCharacterStreamTest finished
START: clobTest0
clobTest0 finished
START: clobTest1
clobTest11 finished
START: clobTest12
Succeeded to match, row 1
PASSED, row 1, length was 3
Succeeded to match, row 2
PASSED, row 2, length was 3
Succeeded to match, row 3
PASSED, row 3, length was 3
Succeeded to match, row 4
PASSED, row 4, length was 5016
Succeeded to match, row 5
PASSED, row 5, length was 5016
Succeeded to match, row 6
PASSED, row 6, length was 5016
clobTest12 finished
START: clobTest2
CLOB getSubString 9905 > 0
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 0
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 0
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
CLOB getSubString 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
CLOB getSubString 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
CLOB getSubString 9905 > 65
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 65
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 65
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 65
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 65
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
2(5) (len 50) you can lead a horse to water but you can't form i
2(6) (len 1) y
CLOB getSubString 9905 > 26
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 26
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 26
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 26
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 26
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
3(5) (len 50) a stitch in time says ouch
3(6) (len 1) a
CLOB getSubString 9905 > 42
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 42
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 42
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 42
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 42
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
4(5) (len 50) here is a string with a return 
 character
4(6) (len 1) h
CLOB getSubString 9905 > 56
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 56
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 56
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 56
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 56
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
5(5) (len 50) test data: a string column inserted as an Ascii st
5(6) (len 1) t
6(0) (len 50) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
6(1) (len 150) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
6(2) (len 50) I-am-hiding-here-at-position-5910-in-this-little-c
6(3) (len 50) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
6(4) (len 50) wposition-69-end-of-the-first-l
ine-we-are-now-on
6(5) (len 50) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
6(6) (len 1) B
6(7) 
wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
CLOB getSubString 9905 > 0
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 0
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 204 > 0
EXPECTED SQLSTATE(XJ076): The position argument '204' exceeds the size of the BLOB/CLOB.
CLOB getSubString 68 > 0
EXPECTED SQLSTATE(XJ076): The position argument '68' exceeds the size of the BLOB/CLOB.
CLOB getSubString 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
CLOB getSubString 1 > 0
EXPECTED SQLSTATE(XJ076): The position argument '1' exceeds the size of the BLOB/CLOB.
CLOB getSubString 9905 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '9,905' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
CLOB getSubString 5910 > 5000
EXPECTED SQLSTATE(XJ076): The position argument '5,910' exceeds the size of the BLOB/CLOB.
8(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
8(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwww
8(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
8(6) (len 1) w
8(7) 
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
9(0) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
9(1) (len 150) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
9(2) (len 50) I-am-hiding-here-at-position-5910-in-this-humungus
9(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
9(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwww
9(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
9(6) (len 1) w
9(7) 
wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
clobTest2 finished
START: clobTest22
Row 1 : Succeeded
Row 2 : Succeeded
Row 3 : Succeeded
Row 4 : Succeeded
Second time Succeeded
Row 5 : Succeeded
Second time Succeeded
Row 6 : Succeeded
Second time Succeeded
clobTest22 finished
START: clobTest3
Found horse in row 1 starting from position 1 at position  NOTFOUND 
Found ouch in row 1 starting from position 1 at position  NOTFOUND 
Found 
 in row 1 starting from position 1 at position  NOTFOUND 
Found  in row 1 starting from position 1 at position 1
Found Beginning in row 1 starting from position 1 at position  NOTFOUND 
Found Beginning in row 1 starting from position 2 at position  NOTFOUND 
Found position-69 in row 1 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 1 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 1 starting from position 1 at position  NOTFOUND 
Found horse in row 2 starting from position 1 at position 16
Found ouch in row 2 starting from position 1 at position  NOTFOUND 
Found 
 in row 2 starting from position 1 at position  NOTFOUND 
Found  in row 2 starting from position 1 at position 1
Found Beginning in row 2 starting from position 1 at position  NOTFOUND 
Found Beginning in row 2 starting from position 2 at position  NOTFOUND 
Found position-69 in row 2 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 2 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 2 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 2 starting from position 1 at position  NOTFOUND 
Found horse in row 3 starting from position 1 at position  NOTFOUND 
Found ouch in row 3 starting from position 1 at position 23
Found 
 in row 3 starting from position 1 at position  NOTFOUND 
Found  in row 3 starting from position 1 at position 1
Found Beginning in row 3 starting from position 1 at position  NOTFOUND 
Found Beginning in row 3 starting from position 2 at position  NOTFOUND 
Found position-69 in row 3 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 3 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 3 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 3 starting from position 1 at position  NOTFOUND 
Found horse in row 4 starting from position 1 at position  NOTFOUND 
Found ouch in row 4 starting from position 1 at position  NOTFOUND 
Found 
 in row 4 starting from position 1 at position 32
Found  in row 4 starting from position 1 at position 1
Found Beginning in row 4 starting from position 1 at position  NOTFOUND 
Found Beginning in row 4 starting from position 2 at position  NOTFOUND 
Found position-69 in row 4 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 4 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 4 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 4 starting from position 1 at position  NOTFOUND 
Found horse in row 5 starting from position 1 at position  NOTFOUND 
Found ouch in row 5 starting from position 1 at position  NOTFOUND 
Found 
 in row 5 starting from position 1 at position 56
Found  in row 5 starting from position 1 at position 1
Found Beginning in row 5 starting from position 1 at position  NOTFOUND 
Found Beginning in row 5 starting from position 2 at position  NOTFOUND 
Found position-69 in row 5 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 5 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 5 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 5 starting from position 1 at position  NOTFOUND 
Found horse in row 6 starting from position 1 at position  NOTFOUND 
Found ouch in row 6 starting from position 1 at position  NOTFOUND 
Found 
 in row 6 starting from position 1 at position 100
Found  in row 6 starting from position 1 at position 1
Found Beginning in row 6 starting from position 1 at position 1
Found Beginning in row 6 starting from position 2 at position  NOTFOUND 
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 I-am-hiding-here-at-position-5910 in row 6 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 6 starting from position 1 at position 9907
Found horse in row 7 starting from position 1 at position  NOTFOUND 
Found ouch in row 7 starting from position 1 at position  NOTFOUND 
Found 
 in row 7 starting from position 1 at position  NOTFOUND 
Found  in row 7 starting from position 1 at position 1
Found Beginning in row 7 starting from position 1 at position  NOTFOUND 
Found Beginning in row 7 starting from position 2 at position  NOTFOUND 
Found position-69 in row 7 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 7 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 7 starting from position 1 at position  NOTFOUND 
Found horse in row 8 starting from position 1 at position  NOTFOUND 
Found ouch in row 8 starting from position 1 at position  NOTFOUND 
Found 
 in row 8 starting from position 1 at position 100
Found  in row 8 starting from position 1 at position 1
Found Beginning in row 8 starting from position 1 at position  NOTFOUND 
Found Beginning in row 8 starting from position 2 at position  NOTFOUND 
Found position-69 in row 8 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 8 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 8 starting from position 1 at position  NOTFOUND 
clobTest3 finished
START: clobTest32
Succeeded: Found unicode string 0 at position 1,row 1
Succeeded: Found unicode string 0 at position -1,row 1
Succeeded: Found unicode string 1 at position 1,row 2