Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support CLOB and BLOB #28

Open
Tracked by #600
christophd opened this issue May 30, 2018 · 1 comment
Open
Tracked by #600

Support CLOB and BLOB #28

christophd opened this issue May 30, 2018 · 1 comment
Labels
commissioned An issue whose solution was commissioned by a customer. Prio: Low TO REVIEW Type: Enhancement
Milestone
v0.2.0

Comments

@christophd
Copy link
Member

When executing update statements driver throws exception:

java.sql.SQLException: Not supported JDBC prepared statement function 'setClob'"
@christophd christophd added this to the v0.1.5 milestone May 30, 2018
@christophd
Copy link
Member Author

We need to transfer the CLOB data stream to the citrus-db server. Same thing for BLOB data streams. I suggest to load the CLOB stream as String data as a first implementation. The BLOB stream could be transformed into a base64 encoded String for transmission to the server.

@svettwer svettwer mentioned this issue Jan 24, 2019
Open
4 tasks
@svettwer svettwer modified the milestones: v0.1.5, v2.9.0 Jan 24, 2019
@svettwer svettwer added IN PROGRESS and removed READY labels Mar 7, 2019
@svettwer svettwer changed the title Support CLOB for SQL update Support CLOB and BLOB for SQL update Mar 7, 2019
@svettwer svettwer changed the title Support CLOB and BLOB for SQL update Support CLOB and BLOB Mar 7, 2019
svettwer added a commit to citrusframework/citrus that referenced this issue Mar 7, 2019
@svettwer
(citrusframework/citrus-db#28) Added missing catches for assertion er…
e0d54ae 
…rors + some cleanup
svettwer added a commit to citrusframework/citrus that referenced this issue Mar 7, 2019
@svettwer
(citrusframework/citrus-db#28) Added clob integration test
3311cf1
svettwer added a commit that referenced this issue Mar 8, 2019
@svettwer
(#28) Added createClob implementation to jdbc connection
063a51d
svettwer added a commit that referenced this issue Mar 8, 2019
@svettwer
(#28) Added length, getSubString, getCharacterStream and setString Im…
f521169 
…plementation
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added equals test
1e18d47
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added getAsciiStream implementation
1096e91
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added position implementation for string needle
4ac4d3e
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added position implementation for clob needle
2b56b65
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added setString with offset replacement
e743d74
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added setAsciiStream
a5bf371
svettwer added a commit that referenced this issue Mar 11, 2019
@svettwer
(#28) Added setCharacterStream
917dd0f
svettwer added a commit that referenced this issue Mar 12, 2019
@svettwer
(#28) Updated equals verifier due to qno/equalsverifier#234
082e579
svettwer added a commit that referenced this issue Mar 12, 2019
@svettwer
(#28) Updated equals verifier due to jqno/equalsverifier#234
8699871
svettwer added a commit that referenced this issue Mar 22, 2019
@svettwer
(#28) Added truncate implementation
3cd3e64
svettwer added a commit that referenced this issue Mar 22, 2019
@svettwer
(#28) Added free implementation
5ff47a7
svettwer added a commit that referenced this issue Mar 22, 2019
@svettwer
(#28) Added getCharacterStream of substring
4c8a5f8
svettwer added a commit that referenced this issue Mar 22, 2019
@svettwer
(#28) some cleanup
2e1b347
svettwer added a commit that referenced this issue Mar 22, 2019
@svettwer
(#28) Added setClob implementations in JdbcPreparedStatement
c847681
svettwer added a commit that referenced this issue Apr 11, 2019
@svettwer
(#28) Added getBytes, setBytes and length implementation
74ca876
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added getBinaryStream
ff965a6
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added truncate
fbae5c8
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added free
e6d68cc
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Removed unnecessary throws
220c512
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) changes access to constructor to package-private
73cf049
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added getClob by index
5cd5bda
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added getClob by name
3d6ef4c
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added getBlob
c8cc8b9
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added getBlob to JdbcResultSet + Altered Blob IT
0070aab
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added common create Blob functionality
dd2d28d
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added setBlob functionality
f485b33
svettwer added a commit that referenced this issue Apr 12, 2019
@svettwer
(#28) Added setBlob functionality to JdbcPreparedStatement
75d4934
svettwer added a commit to citrusframework/citrus that referenced this issue Apr 12, 2019
@svettwer
(citrusframework/citrus-db#28) Added getBlob to JdbcResultSet + Alter…
8a7f079 
…ed Blob IT
svettwer added a commit that referenced this issue Apr 15, 2019
@svettwer
(#28) Added Base64 encoding to binary data to be able to compare valu…
91a0054 
…es without triggering citrus variable substitution
svettwer added a commit that referenced this issue Apr 15, 2019
@svettwer
(#28) Added position by byte pattern implementation
931a700
svettwer added a commit that referenced this issue Apr 15, 2019
@svettwer
(#28) Added position by blob pattern implementation
97d3a81
svettwer added a commit to citrusframework/citrus that referenced this issue Apr 15, 2019
@svettwer
(citrusframework/citrus-db#28) Added Base64 encoding to binary data t…
b90bdfc 
…o be able to compare values without triggering citrus variable substitution
svettwer added a commit that referenced this issue Apr 17, 2019
@svettwer
(#28) Added getBinaryStream with limitation
be92434
svettwer added a commit that referenced this issue Apr 17, 2019
@svettwer
(#28) Added setBinaryStream
bf84552
svettwer added a commit that referenced this issue Apr 17, 2019
@svettwer
(#28) Some cleanup
cac5e0f
svettwer added a commit that referenced this issue Apr 17, 2019
@svettwer
(#28) Fixed Base64 import
410f577
svettwer added a commit that referenced this issue Apr 17, 2019
@svettwer
(#28) updated deploy plugin in demo
dba4c54
svettwer added a commit to citrusframework/citrus that referenced this issue Apr 17, 2019
@svettwer
(citrusframework/citrus-db#28) Migrated tests to CitrusTestRunner
6c6a326
This was referenced Apr 17, 2019
Merged
Merged
svettwer added a commit that referenced this issue Jun 13, 2019
@svettwer
(#28) Added test for parameter ordering issues
6b1aca4
@svettwer svettwer added the commissioned An issue whose solution was commissioned by a customer. label Aug 5, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
commissioned An issue whose solution was commissioned by a customer. Prio: Low TO REVIEW Type: Enhancement
Projects
None yet
Milestone
v0.2.0
Development

No branches or pull requests
2 participants
@christophd @svettwer