Example with CLOB in Oracle

21 views
Skip to first unread message

Kent Andrews

unread,
Jan 21, 2022, 12:22:36 PM1/21/22
to jDBI
Hi we are using JDBI in a microservice that uses Oracle's ojdbc8.jar to insert and update a table that has a CLOB.
We are seeing issues in that the JDBI falls back to SQL that blows up and acts like it has a 4k limit like what a Varchar2 database column type would have.

This is what we see returned from Oracle:

SQL Error [1704] [42000]: ORA-01704: string literal too long

Does someone have a git repo or quick example of how they have configured JDBI to work with Oracle table with CLOB column for Insert/Update?

Or any others face similar and have tips or thoughts? 

Much Appreciated!

Kent
Reply all
Reply to author
Forward
0 new messages