Hibernate version:2.14

Mapping documents: <property
column="SIGNATURE"
name="signature"
type="binary"
/>

We are using BLOB for signature image store in Oracle 9i database. The type for database column is BLOB. We are using binary for mapping and byte[] for Java datatype. The thing is that we found if the image size is bigger than 4k, then the SQLException will be thrown. Otherwise everything is OK.

The exception looks like this:

queue: 'weblogic.kernel.Default'] - SQL Error: 17410, SQLState: null 2004-12-01 11:24:17,566 ERROR net.sf.hibernate.util.JDBCExceptionReporter [
queue: 'weblogic.kernel.Default'] - No more data to read from socket 2004-12-01 11:24:17,576 ERROR net.sf.hibernate.util.JDBCExceptionReporter [
queue: 'weblogic.kernel.Default'] - could not insert: [com.bcbsma.regcommons.model.Associate#266]
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:375)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2149
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2032)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2894)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:608)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
:94)
at
net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:
22)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
at ......

ANy thoughts?

This is a known limitation of the Oracle JDBC driver. Complain to them.

While your doing that. Read the wiki - lots of information on dealing with Blobs etc in various ways.

using Oracle JDBC thin driver 10g fixes the problem