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

CloverDX Platform
1

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

2

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

3

Thanks for the answer.