Question
Datacom group
NZ
Last activity: 6 Nov 2018 20:02 EST
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.
Accepted Solution
Pegasystems Inc.
US
The connection is closed after each Execute use Close(). Exceptions bubble up to the automation surface, so it is always best to wrap this with a Try...Catch.
Pegasystems Inc.
US
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,
Datacom group
NZ
I can provide the way I have configured the sqlQuery connector.
Provider:Microsoft OLE DB provider for SQL server
Connection String:Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XXXXXXXX;Data Source=XXXXXXXXX
and the query runs fine(Test connection returned valid)
Accepted Solution
Pegasystems Inc.
US
The connection is closed after each Execute use Close(). Exceptions bubble up to the automation surface, so it is always best to wrap this with a Try...Catch.