Method and device for managing database connection

A database and connection parameter technology, applied in the database field, can solve problems affecting the normal operation of applications, heavy maintenance of connection pools, and prone to configuration errors

Active Publication Date: 2015-09-30
中国移动通信集团云南有限公司
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 an...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for managing database connection
  • Method and device for managing database connection
  • Method and device for managing database connection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention.

[0034] see figure 1 , is a structural diagram of the connection between the application program and the database, from which it can be known that the connection between the application program 10 and the database 20 is performed through the database connection pool 30 provided by the middleware, but from the description in the background technology, it can be found that the existing connection There are many problems in the pool technology, so the embodiment of the present invention avoids the problems in the background technology by improving the database connection pool 30 provided by the middleware.

[0035] see figure 2 , a method for managing database connections provided by the embodiment of the present invention, the database connection pool 30 between the application...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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 ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06F21/62
Inventor 马秋蓉谭旭杨文松李海涛李海波
Owner 中国移动通信集团云南有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap