Posted: 28 Dec 2016 21:43 EST Last activity: 29 Dec 2016 0:56 EST
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.
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.