-------- 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? I thought this would be one pool shared by all. I will try it as you suggested with server.xml. best wishes, Claus > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
