Question
1
Replies
1433
Views
Posted: December 28, 2016
Last activity: December 29, 2016
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
Moderation Team has archived post,
Close popover
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.
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.