Connection Exit Due to Improper Timeout Parameter Settings
Scenario
There are frequent database connection exits. As a result, subsequent statements fail to be executed.
Possible Causes
When a connector or API is used to connect to a database, the client has some default parameter settings. The settings of some important parameters, such as socketTimeout and connectTimeout, determine the client connection timeout duration. If the wait time of a connection exceeds the value of one of these parameters, the connection will be interrupted.
Solution
- Change the default values of parameters such as socketTimeout and connectTimeout to appropriate values.
- Pay attention to the reconnection function in the program.
- Using connection pools is recommended.
Parent topic: Connection Issues
- Scenario
- Possible Causes
- Solution