Exception during parent commit in hibernate 5.4.2 if the child object has blob . This works fine in Hibernate 3 .
Description
Activity
Show:
Ramesh Krishnan V.E July 8, 2019 at 9:29 AM
The Task Element Specification is invalid JDBC exception on Hibernate data access: SQLException for SQL [update PropertyNameAndValue set InstanceUuid=?, PropertyName=?, BlobVal ue=? where ID=?]; SQL state [99999]; error code [17266]; could not execute batch ; nested exception is org.hibernate.exception.GenericJDBCException: could not ex ecute batch.-JOBM_002
The Task Element Specification is invalid JDBC exception on Hibernate data access: SQLException for SQL [update PropertyNameAndValue set InstanceUuid=?, PropertyName=?, BlobValue=? where ID=?]; SQL state [99999]; error code [17266]; could not execute batch ; nested exception is org.hibernate.exception.GenericJDBCException: could not ex ecute batch.-JOBM_002
This happens only when Blob size is big.
As as workaround, session.refresh called using another HibernateSession but it creates Db lock in Performance Environment. Without refresh it should work seamlessly like Hibernte 3