Re: pool error timeout waiting for idle object

2010-09-09 Thread Mark Thomas
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

Re: pool error timeout waiting for idle object

2010-09-09 Thread sasidhar prabhakar
> 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 conne

Re: pool error timeout waiting for idle object

2010-09-09 Thread Mark Thomas
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. >

Re: pool error timeout waiting for idle object

2010-09-09 Thread sasidhar prabhakar
; > 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

Re: pool error timeout waiting for idle object

2010-09-09 Thread Wesley Acheson
On Thu, Sep 9, 2010 at 8:57 AM, 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 1

pool error timeout waiting for idle object

2010-09-08 Thread sasidhar prabhakar
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

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

2007-08-12 Thread Christopher Schultz
-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 connec

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

2007-08-12 Thread David Smith
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) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource

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

2007-08-12 Thread Pid
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 ou

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

2007-08-12 Thread fusion35
-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] For

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

2007-08-12 Thread David Smith
ion35 wrote: context.xml : 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(PoolingDataSo

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

2007-08-12 Thread Rashmi Rubdi
quot; maxWait="1000" > name="jdbc/PAFDB" password="root" timeBetweenEvictionRunsMillis="6" > type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/pafdb" > username="root"/> > > > > The log o

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

2007-08-12 Thread fusion35
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) at

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

2007-08-11 Thread David Smith
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

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

2007-08-11 Thread Devinder Singh Mahil
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, e-m

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

2007-08-11 Thread fusion35
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 at