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