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 220.127.116.11 [Release 10.2 to 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.
-- Problem Statement:
When using JDBC standard batching and inserting rows into a table with a "where not exists" condition where:
- first row does not exist resulting in an insert
- second row does exists and should not be inserted because of the "where not exists" condition but
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 18.104.22.168.0 or 22.214.171.124.0 database.
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