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