Implement 'INSERT or UPDATE' / 'upsert' functionality [DATAJDBC-269]

[spring-projects-issues]

trafficstars

Rafal Glowinski opened DATAJDBC-269 and commented

Many relational databases provide means to perform an upsert (insert or update) operation with just one DB request. There is no such feature in JPA standard and maybe Spring Data JDBC could be better in that area - just like JOOQ is.

• MySQL has 'INSERT ... ON DUPLICATE KEY UPDATE'
• PostgreSQL has 'INSERT... ON CONFLICT ..'
• MSSQL has 'MERGE'
• Oracle has 'MERGE'

Also, the one and only Vlad Mihalcea has posted a nice summary of upsert operations performed by JOOQ. 

---

Issue Links:

• DATAJDBC-210 Improve strategy for persisting referenced entities

9 votes, 9 watchers

[spring-projects-issues]

Jens Schauder commented

The fix for DATAJDBC-210 might implement something similar for referenced entities or use code from this issue