Hi! I really need help... I

I have the same problem!!

Hi.

I wrote this in my hibernate.properties and works;

hibernate.jdbc.use_streams_for_binary=true
hibernate.jdbc.batch_size=0

Good luck!

this does not work for me: the whole data in the CLOB column gets deleted if I try to insert a text of more than 4000 char. I get no error message from hibernate. I am using Oracle 8i, this is the mapping:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="bacrule1.Organism" table="organism">
<id column="oscode" name="oscode" type="string" unsaved-value="null">
<generator class="assigned"/>
</id>
<property column="description" name="description" type="text"/>
<property column="internal" name="internal" type="string"/>
</class>
</hibernate-mapping>

anybody found a workaround?

what about this batch-size attribute ?

You must make sure you insert an empty clob. see Hibernate.createClob(" ")

orgDetail.setOdBusinessSummary(Hibernate.createClob(" "));
session.save(orgDetail);
session.flush();
session.refresh(orgDetail, LockMode.UPGRADE);
oracle.sql.CLOB bussinessSummaryClob = (oracle.sql.CLOB) orgDetail.getOdBusinessSummary();

Writer clobWriter = bussinessSummaryClob.getCharacterOutputStream();
clobWriter.write(bussinessSummaryData);
clobWriter.close();
//END Inserting a CLOB


tx.commit();
session.close();