blobclob4blob.out

derby database source code.good for you.

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
FAIL -- unexpected exception ****************
SQLSTATE(22005): An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'INTEGER'.
START: clobTest53
clobTest53 finished
START: clobTest54
EXPECTED SQLSTATE(22005): An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Clob'.
end clobTest54
START: clobTest6
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.
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
FAIL -- unexpected exception ****************
SQLSTATE(40XL1): A lock could not be obtained within the time requested
START: clobTest93
clobTest92 finished
START: clobTest94
shortClob 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.
clobTest94 finished
START: clobTest95
shortClob length after closing connection is 26
FAIL -- unexpected exception ****************
SQLSTATE(08003): No current connection.
FAIL -- unexpected exception ****************
SQLSTATE(08003): No current connection.
FAIL -- unexpected exception ****************
SQLSTATE(08003): No current connection.
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(08003): No current connection.
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