Using binary property type mapped to BLOB sql-type failed

thayum · **Joined:** Tue Aug 26, 2003 2:47 pm **Posts:** 21

Hi,
I have a requirement where I have to use a BLOB sql-type in the table mapped to an object property of type byte[]. So I used the hibernate binary type in the mapping file as follows.
<Property name="image" type"binary">
<column name="image" sql-type="BLOB">
</Property>

It works as long as the size of the image is less than 4000 bytes. If the size exceeds I am getting the following error. Could some help me or point me to any information that will help to resolve this issue.

net.sf.hibernate.JDBCException while performing database operation 'find(select f from f in class org.jbpm.workflow.definition.impl.FieldImpl where f.state.id = ? and f.attribute.name = ?,[2811|start date],types)' : Could not synchronize database state with session: Data size bigger than max size for this type: 9241

thanks,
TM

thayum · **Joined:** Tue Aug 26, 2003 2:47 pm **Posts:** 21

thayum wrote:

Hi,
I have a requirement where I have to use a BLOB sql-type in the table mapped to an object property of type byte[]. So I used the hibernate binary type in the mapping file as follows.
<Property name="image" type"binary">
<column name="image" sql-type="BLOB">
</Property>

It works as long as the size of the image is less than 4000 bytes. If the size exceeds I am getting the following error. Could some help me or point me to any information that will help to resolve this issue.

net.sf.hibernate.JDBCException while performing database operation 'find(select f from f in class org.jbpm.workflow.definition.impl.FieldImpl where f.state.id = ? and f.attribute.name = ?,[2811|start date],types)' : Could not synchronize database state with session: Data size bigger than max size for this type: 9241

I am using Oracle 817 and the latest jdbc thin driver from Oracle.

thanks,
TM

yangstarfly · **Joined:** Sun Sep 14, 2003 8:42 pm **Posts:** 3

There is an article in design patten.
http://hibernate.bluemars.net/56.html

thayum · **Joined:** Tue Aug 26, 2003 2:47 pm **Posts:** 21

Thanks. I would try this out.

Rgds,
TM