Exception during parent commit in hibernate 5.4.2 if the child object has blob . This works fine in Hibernate 3 .

Description

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

 

 

Environment

None

Status

Assignee

Unassigned

Reporter

Ramesh Krishnan V.E

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

5.4.2

Priority

Major
Configure