Question
3
Replies
241
Views
Datacom group
Posted: March 13, 2018
Last activity: November 6, 2018
Closed
Solved
Closing DB connections in Pega robotics
Hi All,
I have used OlDbQuery, ODBCQuery SqlQuery and OracleQuery and assumed that the DB connection is getting closed automatically after using the Execute method of these components.I want to know how the DB connections are getting closed internally and what sort of DB related exceptions that we have to handle using the try catch. DBconcurrencyExceptions , OdbcExceptions etc.
Hi Asirichathu,
Can you provide the details on how you set up your oracleQuery connector? What provider did you select and the connection string that you used? Did the 'Test connection' button return a valid result?
Thanks,