On 01/04/2011 14:56, Claus Hausberger wrote: > > -------- Original-Nachricht -------- >> Datum: Fri, 01 Apr 2011 14:49:56 +0100 >> Von: Mark Thomas <ma...@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 <ma...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org