Hi,
I couldnt get a better place to post my question.
I'm getting org.apache.commons.dbcp.DbcpException: java.sql.SQLException
Cannot get a connection, Connection pool exhausted.
I'm using spring with Tomcat 6 to manage the Connection pooling. My
application is a 3 tier application (Swing + Tomcat 6/Spring/RMI + Database
Oracle 10g)
The database has multiple schemas running and the no. of processes are set
to 300.
Here is the entry for the spring-servlet.
<property name="maxActive">
<value>3000</value>
</property>
<property name="maxWait">
<value>10000</value> <!-- Wait for a connection from the pool
for 10 sec, then time out -->
</property>
</bean>
I dont have any other entry related to timeout/removeabondoned etc.
I've to restart the server frequently due to this exception (The frequency
is once in every two days).
Am i missing any importnt property? I'm not able to figure out where to
check the closing connections (A lot of Google threads talk about close
connections as a major reason behind the failure.)
Is there any relation in no. of processes (300) set on oracle and the
maxActive (3000) in servlet xml?
Can anybody throw some light on this issue?
ajay kumar wrote:
>
> Hi Everybody,
>
> This is Ajay Kumar.I implemented DBCP through tomcat
> container.Some times when i run the webpages it is giving the
> following Exception:
>
> org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server
> connection failure during transaction. Attempted reconnect 3 times.
> Giving up
>
> I think it is the problem with the values which are
> mentioned in the server.xml for DBCP.Here are the details of
> server.xml
>
> <parameter>
> <name>maxActive</name>
> <value>100</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>20</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
> <parameter>
> <name>removeAbandoned</name>
> <value>true</value>
> </parameter>
> <parameter>
> <name>removeAbandonedTimeout</name>
> <value>300</value>
> </parameter>
> <parameter>
> <name>logAbandoned</name>
> <value>true</value>
> </parameter>
>
> If any body know the solution please mail me the
> details.Thanks in advance...
>
> -- Ajay
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/org.apache.commons.dbcp.DbcpException%3A-java.sql.SQLException-tf69524.html#a13475886
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
