Test blobclob starting START: prepareCLOBMAIN ===> inserting short.utf length = 56 ===> inserting littleclob.utf length = 10000 ===> inserting empty.utf length = 0 ===> inserting searchclob.utf length = 5000 ===> inserting aclob.utf length = 300000 START: prepareSearchClobTable ===> inserting short.utf length = 56 ===> inserting littleclob.utf length = 10000 ===> inserting empty.utf length = 0 ===> inserting searchclob.utf length = 5000 ===> inserting 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: clobTest13Trigger testCLOB_MAIN: NULL testCLOB_MAIN: length 0 crc32 0 0 testCLOB_MAIN: length 0 crc32 0 0 testCLOB_MAIN: length 26 crc32 3726329377 26 testCLOB_MAIN: length 42 crc32 384104526 42 testCLOB_MAIN: length 56 crc32 4255880856 56 testCLOB_MAIN: length 65 crc32 3470395945 65 testCLOB_MAIN: length 5000 crc32 2272896610 5000 testCLOB_MAIN: length 10000 crc32 1814912934 10000 testCLOB_MAIN: length 300000 crc32 3781770763 300000 main update row count :10 row trigger: NULL row trigger: length 0 crc32 0 0 row trigger: length 0 crc32 0 0 row trigger: length 26 crc32 3726329377 26 row trigger: length 42 crc32 384104526 42 row trigger: length 56 crc32 4255880856 56 row trigger: length 65 crc32 3470395945 65 row trigger: length 5000 crc32 2272896610 5000 row trigger: length 10000 crc32 1814912934 10000 row trigger: length 300000 crc32 3781770763 300000 statement trigger: NULL statement trigger: length 0 crc32 0 0 statement trigger: length 0 crc32 0 0 statement trigger: length 26 crc32 3726329377 26 statement trigger: length 42 crc32 384104526 42 statement trigger: length 56 crc32 4255880856 56 statement trigger: length 65 crc32 3470395945 65 statement trigger: length 5000 crc32 2272896610 5000 statement trigger: length 10000 crc32 1814912934 10000 statement trigger: length 300000 crc32 3781770763 300000 clobTest13Trigger 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. 1(5) (len 50) 1(6) (len 1) 1(7) (len 0) 1(8) (len 0) 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 2(7) (len 0) 2(8) (len 0) 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 3(7) (len 0) 3(8) (len 0) 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 4(7) (len 0) 4(8) (len 0) 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 5(7) (len 0) 5(8) (len 0) 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) (len 0) 6(8) (len 0) 6(9) 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. 7(5) (len 50) 7(6) (len 1) 7(7) (len 0) 7(8) (len 0) 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) (len 0) 8(8) (len 0) 8(9) 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) (len 0) 9(8) (len 0) 9(9) 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 Succeeded: Found unicode string 1 at position -1,row 2 Succeeded: Found unicode string 2 at position 1,row 3 Succeeded: Found unicode string 2 at position -1,row 3 Succeeded: Found unicode string 0 at position 1,row 4 Succeeded: Found unicode string 0 at position 5004,row 4 Succeeded: Found unicode string 1 at position 1,row 5 Succeeded: Found unicode string 1 at position 5004,row 5 Succeeded: Found unicode string 2 at position 1,row 6 Succeeded: Found unicode string 2 at position 5004,row 6 clobTest32 finished START: clobTest4 position(clob) NOT FOUND 1 searchStr horse position(clob) NOT FOUND 1 searchStr ouch position(clob) NOT FOUND 1 searchStr position(clob) FOUND @ 1 with empty search clob in clob of length 0 position(clob) NOT FOUND 1 searchStr Beginning position(clob) NOT FOUND 1 searchStr position-69 position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 1 searchStr Position-9907 position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 1 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 0 position(clob) NOT FOUND 1 searchStr >150chars searchClob row 13 skipped (too large) Found horse in row 2 at position 16 position(clob) NOT FOUND 2 searchStr ouch position(clob) NOT FOUND 2 searchStr position(clob) FOUND @ 1 with empty search clob in clob of length 65 position(clob) NOT FOUND 2 searchStr Beginning position(clob) NOT FOUND 2 searchStr position-69 position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 2 searchStr Position-9907 position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 2 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 65 position(clob) NOT FOUND 2 searchStr >150chars searchClob row 13 skipped (too large) position(clob) NOT FOUND 3 searchStr horse Found ouch in row 3 at position 23 position(clob) NOT FOUND 3 searchStr position(clob) FOUND @ 1 with empty search clob in clob of length 26 position(clob) NOT FOUND 3 searchStr Beginning position(clob) NOT FOUND 3 searchStr position-69 position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 3 searchStr Position-9907 position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 3 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 26 position(clob) NOT FOUND 3 searchStr >150chars searchClob row 13 skipped (too large) position(clob) NOT FOUND 4 searchStr horse position(clob) NOT FOUND 4 searchStr ouch Found in row 4 at position 32 position(clob) FOUND @ 1 with empty search clob in clob of length 42 position(clob) NOT FOUND 4 searchStr Beginning position(clob) NOT FOUND 4 searchStr position-69 position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 4 searchStr Position-9907 position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 4 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 42 position(clob) NOT FOUND 4 searchStr >150chars searchClob row 13 skipped (too large) position(clob) NOT FOUND 5 searchStr horse position(clob) NOT FOUND 5 searchStr ouch Found in row 5 at position 56 position(clob) FOUND @ 1 with empty search clob in clob of length 56 position(clob) NOT FOUND 5 searchStr Beginning position(clob) NOT FOUND 5 searchStr position-69 position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 5 searchStr Position-9907 Found test data: a string column inserted as an Ascii stream in row 5 at position 1 position(clob) NOT FOUND 5 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 56 position(clob) NOT FOUND 5 searchStr >150chars searchClob row 13 skipped (too large) position(clob) NOT FOUND 6 searchStr horse position(clob) NOT FOUND 6 searchStr ouch Found in row 6 at position 100 position(clob) FOUND @ 1 with empty search clob in clob of length 10000 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 position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream Found clob (row 10) in row 6 at position 1 position(clob) FOUND @ 1 with empty search clob in clob of length 10000 Found clob (row 12) in row 6 at position 301 searchClob row 13 skipped (too large) position(clob) NOT FOUND 7 searchStr horse position(clob) NOT FOUND 7 searchStr ouch position(clob) NOT FOUND 7 searchStr position(clob) FOUND @ 1 with empty search clob in clob of length 0 position(clob) NOT FOUND 7 searchStr Beginning position(clob) NOT FOUND 7 searchStr position-69 position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 7 searchStr Position-9907 position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 7 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 0 position(clob) NOT FOUND 7 searchStr >150chars searchClob row 13 skipped (too large) position(clob) NOT FOUND 8 searchStr horse position(clob) NOT FOUND 8 searchStr ouch Found in row 8 at position 100 position(clob) FOUND @ 1 with empty search clob in clob of length 5000 position(clob) NOT FOUND 8 searchStr Beginning position(clob) NOT FOUND 8 searchStr position-69 position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910 position(clob) NOT FOUND 8 searchStr Position-9907 position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream position(clob) NOT FOUND 8 searchStr >150chars position(clob) FOUND @ 1 with empty search clob in clob of length 5000 Found clob (row 12) in row 8 at position 1 searchClob row 13 skipped (too large) testCLOB_MAIN row 9 skipped (too large) clobTest4 finished START: clobTest42 Succeeded: Found clob at position 1,row 0 Succeeded: Found clob at position 1,row 1 Succeeded: Found clob at position 1,row 2 clobTest42 finished START: clobTest51 clobTest51 finished START: clobTest52 create table testInteger (a integer) insert into testInteger values('158') select a from testInteger getClob(1) 52: SQLException EXPECTED SQL Exception: An attempt was made to get a data value of type 'java.sql.Types 4' from a data value of type 'java.sql.Clob'. START: clobTest53 clobTest53 finished START: clobTest54 EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER. end clobTest54 START: clobTest6 EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method. EXPECTED SQLSTATE(XJ071): Negative length argument '-76' passed in a BLOB or CLOB method. EXPECTED SQLSTATE(XJ071): Negative length argument '-1' passed in a BLOB or CLOB method. EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method. EXPECTED SQLSTATE(XJ076): The position argument '2' exceeds the size of the BLOB/CLOB. 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. clobTest6 finished START: clobTest7 clobTest7 finished START: clobTest8 small string pattern @1 position MATCH(129) @2 position MATCH(2074) @3 position MATCH(4595) @4 position MATCH(34584) @5 position MATCH(67918) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) small java.sql.Clob pattern @1 position MATCH(129) @2 position MATCH(2074) @3 position MATCH(4595) @4 position MATCH(34584) @5 position MATCH(67918) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) medium string pattern @1 position MATCH(11253) @2 position MATCH(12225) @3 position MATCH(13478) @4 position MATCH(43467) @5 position MATCH(76801) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) medium java.sql.Clob pattern @1 position MATCH(11253) @2 position MATCH(12225) @3 position MATCH(13478) @4 position MATCH(43467) @5 position MATCH(76801) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) long string pattern @1 position MATCH(287875) @2 position MATCH(288847) @3 position MATCH(290108) @4 position MATCH(305102) @5 position MATCH(321769) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) long java.sql.Clob pattern @1 position MATCH(287875) @2 position MATCH(288847) @3 position MATCH(290108) @4 position MATCH(305102) @5 position MATCH(321769) @6 position MATCH(-1) @7 position MATCH(-1) @8 position MATCH(-1) @9 position MATCH(-1) @10 position MATCH(-1) complete clobTest8 START: clobTest91 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 clobTest91 finished START: clobTest92 clobTest92 finished START: clobTest93 clobTest92 finished START: clobTest94 shortClob length after commit is 26 clobTest94 finished 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 short.utf length = 56 ===> inserting littleclob.utf length = 10000 ===> inserting empty.utf length = 0 ===> inserting searchclob.utf length = 5000 ===> inserting aclob.utf length = 300000 START: prepareSearchBlobTable ===> inserting short.utf length = 56 ===> inserting littleclob.utf length = 10000 ===> inserting empty.utf length = 0 ===> inserting searchclob.utf length = 5000 ===> inserting aclob.utf length = 300000 START: blobTest0 Row Count 9 Null Row 1 blobTest0 finished 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. 1(5) 1(6) 1(7) 1(8) 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 2(7) 2(8) 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 3(7) 3(8) 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 4(7) 4(8) 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 5(7) 5(8) 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) 6(8) 6(9) 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. 7(5) 7(6) 7(7) 7(8) 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) 8(8) 8(9) 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) 9(8) 9(9) 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(22005): An attempt was made to get a data value of type 'java.sql.Types 4' from a data value of type 'java.sql.Blob'. blobTest52 finished 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'. blobTest54 finished START: blobTest6 EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method. EXPECTED SQLSTATE(XJ071): Negative length argument '-76' passed in a BLOB or CLOB method. EXPECTED SQLSTATE(XJ071): Negative length argument '-1' passed in a BLOB or CLOB method. EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method. EXPECTED SQLSTATE(XJ076): The position argument '2' exceeds the size of the BLOB/CLOB. 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: blobTest8Trigger Row Count 0 Null Row 0 Row Count 9 Null Row 1 Row Count 9 Null Row 1 blobTest8Trigger 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(08003): Lob method called after connection was closed EXPECTED SQLSTATE(08003): Lob method called after connection was closed EXPECTED SQLSTATE(08003): Lob method called after connection was closed EXPECTED SQLSTATE(08003): Lob method called after connection was closed EXPECTED SQLSTATE(08003): Lob method called after connection was closed EXPECTED SQLSTATE(08003): 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 ----- START: blobTestNegativeTest_Derby265 ----- FINISHED TEST blobclob :-) Test blobclob finished