I have an issue with which I need your help.
Our robots connects to the database without a problem. Runs efficiently connects and executes query and sometimes due to things we can not control we loose internet connection for a longer period. The process send us information connection disabled and invoked code where we have execute query doesn’t work of course the whole process gets stopped.
The question I have is do I do a try catch on the execute query or do I do a try catch on the connection in INITALLAPPLICATIONS in reframework.
I have already extended the timeout in the execute query to 60 seconds.
My second question is as the connection is an argument I pass to the query does this mean that when execute query is connecting it is going back to the connection in initallapplications.
Thanks for your help