A method and device for obtaining database connection

Abstract

The invention provides a method and a device for obtaining a database connection, which stores a set number of database connections in a database connection pool, and creates a corresponding ThreadLocal object for each thread. When the thread receives the service request, whether the database connection is stored in the ThreadLocal object corresponding to the thread is detected, and if so, the database connection stored in the ThreadLocal object is obtained; otherwise, a database connection stored in the database connection pool is dumped into the ThreadLocal object; when the thread termination service is detected, the database connection stored by the ThreadLocal object corresponding to the thread is returned to the database connection pool and the ThreadLocal object is released. The scheme provided by the invention avoids multiple processing threads from acquiring the same database connection, thereby reducing the risk of data confusion in the database.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for acquiring database connections. Background technique [0002] For javaweb applications, when an access request is initiated through the client or terminal browser, the server-side container (tomcat) parses the received access request, and sends the parsed access request to the corresponding connector / connection interface (servlet ), that is, the server creates a processing thread for access requests, and the processing thread obtains a database connection to perform operations such as adding, deleting, modifying, and checking data in the database. [0003] At present, there are mainly two ways to obtain database connections. The first is to create a database connection for the processing thread after the processing thread is created. The second is to store a certain number of database connections in the database connection pool, and the processing thread...

AI Technical Summary

Problems solved by technology

When there are a large number of access requests, that is, when there are a large number of processing threads to obtain data connections, the first method will frequently create and destroy database connections, causing database congestion and performance bottlenecks in the database

Although the second method solves the problem of database congestion and performance bottlenecks in the database, multiple processing threads with the same function may obtain the same database connection from the database connection pool to add and delete data in the database. , modify, check and other operations, resulting in data confusion in the database

Images