ValidationException.nullPrimaryKeyInUnitOfWorkClone Exception When Using Zero as a Primary Key (Doc ID 1536334.1)

Last updated on FEBRUARY 10, 2022

Applies to:

Symptoms

An entity UserEntity is defined mapping to this database table :

CREATE TABLE usur_AUX (
ID NUMBER NOT NULL PRIMARY KEY,
NOMBRE VARCHAR(32),
APEL1 VARCHAR(32),
APEL2 VARCHAR(32)
);

One row has been inserted with a primary key id equal to 0 :

INSERT INTO usur_AUX VALUES (0,'PRUEB','PRUEB','PRUEB');



After fetching the UserEntity with ID equal to 0 , this entity is updated with the following code
 (where  UserEntity usur is containing the new attribute values of the entity ) :

Changes

Cause

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