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?

search the forum, this has been discussed various times already