Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Message-ID: <407ED5B7.5050401@pandora.be>
Date: Thu, 15 Apr 2004 20:34:31 +0200
From: Dirk Verbeeck <dirk.verbeeck@pandora.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
MIME-Version: 1.0
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: [dbcp] How could I find out the application methods that hold
  the active connections?
References: <14B8A075A9E35D40B58E5BB746D6C4403430C4@tlg-01.tlg.ca>
In-Reply-To: <14B8A075A9E35D40B58E5BB746D6C4403430C4@tlg-01.tlg.ca>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

ok, maybe the simplest way is to change the output to go to stdout.
Change the following lines:
             System.err.println(format.format(new Date(createdTime)));
             createdBy.printStackTrace();
to:
             System.out.println(format.format(new Date(createdTime)));
             createdBy.printStackTrace(System.out);
in AbandonedTrace.java
http://cvs.apache.org/viewcvs.cgi/*checkout*/jakarta-commons/dbcp/src/java/org/apache/commons/dbcp/AbandonedTrace.java?rev=1.11

Cheers
Dirk

Sheng Huang wrote:

> Hi Dirk,
> 
> The problem is that catalina.out records connections not closed, but not the
> connections borrowed (the stderr messages containing which method borrowed a
> connection for my analysis of connection leaking).
> 
> Best regards,
> Sheng
> 
> -----Original Message-----
> From: Dirk Verbeeck [mailto:dirk.verbeeck@pandora.be]
> Sent: April 15, 2004 12:41 PM
> To: Jakarta Commons Users List
> Subject: Re: [dbcp] How could I find out the application methods that
> hold the active connections?
> 
> 
> On Linux it's even easier.
> There should be a $CATALINA_BASE/logs/catalina.out file already.
> 
> Regards
> Dirk
> 
> Sheng Huang wrote:
> 
>>Hi Dirk,
>>
>>Thank you very much for your reply. However, I am running my application
> 
> on
> 
>>a Linux box. I always use ./catalina.sh start because the Tomcat process
>>started with "./catalina.sh run" or "./catalina.sh run &" will get
>>terminated when the shell window timeouts or gets closed. 
>>
>>Is there a workaround with "./catalina.sh run" so that I can redirect the
>>stderr log? Thank you very much.
>>
>>Best regards,
>>Sheng
>>
>>-----Original Message-----
>>From: Dirk Verbeeck [mailto:dirk.verbeeck@pandora.be]
>>Sent: April 14, 2004 2:13 PM
>>To: Jakarta Commons Users List
>>Subject: Re: [dbcp] How could I find out the application methods that
>>hold the active connections?
>>
>>
>>Try:
>>    catalina run >stdout.log 2>stderr.log
>>
>>Cheers
>>Dirk
>>
>>
>>Sheng Huang wrote:
>>
>>
>>
>>>Hi Dirk,
>>>
>>>Thank you very much for your reply. Now I understand the connections
>>
>>closed
>>
>>
>>>in my configuration are active connections instead of inactive
>>
>>connections.
>>
>>
>>>Although I see a lot of "DBCP object created was never
>>>closed" followed by "Already closed" as I said in my first email, all
>>>connections will become active after the application is used for some time
>>>and then the application stalls (wait unlimited for available
>>
>>connections).
>>
>>
>>>There may be some defects in my code, thus the stacktrace for DBCP object
>>>creation will be very helpful to me. Since I just installed Tomcat 4.1.18
>>>with the default configuration (standalone Tomcat instead of Tomcat and
>>>Apache), I can't see the stderr messages logged somewhere and don't know
>>
>>how
>>
>>
>>>to set it up. Could you give me some information on how to setup stderr
>>>logging or redirect them to the standard catalina.out? Thank you very
>>
>>much.
>>
>>
>>>Best regards,
>>>Sheng
>>> 
>>>
>>>
>>>When you get a "DBCP object created..." message then there should also be
>>
>>a
>>
>>
>>>stacktrace be written. With version 1.1 the message goes to stdout and the
>>>stacktrace to stderr. In the nightly builds they go both go to stderr.
>>>
>>>The stacktrace displays the location where is abandoned connection was
>>>borrowed.
>>>
>>>
>>>The removeAbandoned parameter is for removing the active connections.
>>>Idle connections are removed with "minEvictableIdleTimeMillis".
>>>
>>>-- Dirk
>>>
>>>---------------------------------------------------------------------
>>>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
> 
> ---------------------------------------------------------------------
> 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