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">
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.