Ok, after upgrade to 7.0.27 I can see in catalina.out
May 16, 2012 6:29:13 PM org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport
reportSlowQuery
WARNING: Slow Query Report SQL=/* named HQL query HotelView.findPriceById */
select minspohote0_.HOTEL as HOTEL27_, minspohote0_.ID_CITY_DEP as ID2_27_,
minspohote0_.MIN_PRICE as MIN3_27_, minspohote0_.ID_CURRENCY as ID4_27_ from
erp.v_min_spo_hotel_prices_fast minspohote0_ where ( minspohote0_.RANK=1) and
minspohote0_.HOTEL=? and minspohote0_.ID_CITY_DEP=?; time=11 ms;
1. How can I get substitution for "?" values?
2. p:jdbcInterceptors="SlowQueryReport(threshold=10,maxQueries=10000)"
Is this correct syntax?
3. How can I turn this output to pool.2012-05-16.log file instead of
catalina.out?
-------------------------------------------------------
${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
-------------------------------------------------------
Looks like this settings totally ignored.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
