EclipseLink: SQLIntegrityConstraintViolationException: ORA-00001 (Doc ID 2187141.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle TopLink - Version 11.1.1.6.0 to 12.1.2.0.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.

Symptoms

There is a problem with a transaction using EclipseLink 2.3.1.
The application begins a transaction that could be rolled back.
After that, a new transaction is started and the application tries to persist an object ‘SituacionDeExpediente’, but an error is produced.
The error shows that It is trying to create an object that already exists in the database, and it is not of the type that the application wants to create:

Exception stack


As seen above, Eclipselink is trying to create an “Etapa” object (it is related with “SituacionDeExpediente”), and because this object is already into the DB the exception is thrown.


Environment
EclipseLink 2.3.1 + TopLink 11.1.1.6.0
[ shipped with WLS 10.3.6 ]

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