tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Madan KN <madan...@gmail.com>
Subject Re: Tomcat JDBC Pooling - Connections
Date Mon, 08 Apr 2013 14:28:38 GMT
# 99% percent of the time we do have need for 200 active sessions across
our application cluster. But due to some high spikes we end up with 2000
sessions which is ending up in the pool with out getting evicted.*

*
# I think once the application is out of peak the connections are returned
in either Round Robin/Random order, which is not making the condition for
connections inactivity timeout and sweeper is failing to evict those
connections.
*
*
# How do we set something like LIFO, so that we can control and use only
required connections during normal operating scenarios & evict which are
not required.*
*
*
--------------------------------*-------------------
*Configuration Being Used*
---------------------------------------------------
    <Resource name="jdbc/GlobalHotelsDS" auth="Container"
                     type="oracle.jdbc.pool.OracleDataSource"
                     driverClassName="oracle.jdbc.driver.OracleDriver"
                     factory="oracle.jdbc.pool.OracleDataSourceFactory"
                     queryTimeout="50"

_connectionProperties="oracle.jdbc.ReadTimeout=30000,oracle.net.CONNECT_TIMEOUT=30000"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
test.dev.com)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=test.dev.com)(PORT=1522))(LOAD_BALANCE=yes)(CONNECT_DATA=
(SERVER=DEDICATED)(SERVICE_NAME=test.service.com)))"
                     user="xxxxxx"
                     password="xxxxxxx"
                     connectionCachingEnabled="true"
                     connectionCacheName="testPool"

connectionCacheProperties="MaxLimit=20,InitialLimit=10,MaxStatementsLimit=80,InactivityTimeout=1800"/>


*Thanks*,
Madan KN



On Mon, Apr 8, 2013 at 6:15 PM, Daniel Mikusa <dmikusa@vmware.com> wrote:

> On Apr 8, 2013, at 3:23 AM, Madan KN wrote:
>
> > *Hi All,*
> >
> > Currently we are using tomcat jdbc pooling for oracle 11g R12.
>
> What version of Tomcat are you using?  If you are using the pool directly
> outside of Tomcat, what version of it are you using?
>
> > The problem
> > we are facing is during the peak traffic (less than %2) of time the
> > connections spike up to more than 100 sessions & never comes back to the
> > normal / desired pool size.
>
> It would be helpful to see your configuration.  Please post it here, minus
> comments.
>
> > Due to the connections are returned either in
> > Round-Robin/Random to the application.
>
> How are you determining this?  Can you provide some background on why you
> think this is causing a problem?
>
> >
> > Is there a way we can try LIFO so that connections to evict idle /
> unwanted
> > pool size beyond certain limit?
>
> Not sure exactly what you mean here.  Is the "fairQueue" option what you
> are looking for?
>
>   https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
>
> Dan
>
>
> >
> > *Madan KN*
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

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