Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Connection pooling problem

 
Karthikean Konangi
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I am using Tomcat5.5 DB Connection pooling, through server.xml .
My context is:

<Context path="/POModule" docBase="POModule"
debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/POModule" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbcracle:thin:@144.20.35.123:1521:ABC" username="root" password="root" maxActive="100" maxIdle="60" maxWait="200"/>


But i am getting following exception after some users loged in.

Exceptionsrg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object


Please help.
Thanks.
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
--------------------------------------------------------
<Context path="/POModule" docBase="POModule"
debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/POModule" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbcracle:thin:@144.20.35.123:1521:ABC" username="root" password="root" maxActive="100" maxIdle="60" maxWait="200"/>
----------------------------------------------------------

where is your <resource params>?..please search google for the configuration..and make this file name as your we-app name ,then put it into the Tomcat 5.0\conf\Catalina\localhost..


thanks & regards,
seetharaman
 
K Kiran Kumar
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please look into the below link for sample configuration:

http://www.crazysquirrel.com/computing/java/connection-pooling.jspx

Regards,
Kiran.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic