Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DbConnectionBroker connection pool issue

 
SenthilKumar Natarajan
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We have developed an application with the following architecture.

1) Windows NT 4.0 and Windows XP
2) Oracle 8.0
3) JDK 1.3.1_01 (Standard Edition), JSP, Servlet, Java IDL (CORBA).
4) Apache Web Server 1.3.20
5) Tomcat 3.2.2
6) DbConnectionBroker for connection pool
7) Thin Driver
8) Proprietary Application Server

(DbConnectionBroker is a pure Java package for handling multiple concurrent database connections. DbConnectionBroker creates a broker with a very simple interface for handing out and returning database connections from a configurable pool of connections. The Broker creates a dynamic pool of connections and manages them for you with a background housekeeping thread.)

In this application we are using two connection pools. Application server creates first connection pool for main application and Tomcat creates second connection pool for Store Front at the time of first access of the Store Front.

In the above architecture the application running properly.


Now we have a plan of upgrading Apache Web Server, Tomcat and JDK in the architecture as follows,

1) JDK 1.4(Standard Edition), JSP, Servlet, Java IDL (CORBA).
2) Apache Web Server 2.0
3) Tomcat 5.0

And others are same.

In the above new setup main application is working fine without accessing Store Front. At the same time, if we try to access Store Front also works fine. Problem occurs when we try to access main application again.

Now we are facing a problem in getting connection from connection pool. The problem is occurred in DbConnectionBroker. The error is

-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 3
-----> Connections Exhausted! Will wait and try again in loop 3
-----> Connections Exhausted! Will wait and try again in loop 4

We are closing the statements and freeing the connection.

Would any one have solutions / suggestions to help on this?

Thanks,
-Senthil
 
Roger Chung-Wee
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The poolMaxConnections value is probably set to 10. See what happens if you double to value to 20.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic