tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wesley Acheson <wesley.ache...@gmail.com>
Subject Re: pool error timeout waiting for idle object
Date Thu, 09 Sep 2010 07:02:07 GMT
On Thu, Sep 9, 2010 at 8:57 AM, sasidhar prabhakar
<sasidhar1229@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.
> 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 to
> minimum.
>
> In tomcat I configured max threads 300.
>
> context.xml is
>
> <Context path="" reloadable="true">
> <Resource
> accessToUnderlyingConnectionAllowed="true"
> auth="Container"
> driverClassName="oracle.jdbc.OracleDriver"
>  maxActive="200"
>  maxIdle="10"
>  maxWait="8000"
> validationQuery="SELECT * from dual"
> testOnBorrow="true"
> removeAbandoned="true"
> removeAbandonedTimeout="30"
> logAbandoned="true"
> name="jdbc/ds"
>  password=""
> type="javax.sql.DataSource"
>  url=""
>  username=""/>
> <Resource auth="Container" name="mail/Session" type="javax.mail.Session"
> mail.smtp.host="localhost"/>
>
> </Context>
>
> For few days I am getting this problem.
>

More than likely a problem with your Oracle. When you can't get the
sessions are you able to get them through another means such as toad
or SQLDeveloper.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message