I have referred to http://www.hibernate.org/56.html to know more about handling CLOBs with Hibernate. When I used the code posted, it gives compilation error that implementation doesn't implement other methods UserType interface.

My database is Oracle 9i.

Is there any straightforward working code to write/update and read the CLOB property.

Is it mandatory to set following properties to work with CLOB types:


<property name="hibernate.jdbc.batch_size">0</property>
<property name="hibernate.jdbc.use_streams_for_binary"> true</property>


Hibernate version: 3.2.6

In the forum http://forum.hibernate.org/viewtopic.ph ... t=multiple, I read "we are using CLOBs successfully with the Oracle 10 driver supplied by Oracle. It works fine on Oracle 9i databases, too. No special UserType required. We just set the property types to "text". Although we do have to disable batching."

Can we use 10g driver with 9i database?

Thanks