Using "ON DUPLICATE" or "REPLACE" with JDBC?

deshartman

• July 13, 2009 00:00

• Answered

Follow

Hi,

Is it possible to use ON DUPLICATE With the DBOutput component? It keeps giving me enum errors, so I presume it is not coded?

Thanks
Des

• 

  twaller

  • July 13, 2009 16:03

  0

  Comment actions Permalink

  Hello Des,
  
  It is possible to use a SQL query in DBOutputTable with ON DUPLICATE clause.
  
  E.g.
  INSERT INTO `aTable` (`field1`, `field2`) VALUES ($field1, $field2) on duplicate key update field3 = 'aValue'
  
  However, there is no direct support for this clause, you can only use it with a SQL query.
  
  Best regards,
  
  Tomas Waller
• 

  deshartman

  • July 14, 2009 05:14

  0

  Comment actions Permalink

  Thanks for the answer.

Please sign in to leave a comment.