tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Mikusa <dmik...@vmware.com>
Subject Re: Where can I find slow query log produced by tomcat-jdbc?
Date Fri, 06 Apr 2012 13:57:35 GMT
----- Original Message -----
> Pool works nice, but
> I get empty logs/pool.2012-04-06.log
> No debug messages, no slow query's.
> Configuration below

Maybe you have really fast queries?

I believe if you set "threshold=-1", it should log all queries.  Not something you'd want
to do in production, but it might help to further troubleshoot the issue.

Dan


> 
> -----------------------------------------------------------
> 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


Mime
View raw message