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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
