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

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

Announcements