Question: ON DUPLICATE KEY UPDATE

Question

Question

Minsu Kim · May 25, 2018

Hello glabal masters,

I am trying to develop WAS using Cache and Spring Framework.

The ON DUPLICATE KEY UPDATE is not working.

Source :

INSERT INTO
           ocsGUMCHECDINFO (CODE,DODATE,NAME,DAY,PURPOSE,REQUIREMENT,BEFORENOTE,AFTERNOTE,CNT,REPORT,CONSENT,CONTACT)
   VALUES
       (#{code},#{doDate},#{name},#{day},#{purpose},#{requirement},#{beforeNote},#{afterNote},#{cnt},#{report},#{consent},#{contact})
       ON DUPLICATE KEY UPDATE DAY=#{name},PURPOSE=#{day},REQUIREMENT=#{requirement},BEFORENOTE=#{beforeNote},AFTERNOTE=#{afterNote},CNT=#{cnt},REPORT=#{report},CONSENT=#{consent},CONTACT=#{contact}

Is "ON DUPLICATE KEY UPDATE" not working in Cache SQL? Is there any other way if this isn't working?

Thank you

Discussion (3)0

Log in or sign up to continue

Eduard Lebedyuk · May 25, 2018

Use INSERT OR UPDATE:

INSERT OR UPDATE INTO  ocsGUMCHECDINFO
(CODE,DODATE,NAME,DAY,PURPOSE,REQUIREMENT,BEFORENOTE,AFTERNOTE,CNT,REPORT,CONSENT,CONTACT)
VALUES (#{code},#{doDate},#{name},#{day},#{purpose},#{requirement},#{beforeNote},#{afterNote},#{cnt},#{report},#{consent},#{contact})

0 0

score 0 · Answer 1 · 2018-05-25T03:32:12-04:00

Thank you so much, Thank you

Is it similar Oracle SQL grammar?

If Is it only Cache SQL, where did you learn about it?

Thank you so much!!

score 0 · Answer 2 · 2018-05-25T03:47:02-04:00

If Is it only Cache SQL, where did you learn about it?

From documentation. Here's a link to SQL reference.