Ok so writing BLOB fields in Oracle (with hibernate) could give you a bla bla length > 4000 bytes error. [todo: lookup exact error] First of all I’ll explain why. The BLOB fields in oracle work with a pointer and that pointer is 4000 bytes. The actual data is stored elsewhere. So your problem is that you’re trying to write to this pointer instead. [todo: lookup source]
oracle jdbc driver version
com.oracle.jdbc
jdbc-thin
1.2
test
The following information is for completeness only.
hibernate version
org.hibernate
hibernate
3.2.0.ga
hibernate mapping
<property name=“xml” lazy=“true” not-null=“true” column=“xml” />
java property
/**
* xml data of this audit
*/
private byte[] xml;
public byte[] getXml() {
return xml;
}
public void setXml(byte[] xml) {
this.xml = xml;
}
column definition
XML BLOB not null