Access a process variable in SQL update

Submitted by sfrogner on Sun, 02/07/2021 - 03:00
1
0
-1

Hi there.... I am trying to update a record in my mySQL database and reference a process property. This is with a service task.

Is there a way to do this

UPDATE `pos_local`.`merchant_store`

SET EQUIPMENT_SHIPPED = 0

WHERE ID = ${merchantid}

This will swap the ${merchanceid} with $var0 and it always fails. Any example out there of this would be much appreciated. Also, if anyone could point me me to a trouble shooting approach. Any video blog etc much appreciated.

thx,

sean

1 answer

Submitted by Pierre-yves Monnet on Thu, 02/18/2021 - 19:24
1
0
-1

Hello

You could use a Database connector. Add a service task, go to Execution / then Connector In, and add a JDBC connector.

In the connector, you can setup the database (or best, use a datasource connector) and then the SQL update.

Hope this help,

Best

Notifications