Use thingworx to operate postgresql how to start a transaction

[chenzhuang111]

As the title, how can i use commit () and rollback () in sql service

[PaiChung · Accepted solution]

Best way is to create stored procedures on the DB side and invoke them from Thingworx (using the JDBC connection)

You can write full Procedures on the Thingworx side and execute them through the JDBC connection.

[slangley]

Hi @chenzhuang111.

If you are satisfied with the response previously provided, please mark it as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon