i am having maximum 100 connections(initial 50, increment=5,max=100) configured in my connection pool. in the application runtime 100 users are already using the connections. now the App. Server is not allowed to create another.
now my ques. is.. 101th user has came in, and he wants to do urgent updation in the DB and he needs a connection.He cant wait b'coz he is in time bound application.in time he has to update. or else it is waste.
Is your load really that high? Are connections getting closed properly and freed up between uses? If your load isn't that high I would suspect they aren't getting returned to the pool. If they are, then why is the limit 100 if you need more than 100?
You server will not be able to decide which request is urgent. Even if it is able to do so it will not be able to decide which of the 100 connection is the least important so that it can kill the connection. If you have specified the max as 100, then the max is 100. The server will not open a 101st connection. It will wait for one of the 100 to close before it opens a new one for the waiting request.
He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever - Chinese proverb