----- 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-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org