I've got two blob columns in a table corresponding to two java.sql.Blob properties - basically and original image and its thumbnail. If I save only the original, it properly goes into the "FILE_BLOB" column. However if I save both, the original gets inserted into the THUMB_BLOB column and the thumbnail gets inserted into the FILE_BLOB column. I assumed, as is mostly the case, that I was goofing something up and had the pointers crossed somehow but I output the byte count of each property immediately before calling getHibernateTemplate().saveOrUpdate(obj) and they are in their correct properties at this time. I have:
o) Triple checked the mapping is proper and is evidenced by the fact that if I save them individually, they do go into the correct column - this seems to occur when saved together.
o) Intentionally saved the bytes in the wrong column (e.g. thumb->original and original->thumb) and when it gets to the database they are in the "right" column.
o) Tested my thumbnail creation code independently to ensure I'm not inadvertantly modifying the original.
o) and now... I'm here asking for help.
All hints are appreciated. I've made an honest effort to RTFM but I'd humbly accept any links if I've missed something.
Thanks,
--tim
Hibernate version:
3.2.2
Mapping documents:
Can't post, but the columns of concern are:
<property name="fileBlob" column="FILE_BLOB" type="blob"/>
<property name="thumbBlob" column="THUMB_BLOB" type="blob"/>
corresponding to getter/setters of type java.sql.Blob
Full stack trace of any exception that occurs:
no exception
Name and version of the database you are using:
Oracle 10g rel2
Login
FAQ
Search