Method and device for managing database connection

Abstract

An embodiment of the invention discloses a method and a device for managing database connection. The method includes: receiving a connecting request related to a service from an application program, wherein the connecting request comprises process identification corresponding to the service; searching for a first mapping table according to the process identification so as to acquire the corresponding service identification of a database and the address identification of the database; searching for a second mapping table according to the address identification of the database so as to acquire the address of the database; searching for a third mapping table according to the corresponding service identification of the database so as to acquire the account and password of the database; transmitting the address, the account and the password of the database to the application program.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for managing database connections. Background technique [0002] At present, the connection resource uses the connection pool provided by the middleware to manage the connection of the application program to the database. This method has been widely used in some large or complex application systems. The application program can often connect to the database by using the connection pool parameter configuration of the connection pool. Specifically, it can be the maximum value, minimum value, idle value and initial value of the application program and the database during the connection process. Detection of connection and reconnection after disconnection, real-time monitoring of the connection by the application program and database during the connection process and recovery of the released connection. [0003] In the process of connecting to the database, the ...

AI Technical Summary

Problems solved by technology

[0003] In the process of connecting to the database, the connection pool usually requires the database to provide the IP address of the database server, the listening port, the database instance name, and the database account and password; usually, a connection pool corresponds to a connection of the application to the database. As the application system becomes larger and larger, and there are more and more applications in the system, the amount of data that the application needs to process during its operation increases day by day, and the required database instances and database connections also increase accordingly. There are more and more connection pools, which will lead to heavy maintenance of connection pools, prone to configuration errors, and seriously affect the normal operation of applications

Images