aspose file tools*
The moose likes Tomcat and the fly likes DB Connection pooling problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "DB Connection pooling problem" Watch "DB Connection pooling problem" New topic
Author

DB Connection pooling problem

Karthikean Konangi
Greenhorn

Joined: Jan 31, 2008
Posts: 22
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.


Regards,
KonangiK
Seetharaman Venkatasamy
Ranch Hand

Joined: Jan 28, 2008
Posts: 5575

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

Joined: Jan 04, 2006
Posts: 109
Please look into the below link for sample configuration:

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

Regards,
Kiran.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB Connection pooling problem
 
Similar Threads
connection pooling tomcat 5.0.28 urgent plz...
Connectionpooling in tomcat 5.5
Connection Pooling Problem
Problem in implementing connection pooling in tomcat6.0
How do I implement Connection Pooling with Tomcat 5.0.2.7 and MySQL 4.1