DB Connection pooling problem

[Karthikean Konangi]

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="jdbc:oracle: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.

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


Please help.
Thanks.

[Seetharaman Venkatasamy]

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="jdbc:oracle: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]

Please look into the below link for sample configuration:

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

Regards,
Kiran.