From tomcat-user Mon Apr 04 06:43:37 2011 From: "Claus Hausberger" Date: Mon, 04 Apr 2011 06:43:37 +0000 To: tomcat-user Subject: Re: Problem with too many open db connections on Tomcat Message-Id: <20110404064337.58340 () gmx ! net> X-MARC-Message: https://marc.info/?l=tomcat-user&m=130189945826122 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 > An: Tomcat Users List > 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 > >> An: Tomcat Users List > >> 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 > >>>> An: Tomcat Users List > >>>> 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: > >>> > >>> >>> 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