cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Use thingworx to operate postgresql how to start a transaction

chenzhuang111
6-Contributor

Use thingworx to operate postgresql how to start a transaction

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

2 REPLIES 2

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.

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

Top Tags