Hi Team,
Greetings!
Our application utilizes a direct connection. When users fail to connect to a database, they are forced to kill their session (when a connection failure occurs) and relaunch the application in order to reestablish a connection.
We experienced a DB disconnect issue in our application as a result of a network problem. Due to this, the application gets closed, so the user must restart it and log in again. Is there a way to connect to the database again in the event of a failure so that the re-login process is avoided?
The functionality for DB connections cannot be implemented throughout the entire application. Since there are almost 10K locations where SQLCA.SQCODE checks. Thus, we are unable to implement every area.
Is there a standard place to implement DB reconnection in case of failure?
FYR. We are experiencing the following error due to a network issue.
Any option application will try to connect to the database until a successful connection after 2 to 3 seconds when the network is stable.
Note: Network issue most likely due to VPN.
Thanks in advance.
Venu