Access a process variable in SQL update

Q&A
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

2

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