Error java.sql.BatchUpdateException: ORA-00001: Unique Constraint Violated (Doc ID 764008.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 10.2.0.4.0 to 11.1.0.6.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:

When using JDBC standard batching and inserting rows into a table with a "where not exists" condition where: 

Oracle returns a PK violation in the case of the second row.

 

JAVA.SQL.BATCHUPDATEEXCEPTION: ORA-1: UNIQUE CONSTRAINT (SCOTT.SYS_C009652)

This only happens when running the JDBC program against an Oracle 11.1.0.6.0 or 11.1.0.7.0 database.


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