My application sometimes responding very slow.
When I observed the logs, it is showing these lines
Cannot get a connection, pool error Timeout waiting for idle object.
The maximum connections on oracle I set 150.
When I query for present sessions or process it is showing 70 to 80 and
decreasing
On Thu, Sep 9, 2010 at 8:57 AM, sasidhar prabhakar
sasidhar1...@gmail.com wrote:
My application sometimes responding very slow.
When I observed the logs, it is showing these lines
Cannot get a connection, pool error Timeout waiting for idle object.
The maximum connections on oracle I set 150
these lines
Cannot get a connection, pool error Timeout waiting for idle object.
The maximum connections on oracle I set 150.
When I query for present sessions or process it is showing 70 to 80 and
decreasing to minimum of
52, sometimes it grows up to 100 above also and it decreasing back
On 09/09/2010 07:57, sasidhar prabhakar wrote:
My application sometimes responding very slow.
When I observed the logs, it is showing these lines
Cannot get a connection, pool error Timeout waiting for idle object.
The maximum connections on oracle I set 150.
snip/
maxActive=200
wrote:
My application sometimes responding very slow.
When I observed the logs, it is showing these lines
Cannot get a connection, pool error Timeout waiting for idle object.
The maximum connections on oracle I set 150.
snip/
maxActive=200
That doesn't look right.
There are lots
On 09/09/2010 10:17, sasidhar prabhakar wrote:
tomcat - 6
oracle 11g
centos 5
jdbc type 4
That information isn't close to complete and is pretty much useless.
When asked for a version number, please provide the *full* version number.
You also missed out the JDBC driver version.
This is a
The log of error is as under :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104
=root/
/Context
The log of error is as under :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104
timeBetweenEvictionRunsMillis=6
type=javax.sql.DataSource url=jdbc:mysql://localhost:3306/pafdb
username=root/
/Context
The log of error is as under :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
-Timeout-waiting-for-idle-object-tf4253064.html#a12114714
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
fusion35 wrote:
Setting the maxactive other than 0 did the trick. Thanks David. You were
right, I was after no limit (which I have now set to -1)
regards
Devinder
FYI including a path attribute in the default context.xml is pointless,
as that attribute is ignored when a Context is defined
://localhost:3306/pafdb
username=root/
/Context
The log of error is as under :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devinder,
fusion35 wrote:
Setting the maxactive other than 0 did the trick. Thanks David. You were
right, I was after no limit (which I have now set to -1)
I would highly recommend /against/ no limit connection pools. Even if
you set the
Hello,
I get the captioned error. Same works good with Tomcat 5.5
Tomcat 6.0.14
JDK 1.6_2
WinXP
The text of the error is :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
I get the captioned exception when I try to connect to a mysql DB.
Tomcat 6.0.14
JDK 1.6_2
WinXP
what causes the error to occur? The same application works in tomcat 5.5
thanks in advance
Devinder
-
To start a new topic,
Your not providing a lot of context here, so we can only guess. The
error implies the pool is exhausted. Can you provide details on the
pool config and when/where this error occurs? Additionally, you might
want to check out the DBCP website at http://jakarta.apache.org/commons/dbcp
--David
16 matches
Mail list logo