tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henry Lu <z...@umich.edu>
Subject Re: Problem with too many open db connections on Tomcat
Date Fri, 01 Apr 2011 14:06:09 GMT
Is there a way to encrypt the password in the  Resource tag and tomcat 
can still read it and decrypt?

-Henry

On 4/1/2011 9:58 AM, Mark Thomas wrote:
> On 01/04/2011 14:56, Claus Hausberger wrote:
>> -------- Original-Nachricht --------
>>> Datum: Fri, 01 Apr 2011 14:49:56 +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 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
>>>
>> 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
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message