Jdbc, Clobs and Strings

Aino Andriessen 1
0 0
Read Time:20 Second

Clob handling in jdbc can be a tedious job, especially because it required the use of Oracle specific extensions. With the 10g release this has been simplified and Clobs can now be handled using the standard apis. It’s described in this document.
Especially the SetBigStringTryClob connection property comes in handy. For example, it’s used in the Jira Oracle 10g configuration of the jndi DataSource (connectionProperties=”SetBigStringTryClob=true”).

About Post Author

Aino Andriessen

Aino Andriessen is principal consultant and expertise lead 'Continuous Delivery'. His focus is on Oracle Fusion Middleware ADF and SOA development, Continuous Delivery, architecture, improving the software development proces and quality management. He is a frequent presenter at Oracle Open World, ODTUG Kaleidoscope, UKOUG Technology Conference and OUGN Vårseminar. He writes articles and publishes at the AMIS technology blog (http://technology.amis.nl/blog/).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “Jdbc, Clobs and Strings

  1. Aino,

    Since you are obviously an expert on the JDBC driver, I was wondering if you have ever seen a working example of a CLOB Editor based on a Java applet? It seems to me that this would be the ideal solution to the problem I’m running across with my mod_plsql version of a CLOB Editor… namely the 32K limit (or less with multibyte character sets) on VARCHAR2 data passed as a PL/SQL formal parameter.

    I found a very nice CLOB Editor at http://www.withdata.com/oralobeditor.html but, alas, it is only Windows based. I really need a pure browser based one. With a lot of elbow grease I’m sure I could develop one in Java, but I’m only a novice with Java (but expert with PL/SQL) and I think it would just take too long. Have you run across a piece of code that handles this?

    Thanks,
    Jack

Comments are closed.

Next Post

Small introduction to SQL*Net debugging [client side]

Say it's that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems. Blast!. What can you do? Once in a while i get a lot of these SQL*Net problems (network changes, etc, the wrong weather type). So to help you (and me), here i will you give you my grey-matter checklist :-) (it's not complete but should help you to resolve 80% of the problems at hand)
%d bloggers like this: