Non Null BLOB is not Inserted Through Triggers When Using Java Persistence API (Doc ID 1927700.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

A table (Employee ) is created in Oracle Database that  contains a BLOB  type column (lobData).

A trigger is defined on this table (Employee ) so
 that for any insert / update on a row , a copy of the inserted / updated row
 is done to another similar table (Employee_copy) with
 a blob column (lobData).
 
  An entity is mapping the table Employee :

 
The problem occurs when persisting Employee entity with a non null BLOB  :
the corresponding row is well inserted into Employee table
with a non null blob column (lobData).

But the row inserted into the Employee_copy table thanks to the trigger
has the corresponding  blob column (lobData) empty.

The expected behavior is that Employee_copy contains a row with a non null blob
value as in Employee.

The used  Eclipselink version  is 1.0.2 .

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.