[prev in list] [next in list] [prev in thread] [next in thread] 

List:       tomcat-user
Subject:    RE: Problem with too many open db connections on Tomcat
From:       "Propes, Barry L " <barry.l.propes () citi ! com>
Date:       2011-04-01 13:47:13
Message-ID: 08382548D50D3049BD5599E1E3146B3411AF00E8E5 () exgtmb06 ! nam ! nsroot ! net
[Download RAW message or body]

Are you able to insert these attributes in the Resource tag?

    timeBetweenEvictionRunsMillis="-1"
    minEvictableIdleTimeMillis="5000"
    poolPreparedStatements="true"
    removeAbandoned="true"
    removeAbandonedTimeout="300"

I have these attributes nested in my Resource element - I never used 5.5 but use \
6.0.29 and I believe it helps with potential rogue connections.


-----Original Message-----
From: Claus Hausberger [mailto:CHausberger@gmx.de]
Sent: Friday, April 01, 2011 7:38 AM
To: Tomcat Users List
Subject: Re: Problem with too many open db connections on Tomcat


-------- Original-Nachricht --------
> Datum: Fri, 01 Apr 2011 12:44:28 +0100
> Von: Mark Thomas <markt@apache.org>
> An: Tomcat Users List <users@tomcat.apache.org>
> Betreff: Re: Problem with too many open db connections on Tomcat

> On 01/04/2011 12:36, Claus Hausberger wrote:
> > Hello,
> > 
> > I have a problem with Tomcat and open connections to an Oracle 11g
> database.
> > 
> > I use Tomcat 5.5, DBCP 1.2 and Hibernate 3.3 + Spring for DB
> connections.
> > For political reasons I can not upgrade to new Tomcat versions at
> > the
> moment.
> > 
> > I have 7 deployed apps on the Tomcat. 4 user a datasource configured
> > for
> Tomcat itself (in context.xml) with a setting of maxActiv=20. This
> datasource is used by Hibernate via JNDI.
> 
> Which context.xml file? Exactly where is it located?
> 
> Mark
> 

Hi Mark,

the file is in the Tomcat folder under:

conf/context.xml

this is the config:

<Resource name="jdbc/myDS" auth="Container"
        type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
        url="jdbc:oracle:thin:@my-oracle-host:mysid" username="xxx"
        password="XXX" maxActive="20" maxIdle="10" maxWait="-1"
    />


regards,

Claus


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

--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu \
50,- Euro! https://freundschaftswerbung.gmx.de

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


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


[prev in list] [next in list] [prev in thread] [next in thread]