How to solve After Tomcat's database connection pool reaches the maximum value, maxActive = "100" will cause an error

lzrizc

After Tomcat's database connection pool reaches the maximum value, maxActive = "100" will cause an error.
   Is there any way to make a prompt page when no connection is available, telling that the website is busy now and try again later?

It should be when I take the connection to log in to the project I made. At this time, I need to verify the user name and password. If I can't get the connection, I will be prompted.

How to write the specific judgment that the connection cannot be obtained?

lzrizc

Who will give pointers. Please help.

自由的雪

Make a mark, I hope the expert will come

wh_family

In the program, when the connection used = 100, your program will go to the database to get the connection, the database will report an error, you catch this error, and then turn to a page prompt!

mikescotte

Upstairs is right

tellyou

How is it possible to reach maxActive 100? ? ! !

The landlord knows how to use DataSource / DBCP?

liteding

The landlord may be the application's own connection pool program, right?
A piece of code should be written to control the inaccessibility when the number of connections reaches the maximum

It is best to create a new connection when the number of connections reaches the maximum, so as to avoid the situation of inaccessibility and errors.
Or you can use catch to catch the exception, and then do the corresponding processing in the catch, or catch the exception and then output, or do the error page jump!

tellyou

What I want to ask is why a Tomcat BS system will achieve such a large amount of concurrency.

mikescotte

May not close the connection

lzrizc

to:liteding, thank you for your answer. I didn't expect it. Catch it directly.
  to:tellyou, I don't know what you are doing.
to:others .3Q