[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:       "Claus Hausberger" <CHausberger () gmx ! de>
Date:       2011-04-04 6:43:37
Message-ID: 20110404064337.58340 () gmx ! net
[Download RAW message or body]

Hi Mark,

thank you very much. This is extremely helpful!!!

best wishes,

Claus


-------- Original-Nachricht --------
> Datum: Fri, 01 Apr 2011 14:58:25 +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 14:56, Claus Hausberger wrote:
> > 
> > -------- Original-Nachricht --------
> >> Datum: Fri, 01 Apr 2011 14:49:56 +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 13:38, Claus Hausberger wrote:
> >>>
> >>> -------- 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"
> >>>     />
> >>
> >> And there is the problem. conf/context.xml provides the defaults for
> >> every web application so every context deployed on that instance will
> >> have a resource as configured as above.
> >>
> >> If you want a shared resource, define it in server.xml and put a
> >> resource link in conf/context.xml.
> >>
> >> Mark
> >>
> > 
> > Hi Mark,
> > 
> > thanks. Do I understand this correctly? If my file (context.xml) defines
> maxActive=20 and I have 4 apps using this, everyone get's it's own 20
> connections, making it at most 80?
> 
> Correct.
> 
> > I thought this would be one pool shared by all. 
> 
> Nope.
> 
> > I will try it as you suggested with server.xml.
> 
> That should fix it.
> 
> Mark
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 

-- 
GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit 
gratis Handy-Flat! http://portal.gmx.net/de/go/dsl

---------------------------------------------------------------------
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]