• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Bear Bibeault
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • salvin francis
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Frits Walraven
Bartenders:
  • Jj Roberts
  • Carey Brown
  • Scott Selikoff

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.
 
Can you hear that? That's my theme music. I don't know where it comes from. Check under this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic