Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Using binary property type mapped to BLOB sql-type failed
PostPosted: Wed Sep 17, 2003 8:20 pm 
Beginner
Beginner

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

_________________
TM


Top
 Profile  
 
 Post subject: Re: Using binary property type mapped to BLOB sql-type faile
PostPosted: Thu Sep 18, 2003 12:14 pm 
Beginner
Beginner

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

_________________
TM


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 18, 2003 9:53 pm 
Newbie

Joined: Sun Sep 14, 2003 8:42 pm
Posts: 3
There is an article in design patten.
http://hibernate.bluemars.net/56.html

_________________
i like Hibernate


Top
 Profile  
 
 Post subject: using blob in Oracle
PostPosted: Fri Sep 19, 2003 5:21 pm 
Beginner
Beginner

Joined: Tue Aug 26, 2003 2:47 pm
Posts: 21
Thanks. I would try this out.

Rgds,
TM

_________________
TM


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.