tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anu Prab <anupr...@gmail.com>
Subject Re: Reg: Connection pool stats
Date Mon, 11 Nov 2013 05:59:16 GMT
On Nov 7, 2013, at 11:58 PM, Anu Prab <anuprab2@gmail.com> wrote:

>>> I am using Tomcat 7.0.42 and Tomcat jdbc pool.
>
>> Just to be perfectly clear, how are you using this?  With a <Resource/>
> tag in your Tomcat >configuration or are you creating the pool in your
> code?  Either way, include the necessary >config or code which shows how
> you've defined the pool.
>
>> The pool configuration is in context.xml. A sample of the config looks
like
> this:
>
>>  <Resource name="jdbc/name"
>>              auth="Container"
>>             type="javax.sql.DataSource"
>>              fairQueue="true"
>>             factory="<customized-factory>"

>What factory are you using?  It's important to share.  Without it we don't
know which pool you're using.

A customized factory which extends org.apache.tomcat.jdbc.pool.
DataSourceFactory
Few minutes, not sure of the exact timing. Yes, all are 0.

> Also, what happens when you try to get a connection after the pool count
has dropped to 0?  >Does it get a new connection?  Does it hang waiting?
 Does it generate any error messages?

>Is there any reason why you might be getting disconnected from the
database side or from a >firewall in between your application and the
database?

I can still get newer connections even after the count drops to 0.


Hi,

Also, when I enabled logAbandoned as you suggested, I see this exception
after about 17-18 minutes.

org.apache.tomcat.jdbc.pool.ConnectionPool abandon
WARNING: Connection has been abandoned
PooledConnection[oracle.jdbc.driver.T4CConnection@2726965a
]:java.lang.Exception
        at
org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1065)
        at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:707)
        at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
        at
org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)

-Anu

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message