Use thingworx to operate postgresql how to start a transaction

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

Best answer by PaiChung

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.

Answer

22-Sapphire I

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.

Support

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

Sign up