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”).