Automatic reconnection method and automatic reconnection device for contingency interrupt of database connection

Abstract

The invention discloses an automatic reconnection method and an automatic reconnection device for contingency interrupt of database connection. The device comprises a regular database connection pool and a standby database connection pool, a connection validity detector, a database connection request monitor, a connection request priority analyzer and an exception catcher; the connection validity detector is used for pre-connection so as to judge the validity of the connection to be allocated currently, and when the regular database connection pool has invalid connection, the standby database connection pool initializes the database connection as needed. According to the method, the time interval between two database connection requests is recorded through the database connection request monitor, the connection request priority analyzer judges the database connection request according to a pre-set priority strategy, and the standby database connection pool is started when the database connection request with higher priority exists. The method and the device ensure that the database connection requests which need to be processed quickly can be executed efficiently, so that the times of pre-connection is controlled effectively, and the system overhead is saved.

Description

technical field [0001] The invention belongs to the technical field of computer data processing and relates to database connection technology, in particular to an automatic reconnection method and device for unexpected interruption of database connection. Background technique [0002] Database connections are a critical and limited resource. The management of database connections can significantly affect the scalability and robustness of the entire application, and affect the performance indicators of the program. The database connection pool is proposed for this problem. [0003] The database connection pool is responsible for allocating, managing and releasing database connections. Its most basic idea is to pre-establish some connections and place them in memory objects for backup. When an application needs to establish a database connection, it can reuse an existing database connection instead of re-establishing one; release it after use, and release the database connec...

AI Technical Summary

Problems solved by technology

[0007] The purpose of the present invention is to solve the problem that the database connection is invalid in the prior art, and there is a problem that the system overhead is large and the retry connection cannot guarantee the success of the connection, and proposes an automatic reconnection method and its device for the unexpected interruption of the database connection

Images