Return-Path: 
 <users-return-233423-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
X-Original-To: apmail-tomcat-users-archive@www.apache.org
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 8B6EF9725
	for <apmail-tomcat-users-archive@www.apache.org>;
 Fri,  6 Apr 2012 14:00:28 +0000 (UTC)
Received: (qmail 90018 invoked by uid 500); 6 Apr 2012 14:00:25 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 89905 invoked by uid 500); 6 Apr 2012 14:00:25 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 89895 invoked by uid 99); 6 Apr 2012 14:00:25 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2012 14:00:25 +0000
X-ASF-Spam-Status: No, hits=-5.0 required=5.0
	tests=RCVD_IN_DNSWL_HI,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [208.91.2.13] (HELO smtp-outbound-2.vmware.com) (208.91.2.13)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2012 14:00:17 +0000
Received: from sc9-mailhost2.vmware.com (sc9-mailhost2.vmware.com
 [10.113.161.72])
	by smtp-outbound-2.vmware.com (Postfix) with ESMTP id DC2CB28176
	for <users@tomcat.apache.org>; Fri,  6 Apr 2012 06:59:56 -0700 (PDT)
Received: from zimbra-prod-mta-1.vmware.com (zimbra-prod-mta-1.vmware.com
 [10.113.160.173])
	by sc9-mailhost2.vmware.com (Postfix) with ESMTP id D90F8B0395
	for <users@tomcat.apache.org>; Fri,  6 Apr 2012 06:59:56 -0700 (PDT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by zimbra-prod-mta-1.vmware.com (Postfix) with ESMTP id D44A67C7F8
	for <users@tomcat.apache.org>; Fri,  6 Apr 2012 06:59:56 -0700 (PDT)
X-Virus-Scanned: amavisd-new at zimbra-prod-mta-1.vmware.com
Received: from zimbra-prod-mta-1.vmware.com ([127.0.0.1])
	by localhost (zimbra-prod-mta-1.vmware.com [127.0.0.1]) (amavisd-new,
 port 10024)
	with ESMTP id 5kul1beZcTqM for <users@tomcat.apache.org>;
	Fri,  6 Apr 2012 06:59:56 -0700 (PDT)
Received: from zimbra-prod-mbox-5.vmware.com (zimbra-prod-mbox-5.vmware.com
 [10.113.160.194])
	by zimbra-prod-mta-1.vmware.com (Postfix) with ESMTP id C41AA7C7EE
	for <users@tomcat.apache.org>; Fri,  6 Apr 2012 06:59:56 -0700 (PDT)
Date: Fri, 6 Apr 2012 06:59:56 -0700 (PDT)
From: Daniel Mikusa <dmikusa@vmware.com>
To: Tomcat Users List <users@tomcat.apache.org>
Message-ID: <924777.97.1333720795922.JavaMail.daniel@cleveland>
In-Reply-To: <1333718339.19305.74.camel@twotower>
Subject: Re: Where can I find slow query log produced by tomcat-jdbc?
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Originating-IP: [24.160.217.1]
X-Mailer: Zimbra 7.1.3_GA_3374 (Zimbra Desktop/7.1.4_11273_Linux)
X-Virus-Checked: Checked by ClamAV on apache.org

Just saw this too. 

  https://issues.apache.org/bugzilla/show_bug.cgi?id=51237

You might want to check what version you are using.

Dan


----- Original Message -----
> Pool works nice, but
> I get empty logs/pool.2012-04-06.log
> No debug messages, no slow query's.
> Configuration below
> 
> -----------------------------------------------------------
> datasource.xml:
> 
> <bean id="dataSourceOnline"
> class="org.apache.tomcat.jdbc.pool.DataSource"
> destroy-method="close"
>       p:driverClassName="oracle.jdbc.driver.OracleDriver"
>       p:url="${jdbcPortalUrl}"
>       p:username="${jdbcUser}"
>       p:password="${jdbcPass}"
> 
> p:connectionProperties="oracle.jdbc.defaultNChar=true;oracle.jdbc.convertNcharLiterals=true;oracle.jdbc.ReadTimeout=${jdbcTimeOut};"
> 
> p:jdbcInterceptors="SlowQueryReport(threshold=10);ConnectionState;StatementFinalizer"
>       p:initialSize="10"
>       p:minIdle="10"
>       p:maxIdle="100"
>       p:maxActive="5000"
>       p:maxWait="6000"
>       p:jmxEnabled="true"
>       p:removeAbandoned="true"
>       p:removeAbandonedTimeout="130"
>       p:logAbandoned="true"
>       p:testOnBorrow="false"
>       p:testOnReturn="false"
>       p:testWhileIdle="false"
>       p:useEquals="false"
>       p:fairQueue="false"
>       p:timeBetweenEvictionRunsMillis="30000"
>       p:minEvictableIdleTimeMillis="30000"
>       p:validationInterval="1800000"
>       p:validationQuery="SELECT 1 FROM DUAL"
>   />
> -------------------------------------------------------
> ${catalina.home}/conf/logging.properties:
> 
> handlers = 1catalina.org.apache.juli.FileHandler,
> 2localhost.org.apache.juli.FileHandler,
> 3manager.org.apache.juli.FileHandler,
> 4host-manager.org.apache.juli.FileHandler,
> 5pool.org.apache.juli.FileHandler,, java.util.logging.ConsoleHandler
> 
> 5pool.org.apache.juli.FileHandler.level = ALL
> 5pool.org.apache.juli.FileHandler.directory = ${catalina.base}/logs
> 5pool.org.apache.juli.FileHandler.prefix = pool.
> 
> org.apache.tomcat.jdbc.level = ALL
> org.apache.tomcat.jdbc.handlers = 5pool.org.apache.juli.FileHandler
> -------------------------------------------------------
> 
> 
> 
> ---------------------------------------------------------------------
> 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