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”).
Happy
0 %
Sad
0 %
Excited
0 %
Sleepy
0 %
Angry
0 %
Surprise
0 %
Related posts:
Use Data Tree in List of Values Window – ADF BC and UIX and JHeadstart 
Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting Apache MyFaces (open source JSF implementation) – Using the Tree2 Component with JDeveloper 10.1.3 
JavaOne 2008: OpenSSO – creating federated relationships for secure SaaS, Social Networking and Web 2.0 Java: Generating PDF and Previewing it as an Image – iText and PDF Renderer
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