Bug 344329 - Add support for UPSERT/MERGE
Summary: Add support for UPSERT/MERGE
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2011-04-29 14:18 EDT by Doug Clarke CLA
Modified: 2022-06-09 10:35 EDT (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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