commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Garth Keesler <gar...@gdcjk.com>
Subject Re: DBCP Connection Pool Problem
Date Wed, 17 Jan 2007 15:58:23 GMT
Thanx much! That's what I needed.

Garth

Lorenzo Jiménez wrote:
> You can put it in 2 places: a) META-INF/context.xml b) server.xml
>
> a) This is the content of context.xml
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Context displayName="My Application" path="/myapp" reloadable="false">
>   <Resource auth="Container" 
>             driverClassName="com.sybase.jdbc2.jdbc.SybDriver" 
>             initialSize="5" 
>             maxIdle="10"
>             maxActive="30" 
>             maxWait="15000" 
>             logAbandoned="false" 
>             removeAbandonedTimeout="120" 
>             name="jdbc/myapp" 
>             password="my_password" 
>             type="javax.sql.DataSource" 
>             url="jdbc:sybase:Tds:0.0.0.0:5000/MYDB"
>             username="my_user"/>
> </Context>
>
> b)  Between <GlobalNamingResources> and </GlobalNamingResources>
>
>
> Lorenzo
>
> -----Original Message-----
> From: Garth Keesler [mailto:garthk@gdcjk.com] 
> Sent: Wednesday, January 17, 2007 9:39 AM
> To: Jakarta Commons Users List
> Subject: Re: DBCP Connection Pool Problem
>
> Can someone please indicate where the following is located in the 
> hierarchy of the server.xml file? I'm trying to set up DBCP but am not 
> sure exactly where to insert the <Resource source xml.
>
> Sorry to cut in...
>
> Thanx,
> Garth
>
> Lorenzo Jiménez wrote:
>   
>> Maybe DBCP you have to remove the abandoned connections. Try this:
>>
>>   <Resource auth="Container" 
>>             driverClassName="com.sybase.jdbc2.jdbc.SybDriver" 
>>             initialSize="5" 
>> -->         logAbandoned="false" 
>>             maxActive="15" 
>>             maxIdle="10" 
>>             maxWait="30000" 
>>             name="jdbc/xxxx" 
>>             password="xxxx" 
>> -->         removeAbandoned="true" 
>> -->         removeAbandonedTimeout="60" 
>>             type="javax.sql.DataSource" 
>>             url="xxxx" 
>>             username="xxxx"/>
>> </Context>
>>
>> Hope that helps.
>> Regards,
>>
>> Lorenzo
>>
>>
>> -----Original Message-----
>> From: sailormo@seed.net.tw [mailto:sailormo@seed.net.tw] 
>> Sent: Wednesday, January 17, 2007 2:39 AM
>> To: commons-user@jakarta.apache.org
>> Subject: DBCP Connection Pool Problem
>>
>> Hello:
>>
>> When I get the current Active Connection Number, it says 800,
>> but actually DBA checked the Database connection, it's only 2x.
>> Why they are inconsistant?
>>
>> Thanks for the answer.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>> Si usted no es el destinatario indicado en este mensaje o responsable como persona
de la entrega del mensaje, no debe copiar o reenviar este mensaje, por favor notifique al
correo infosegura@nacion.com.  Para más referencia sobre términos importantes relacionados
a este correo visite http://www.nacion.com/disclaimer/index_es2.htm
>>
>> If you are not the addressee indicated in this message (or responsible for delivery
of the message to such person), you may not copy or send this message to anyone, please notify
to infosegura@nacion.com.  Click on the following link for important additional terms relating
to this e-mail http://www.nacion.com/disclaimer/index_en2.htm
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>>
>> .
>>
>>   
>>     
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
> .
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message