----- 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: [email protected]
> For additional commands, e-mail: [email protected]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
