Delete Query Fail With OptimisticLockException If Batch-Writing JDBC Is On (Doc ID 1478265.1)

Last updated on JANUARY 05, 2015

Applies to:

Oracle TopLink - Version 11.1.1.4.0 to 12.1.1.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.
Checked for currency 05-Jan-2015

Symptoms

This issue occurs in both Toplink and Toplink Grid environments for the following releases:

TopLink 11.1.1.4.0/Eclipselink 2.1.2

TopLink 12.1.1.0/Eclipselink 2.3.2

When using TopLink 11.1.1.4.0/Eclipselink 2.1.2 with JPA 2.0, an attempt was made to delete all the records in one table A through
a named JPQL delete query like "DELETE FROM A". It was found that delete operation fails and reports an exception
'org.eclipse.persistence.exceptions.OptimisticLockException'. 

 

is removed from persistence.xml

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms