My Oracle Support Banner

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

Last updated on AUGUST 19, 2020

Applies to:

JDBC - Version 10.2.0.4 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.
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 (XXXXX.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.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.