Hibernate Version: 3.6.1
Weblogic : 9.2
Database : Oracle 10.2.0.4.0

Hibernate Mapping
<property name="data" type="java.sql.Blob" column="DATA" />

We need to store an object in the database and for this we are using blob. The database insert for the table containing blob started failing once we upgraded the hibernate jar from 3.2.0.ga to 3.6.1. All other inserts are working fine only the table with the blob is having problems. Also there has been no change in environment or code except for upgrading to this new jar.

Have pasted below the exception we are getting with the new jar..

java.sql.SQLException: setBlob, Exception = $Proxy68
at weblogic.jdbc.wrapper.JDBCWrapperImpl.invocationExceptionHandler(JDBCWrapperImpl.java:141)
at weblogic.jdbc.wrapper.PreparedStatement.setBlob(PreparedStatement.java:365)
at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doBind(BlobTypeDescriptor.java:65)
at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:89)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:85)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2166)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2412)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2856)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at com.obopay.core.persistence.hibernate.HibernateHandler.insert(HibernateHandler.java:144)
at com.obopay.core.persistence.helper.PersistenceHelper.insertDAO(PersistenceHelper.java:34)
at com.obopay.core.fiadmin.data.access.manager.makerchecker.MCServiceDAOManager.createEventDetail(MCServiceDAOManager.java:84)


Please let me know if there is a work around or solution for this. We need the BLOB and removing it is not an option. This is a blocker for us as we cannot upgrade to the new jar until this is resolved.

Realized that this has been fixed in 3.6.2. Upgrading to this version resolved this.