Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 344329

Summary: Add support for UPSERT/MERGE
Product: z_Archived Reporter: Doug Clarke <douglas.clarke>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: P3 CC: mail, martin.grebac, scherzo_16
Version: unspecifiedKeywords: performance
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:

Description Doug Clarke CLA 2011-04-29 14:18:00 EDT 
Currently for detached entities merged into a persistence context EclipseLink will issue a query to determine if the entity exists and will decide to do an INSERT or UPDATE. This enhancement will add support for using SQL UPSERT/MERGE (depending on DB) instead so that the entity is written to the database without requiring the additional SELECT.
Comment 1 Ruslan López Carro CLA 2017-08-10 14:44:54 EDT 
Eclipse link already provides this functionality with @ExistenceChecking http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_existencechecking.htm
Comment 2 Eclipse Webmaster CLA 2022-06-09 10:35:35 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink