[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:       Mark Thomas <markt () apache ! org>
Date:       2011-04-01 13:49:56
Message-ID: 4D95D804.8050106 () apache ! org
[Download RAW message or body]

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



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