WO2020177495A1

WO2020177495A1 - Database connection management method and apparatus, and device

Info

Publication number: WO2020177495A1
Application number: PCT/CN2020/073053
Authority: WO
Inventors: 高永露; 周继恩; 陈斌; 雷平
Original assignee: 中国银联股份有限公司
Priority date: 2019-03-05
Filing date: 2020-01-19
Publication date: 2020-09-10
Also published as: CN109977096A

Abstract

The problem in the prior art of production service interruption resulting from that a database connection pool leakage phenomenon cannot be sensed automatically and thus database connection pool leakage occurs is solved. Disclosed in the present invention are a database connection management method and apparatus, and a device. The method comprises: when a database connection is occupied by an application, determining a duration when the database connection is occupied by the application; and if it is determined that the duration is greater than or equal to a first preset duration and no transmission content is detected in the database connection, releasing the occupation of the database connection by the application.

Description

Database connection management method, device and equipment

Cross references to related applications

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office, the application number is 201910163071.6, and the application name is "a method and device for database connection management" on March 5, 2019. The entire content is incorporated into this application by reference. in.

Technical field

The invention relates to the field of databases, in particular to a method, device and equipment for database connection management.

Background technique

When an application is executed, it often needs to be connected to the database to obtain the required data and complete the corresponding business. One method in the prior art is to first put the database connection in the database connection pool, and when the application needs to use the database connection, it is directly obtained from the database connection pool.

However, due to abnormal application execution and other reasons, after the application uses the database connection, the database connection is not returned to the database connection pool. This phenomenon is called database connection pool leakage. When the database connection pool leaks frequently, it will cause database connections. The database connection in the pool is exhausted, causing subsequent applications to connect to the database request cannot be serviced. In the prior art, the leakage of the database connection pool cannot be automatically sensed, and human investment is required to check the application status and background logs. When the database connection pool is leaked, the method of restarting the server is adopted, resulting in interruption of production services.

Therefore, in the prior art, the phenomenon of database connection pool leakage cannot be automatically sensed, and production services are interrupted after the database connection pool leakage occurs, which is an urgent problem to be solved.

Summary of the invention

The embodiments of the present application provide a database connection management method, device, and equipment, which solve the problem in the prior art that the leakage of the database connection pool cannot be automatically sensed, and the production service is interrupted after the leakage of the database connection pool occurs.

In the first aspect, an embodiment of the present invention provides a database connection management method, which includes:

When a database connection is occupied by an application, determine the duration of time that the database connection is occupied by the application;

If it is determined that the duration is greater than or equal to the first preset duration, and the database connection is not detected to have transmission content, then the application's occupation of the database connection is released.

Optionally, the determining the duration of time that the database connection is occupied by the application includes:

When the database connection is occupied by the application, the start time of the occupation is recorded;

The current time is acquired according to the first preset period, and the duration of the current time minus the start time is used as the duration; the first preset period is less than the first preset duration.

Optionally, the transmission content is not verified to be connected to the database, and further includes:

If it is verified that there is transmission content connected to the database, the current time is used to replace the start time.

Optionally, check whether the database connection has transmission content in the following manner:

Intercepting the database connection in an aspect, and storing the intercepted content of the aspect in a first variable; the default value of the first variable is empty;

If the value of the first variable is empty within the second preset time period, it is determined that the database connection has no transmission content; otherwise, it is determined that the database connection has transmission content.

Optionally, within a time period when it is determined that the duration is less than the first preset time period, or it is verified that the database connection has transmission content, the database connection is kept unchanged.

Optionally, if the duration is greater than or equal to the first preset duration, check whether the database connection has transmission content.

In the embodiment of the present invention, when the database connection is occupied by the application, the duration of the occupied duration is recorded. When the duration is greater than or equal to the first preset duration and the transmission content of the database connection is not verified, the application to the database connection is released Occupy, return the data block connection to the database connection pool to avoid the application has no transmission content but still occupy the database connection, causing other applications to be unable to use the connection.

In a second aspect, an embodiment of the present invention provides a database connection management device, which includes:

The determining module is used to determine the duration of the database connection being occupied by the application when the database connection is occupied by the application;

The processing module is configured to release the application's occupation of the database connection if it is determined that the duration is greater than or equal to the first preset duration, and the database connection has no transmission content detected.

Optionally, the determining module is specifically used for:

Record the starting time when the database connection is occupied by the application;

Optionally, the processing module is further used for:

Optionally, the processing module is specifically used for:

Optionally, the processing module is further used for:

When it is determined that the duration is less than the first preset time period, or it is verified that the database connection has transmission content, the database connection is kept unchanged.

Optionally, the processing module is specifically used for:

If the duration is greater than or equal to the first preset duration, check whether the database connection has transmission content.

In a third aspect, an embodiment of the present invention provides a database connection management device, including:

At least one processor; and,

A memory communicatively connected with the at least one processor; wherein,

The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can execute the database connection management method described in the first aspect.

In a third aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium, the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to make the computer execute the Database connection management method.

In a third aspect, an embodiment of the present invention provides a computer program product, the computer program product includes a calculation program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, when the program instructions are When executed by a computer, the computer is caused to execute the database connection management method described in the first aspect.

Description of the drawings

FIG. 1 is a flowchart of corresponding steps of a database connection management method proposed by an embodiment of the present invention;

2 is a schematic diagram of module interaction corresponding to a database connection management method proposed by an embodiment of the present invention;

3 is a schematic diagram of obtaining a database connection by an application corresponding to a database connection management method proposed by an embodiment of the present invention;

4 is a schematic diagram of an application returning a database connection corresponding to a database connection management method proposed by an embodiment of the present invention;

5 is a schematic diagram of a corresponding structure of a database connection management device proposed by an embodiment of the present invention;

Fig. 6 is a schematic structural diagram corresponding to a database connection management device proposed by an embodiment of the present invention.

detailed description

In order to better understand the above technical solutions, the above technical solutions will be described in detail below with reference to the drawings and specific implementations of the specification. It should be understood that the embodiments of the application and the specific features in the embodiments are detailed to the technical solutions of the application. Note, rather than limiting the technical solution of the present application, the embodiments of the present application and the technical features in the embodiments can be combined with each other if there is no conflict.

However, due to abnormal application execution and other reasons, after the application uses the database connection, the database connection is not returned to the database connection pool. This phenomenon is called database connection pool leakage. When the database connection pool leaks frequently, it will cause database connections. The database connection in the pool is exhausted, causing subsequent applications to connect to the database request cannot be serviced. In the prior art, first, there is no method for automatically sensing database connection pool leakage. Human investment is required to check application status and background logs. When database connection pool leakage occurs, the method of restarting the server is adopted and the code is modified to release new ones. version. Second, when the application encounters a database connection leak, it can only be solved by restarting it continuously. The processing time is long and the impact is large, resulting in the interruption of the production service and the production interruption service. Generally speaking, there will be hundreds of application systems in an enterprise. In the case of automatic solution model without database connection leakage, once the problem occurs in several systems together, it will require a lot of manpower and a whole body of operation and maintenance personnel. In the application of heart observation, the probability of error in this mode will be magnified to a certain extent due to a large amount of manual intervention. A typical scenario of the above problem is a Java server, which is a kind of container, and the application needs to run on the Java server to complete the business. For example, Java servers include JAVA application servers, weblogic and open source tomcat and jboss servers. A large number of low-level functions are encapsulated in the Java server, and applications complete services by calling the low-level functions in the Java server.

The embodiment of the present invention proposes a method for solving database connection leakage. When a database connection leakage occurs, the database connection is automatically recovered. The method can be specifically realized by a solution model. Among them, the solution model is a code module that defines functions for handling various abnormal events in specific scenarios. For example, corresponding to any database connection pool that uses Java technology, the solution model is written in Java language. Specifically, the solution model can be summarized as follows: First, the middleware that automatically solves the database connection leakage needs to open the connection leakage, and then, when the application needs a database connection, it will be obtained from the database connection pool in the container, and the container will establish a connection with the database. , Put it into the database connection pool in the container, and record the acquisition time every time the connection returned to the application, and then if the application has not returned after a certain period of time, check whether the connection has a large amount of data interaction, if not, It indicates that the connection is displayed, and the connection is actively returned to the database connection pool in the container to solve the database leakage problem.

As shown in FIG. 1, it is a flowchart of steps corresponding to a method for database connection management proposed by an embodiment of the present invention.

Step 101: When a database connection is occupied by an application, determine the duration of time that the database connection is occupied by the application.

Step 102: If it is determined that the duration is greater than or equal to the first preset duration, and the database connection is not detected to have transmission content, release the application's occupation of the database connection.

Before step 101, the solution model needs to be opened. The method of opening the solution model is hot opening, which takes effect immediately and does not need to restart the machine. For example, by entering a command on the command line to open the solution model. As shown in FIG. 2, it is a schematic diagram of module interaction corresponding to a database connection management method proposed by an embodiment of the present invention. It should be noted that the container shown in Figure 2 only takes the JAVA application server as an example. The application runs on the container JAVA application server. The database first establishes a connection with the database connection pool running in the JAVA application server. When the application needs to connect to the database , Get the database connection directly from the database connection pool.

In step 101, as shown in FIG. 3, is a schematic diagram of obtaining a database connection by an application corresponding to a database connection management method proposed in an embodiment of the present invention. The application obtains the database connection from the database connection pool, that is, when the database connection is occupied, the solution model records the timestamp of obtaining the database connection, which is the timestamp of the database connection being occupied by the application, and the starting time of the occupation, starting from this The time starts to count and the duration is calculated.

There are many ways to determine the duration. An optional implementation is to record the start time of the database connection when the application is occupied, obtain the current time according to the first preset period, and subtract the current time The duration of the de-start time is used as the duration; the first preset period is less than the first preset duration. For example, at the initial moment when the database connection is occupied by the application, a timer is set to count the first preset period. The duration of the timer can be set according to the specific scenario. For example, the timer duration is 1. second. When the timer reaches the corresponding duration, the current time minus the start time is used as the duration.

In step 102, as shown in FIG. 4, it is a schematic diagram of an application returning a database connection corresponding to a database connection management method proposed in an embodiment of the present invention. Since in step 101, when the application obtains the database connection in the database connection pool, it has recorded the timestamp of obtaining the database connection and started timing. When the duration of the database connection occupied exceeds the first preset period of time, check whether the database connection is Has been returned to the database connection pool, that is to say whether the application has released the occupation of the database connection, if the database connection is not returned, the detection module will detect whether there is data transmission content on the database connection, and if there is no transmission content, the application is forcibly released Occupation of database connection.

It should be noted that calculating the duration and checking whether the database connection has transmission content can be performed simultaneously or asynchronously. An optional implementation manner is that the duration timed in step 101 is greater than or equal to the first preset duration, checking whether the database connection has transmission content, and within the second preset duration, checking whether the database connection has transmission content, The start time of the second preset duration is after the start time of the first preset duration.

In addition, for example, the time length for starting to check the database connection is determined according to the duration and the start time or end time of the first preset time length, and a trigger check time period for starting to check the transmission content of the database connection is set. It should be noted that the following time appears from the time when the database connection is occupied. For example, if the first preset duration is 10 seconds, the duration is greater than 8 seconds, and the trigger check duration is 8 seconds, then at the end of the 8th second of the duration, the database connection will be checked for transmission content.

Check whether the database connection has transmission content in the following way:

(1) Perform aspect interception on the database connection, and store the intercepted content of the aspect in a first variable; the default value of the first variable is empty. Among them, aspect interception is a method of obtaining data transmitted in variables and database connections. Through this method, variable values and transmission content in database connections can be tracked, so that operation and maintenance personnel can analyze data changes and then troubleshoot The reason is investigated and located, which can be implemented by the data interceptor in the compilation environment. For example, the transmission content is intercepted through a Java interceptor. (2) From the time when the database connection is checked, until the second preset duration, check the value of the first variable again. If the value of the first variable is still empty, it is determined that the database connection has no transmission content; otherwise, it is determined that the database connection has Transfer content.

When the duration is greater than the first preset duration, if it is verified that the database is connected to the transmission content, if it is verified that the database is connected to the transmission content, the current time is used to replace the start time to re-determine the duration duration. Since the database connection has transmission content, it means that the application is still running normally and transmitting data normally. Therefore, the occupied duration needs to be re-timed. When the duration is greater than or equal to the first preset duration, it is still necessary to check whether the database connection exists Transfer content.

In step 102, it should be noted that the database connection status includes occupied or unoccupied. The default status of the database connection in the database connection pool is not occupied. When a database connection is obtained from the database connection pool and occupied by the application, the database connection status will be changed from unoccupied to occupied, and the application occupying the database connection will also be recorded, the database occupied by an application The connection cannot be acquired and used by other applications. When the application returns the occupied database connection, the status of the database connection will be changed from the occupied state to the unoccupied state, so that it can be occupied by the application again. If the database connection was occupied before, the application will be stored in the database Connect to a corresponding historical record library.

One possible implementation of whether the database connection status is occupied and the status of the database connection is modified is to configure a database connection status variable in the configuration file to mark whether the database connection is occupied. For example, the value of the variable T is used to indicate the database connection status. The value of T includes 0 and 1. A value of T of 0 indicates that the database connection is not occupied, and a value of T of 1 indicates that the database connection is occupied. After the database connection C1 is obtained from the database connection pool and occupied by the application APP1, the value of T is changed from 0 to 1, and C1 is recorded at this time. When T is 1, if another application APP2 tries to obtain C1, it will first read the value of T. When the value of T is 1, it will return to fail to obtain C1. On the other hand, when APP1 returns C1, the value of T is changed from 1 to 0, and APP1 is stored in the operation log library corresponding to C1, so if the application APP3 tries to occupy C1 again, because T is 0 at this time , When APP3 sends a database connection request, it successfully returns to database connection C1.

In addition, an optional implementation manner is to keep the database connection unchanged within a time period when it is determined that the duration is less than the first preset duration, or if it is verified that the database is connected with transmission content.

The advantages of this model are: First, it is transparent to the application and the logic processing is completed in the middleware database connection pool. Second, it can be hot-opened and hot-closed without restarting the server. Third, for applications with database connection pool leakage, applications can continue normal services without interrupting services. Fourth, this model has a low probability of manslaughter. The core of this model is to add the time attribute to each connection retrieval, and then detect whether it has timed out, and then detect the data traffic again.

The embodiments of the present invention have strong versatility and scalability. In the database connection pool scenario, after the application gets the connection, it can be used transparently according to the set return time and connection detection technology. When the database connection leaks, the application can also be transparent and unconscious, and automatically return the database connection Pool. The method proposed in the embodiment of the present invention is applicable to any database connection pool, for example, it is applicable to a database connection pool of java technology.

As shown in FIG. 5, it is a schematic diagram of a corresponding structure of a database connection management apparatus proposed by an embodiment of the present invention.

The embodiment of the present invention provides a database connection management device, which includes:

The determining module 501 is configured to determine the duration of the database connection occupied by the application when the database connection is occupied by the application;

The processing module 502 is configured to release the application's occupation of the database connection if it is determined that the duration is greater than or equal to the first preset duration, and the database connection has no transmission content detected.

Optionally, the determining module 501 is specifically configured to:

Optionally, the processing module 502 is further configured to:

Optionally, the processing module 502 is specifically configured to:

Optionally, the processing module 502 is further configured to:

Optionally, the processing module 502 is specifically configured to:

Based on the same technical concept, the embodiment of the present invention provides a database connection management device. At least one processor; and, a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable The at least one processor can execute the database connection management method in the foregoing embodiment.

Taking a processor as an example, FIG. 6 is a structure of a database connection management device provided by an embodiment of the present invention. The database connection management device 600 includes a transceiver 601, a processor 602, a memory 603, and a bus system 604;

Among them, the memory 603 is used to store programs. Specifically, the program may include program code, and the program code includes computer operation instructions. The memory 603 may be a random access memory (random access memory, RAM for short), or a non-volatile memory (non-volatile memory), such as at least one disk memory. Only one memory is shown in the figure. Of course, the memory can also be set to multiple as required. The memory 603 may also be a memory in the processor 602.

The memory 603 stores the following elements, executable modules or data structures, or their subsets, or their extended sets:

Operating instructions: including various operating instructions, used to implement various operations.

Operating system: including various system programs, used to implement various basic services and process hardware-based tasks.

The foregoing database connection management method in the embodiment of the present invention may be applied to the processor 602, or implemented by the processor 602. The processor 602 may be an integrated circuit chip with signal processing capabilities. In the implementation process, the steps of the database connection management method described above can be completed by hardware integrated logic circuits in the processor 602 or instructions in the form of software. The aforementioned processor 602 may be a general-purpose processor, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware Components. The methods, steps, and logical block diagrams disclosed in the embodiments of the present application can be implemented or executed. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor or the like. The steps of the method disclosed in the embodiments of the present invention may be directly embodied as being executed and completed by a hardware decoding processor, or executed by a combination of hardware and software modules in the decoding processor. The software module can be located in a mature storage medium in the field such as random access memory, flash memory, read-only memory, programmable read-only memory, or electrically erasable programmable memory, registers. The storage medium is located in the memory 603, and the processor 602 reads the information in the memory 603, and performs the following steps in combination with its hardware:

The processor 602 is configured to determine the duration of the database connection being occupied by the application when the database connection is occupied by the application; if it is determined that the duration of the database connection is greater than or equal to the first preset duration, and it is not checked If the database connection has transmission content, the application's occupation of the database connection is released.

Preferably, the processor 602 is specifically configured to:

Preferably, the processor 602 is further configured to:

Preferably, the processor 602 is specifically configured to:

Preferably, the processor 602 is further configured to:

Preferably, the processor 602 is specifically configured to:

The database connection management device of the embodiment of the present invention exists in various forms, including but not limited to:

(1) Ultra-mobile personal computer equipment: This type of equipment belongs to the category of personal computers, has calculation and processing functions, and generally also has mobile Internet features. Such terminals include: PDA, MID and UMPC devices, such as iPad.

(2) Other electronic devices with database connection management functions.

Those skilled in the art can understand that all or part of the steps in the method of the above-mentioned embodiments can be implemented by instructing relevant hardware through a program. The program is stored in a storage medium and includes several instructions to enable a device (which can be a single-chip microcomputer). , A chip, etc.) or a processor (processor) executes all or part of the steps of the method in each embodiment of the present application. The aforementioned storage media include: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program code .

In addition, the present invention also provides a non-transitory computer-readable storage medium, the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to make the computer execute the database described in any one of the above Connection management method.

In addition, the present invention also provides a computer program product, the computer program product includes a calculation program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, when the program instructions are executed by a computer , Enabling the computer to execute any one of the database connection management methods described above.

Those skilled in the art should understand that the embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

The present invention is described with reference to flowcharts and/or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and/or block in the flowchart and/or block diagram, and the combination of processes and/or blocks in the flowchart and/or block diagram can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing equipment to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing equipment are generated It is a device that realizes the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be stored in a computer-readable memory that can guide a computer or other programmable data processing equipment to work in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture including the instruction device. The device implements the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be loaded on a computer or other programmable data processing equipment, so that a series of operation steps are executed on the computer or other programmable equipment to produce computer-implemented processing, so as to execute on the computer or other programmable equipment. The instructions provide steps for implementing functions specified in a flow or multiple flows in the flowchart and/or a block or multiple blocks in the block diagram.

Although the preferred embodiments of the present invention have been described, those skilled in the art can make additional changes and modifications to these embodiments once they learn the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present invention.

Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. In this way, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention is also intended to include these modifications and variations.

Claims

A method for database connection management, characterized in that it comprises:

When a database connection is occupied by an application, determine the duration of time that the database connection is occupied by the application;

If it is determined that the duration is greater than or equal to the first preset duration, and the database connection is not detected to have transmission content, then the application's occupation of the database connection is released.
The method of claim 1, wherein the determining the duration of the database connection being occupied by the application comprises:

When the database connection is occupied by the application, the start time of the occupation is recorded;

The current time is acquired according to the first preset period, and the duration of the current time minus the start time is used as the duration; the first preset period is less than the first preset duration.
3. The method according to claim 2, wherein said unchecking that said database is connected with transmission content, further comprising:

If it is verified that there is transmission content connected to the database, the current time is used to replace the start time.
The method according to any one of claims 1-3, characterized in that, whether the database connection has transmission content is checked in the following manner:

Intercepting the database connection in an aspect, and storing the intercepted content of the aspect in a first variable; the default value of the first variable is empty;

If the value of the first variable is empty within the second preset time period, it is determined that the database connection has no transmission content; otherwise, it is determined that the database connection has transmission content.
The method according to any one of claims 1-3, further comprising:

When it is determined that the duration is less than the first preset time period, or it is verified that the database connection has transmission content, the database connection is kept unchanged.
The method according to any one of claims 1-3, further comprising:

If the duration is greater than or equal to the first preset duration, check whether the database connection has transmission content.
A database connection management device, characterized in that it comprises:

The determining module is used to determine the duration of the database connection being occupied by the application when the database connection is occupied by the application;

The processing module is configured to release the application's occupation of the database connection if it is determined that the duration is greater than or equal to the first preset duration, and the database connection has no transmission content detected.
The device according to claim 7, wherein the determining module is specifically configured to:

Record the starting time when the database connection is occupied by the application;

The current time is acquired according to the first preset period, and the duration of the current time minus the start time is used as the duration; the first preset period is less than the first preset duration.
The device according to claim 8, wherein the processing module is further configured to:

If it is verified that there is transmission content connected to the database, the current time is used to replace the start time.
The device according to any one of claims 7-9, wherein the processing module is specifically configured to:

Intercepting the database connection in an aspect, and storing the intercepted content of the aspect in a first variable; the default value of the first variable is empty;

If the value of the first variable is empty within the second preset time period, it is determined that the database connection has no transmission content; otherwise, it is determined that the database connection has transmission content.
9. The device according to any one of claims 7-9, wherein the processing module is further configured to:

When it is determined that the duration is less than the first preset time period, or it is verified that the database connection has transmission content, the database connection is kept unchanged.
The device according to any one of claims 7-9, wherein the processing module is specifically configured to:

If the duration is greater than or equal to the first preset duration, check whether the database connection has transmission content.
A database connection management device, characterized in that it comprises:

At least one processor; and,

A memory communicatively connected with the at least one processor; wherein,

The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can execute the database connection of any one of claims 1 to 6 Management methods.
A non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to make the computer execute the database according to any one of claims 1 to 6 Connection management method.
A computer program product, characterized in that, the computer program product includes a calculation program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, and when the program instructions are executed by a computer, The computer executes the database connection management method of any one of claims 1-6.