• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DbConnectionBroker connection pool issue

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The poolMaxConnections value is probably set to 10. See what happens if you double to value to 20.
reply
    Bookmark Topic Watch Topic
  • New Topic