Question

1
Replies
1446
Views
 Suleman Qureshi (SulemanQ)
Rulesware LLC.
Principal Consultant
Rulesware LLC.
US
SulemanQ Member since 2010 3 posts
Rulesware LLC.
Posted: December 28, 2016
Last activity: December 29, 2016
Posted: 28 Dec 2016 21:43 EST
Last activity: 29 Dec 2016 0:56 EST
Closed

Timeout for Connect-SQL Rules

Does any of you know how to configure the timeout for Connect-SQL calls. We are using ConnectionProblems as exception handler flow but in case of no response from the external database, it takes somewhere ~15 minutes to break the communication link. (see attached).

Any clue on how can we control the timeout setting for SQL connectors to make it time out within 60 seconds minutes instead. 

-Suleman

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 29 Dec 2016 0:56 EST
Habeeb Baig (HabeebBaig)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

It depends on how you have configured your 'Database' rule. If you are using JDBC url to connect to database the connection timeout will be done by the DB server, hence it will be loop hole in the transaction and there may arise security issues. You can probably connect to external database by using JDBC connection pool or use with preferences option on Database rule, which will make sure that whenever the connect-sql is called in RDB-execute method in activity the connection to DB is establised through connection pool.