How to upsert(update if exists, else insert) into a table using jdbcTemplate

Asked May 28 '15 at 07:52

Active May 28 '15 at 09:47

Viewed 4,441 times

I have to update a row in the table if Id is already presents, else insert a new row in the database using Spring Jdbc Template. I tried using MERGE query but since i am operating on a single table, I could not able to pass my insertion parameter values from outside(Merge insert params should come from DB) as shown below.

MERGE INTO TABLENAME INDS
USING (SELECT PRIMARY_ID SIC FROM TABLENAME  WHERE PRIMARY_ID = '223456789') E
ON (INDS.PRIMARY_ID=E.PRIMARY_ID) 
WHEN MATCHED THEN
UPDATE SET INDS.ROW_MOD_ID='ManualUpdate', ROW_MOD_TMST=sysdate
WHEN NOT MATCHED THEN
INSERT  (INDS.PRIMARY_ID, INDS.ROW_CRE_ID, ROW_CRE_TMST)
VALUES ('223456789', 'ManualInsert', sysdate);

I am using Oracle DB and worried about the performance. Is there any spring feature to address my problem? Any help is much appreciated.

edited May 28 '15 at 09:47

asked May 28 '15 at 07:52

Bhargav Kumar R

2,190
3
22
38

What is the problem with the MERGE statement? All you to do is use bind variables instead of hard-coding the values. – Lalit Kumar B May 28 '15 at 08:09
Why don't you go with Oracle Stored Procedure? – Rajesh May 28 '15 at 08:12
I will give a try with stored procedure.. – Bhargav Kumar R May 28 '15 at 09:31

How to upsert(update if exists, else insert) into a table using jdbcTemplate

0 Answers0