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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
