tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Dymikha <v.dymi...@msk.teztour.com>
Subject Where can I find slow query log produced by tomcat-jdbc?
Date Fri, 06 Apr 2012 13:18:59 GMT
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


Mime
View raw message