Will JDBC multiple connections make the connection pool unstable?

提亚娜

If it is unstable, is there any way to connect automatically and close automatically?

yuhui5094

First of all, "connections" refers to the connection between your application server and database server, not the connection between client IE and your web / application server.

The database connection buffer pool is to reduce the overhead of each time a connection is established / released. Therefore, the connection returned by the terminal is not closed directly, but is reserved for other programs in the future. Returned to the pool, the ones that are not used are called idle, and the ones that are lent out are called active.

So as the name suggests, maxIdle means that when the idle connection in the pool reaches this value, all returned connections will be released directly until the number of idle connections in the pool is lower than maxIdle because other programs continue to lend. In addition, the maximum time for idle is generally set, such as more than 30 seconds, idle connection is also wasted, so turn it off

The maxActive person represents the maximum number of connections you can borrow from this pool. When lending, when there is an idle in the pool, the idle is used. If there is no one and the maxActive is not reached, a new one is created. If the value of maxActive has been reached, there are generally the following types according to different pool types and / or different settings:

1 Direct throw
2 Let the thread that wants to lend a connection wait for a while, if it can't wait, throw an error
3 Check the pool every other period until there are available connections, otherwise wait forever
4 Always available (maxActive is not set or 0 or negative as needed)
-------------------------------------------------- ----
Come here! After reading it, it is estimated that the questions you ask can be answered! !!

提亚娜

Thank you upstairs.