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

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

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

Thanks for the answer.