Given a list of objects, insert, update and delete them using Jdbc or JdbcTemplate in one SQL statement

I figured that the best way to do a merge operation is to use a common table expression.

Given a list of objects, insert, update and delete items using Jdbc or JdbcTemplate in one SQL statement

I figured that the best way to do a merge operation is to use a common table expression.