Re: SlowQueryReport

2013-06-06 Thread Daniel Mikusa
On Jun 6, 2013, at 4:04 AM, Lutischán Ferenc wrote: > Dear Daniel, Please don't top post. It makes it hard to follow the conversation. Either post your response inline, like I have been doing, or post below previous responses. > > Thanks. The slow query log works. :-) Good to hear! > >

Re: SlowQueryReport

2013-06-06 Thread Lutischán Ferenc
Dear Daniel, Thanks. The slow query log works. :-) The code doesn't work. It called from a cron4j under Tomcat: public class SchedulerServletContextListener implements ServletContextListener { private static final String SCHEDULER = "cron4j.scheduler"; @Override public void con

Re: SlowQueryReport

2013-06-05 Thread Daniel Mikusa
On Jun 5, 2013, at 4:10 AM, Lutischán Ferenc wrote: > Dear Daniel, > > Thanks for your reply. > My Tomcat version is 7.0.35. It is under CentOS 5.8. > > My datasource config is: > driverClassName="org.postgresql.Driver" > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="1"

Re: SlowQueryReport

2013-06-05 Thread Lutischán Ferenc
Dear Daniel, Thanks for your reply. My Tomcat version is 7.0.35. It is under CentOS 5.8. My datasource config is: driverClassName="org.postgresql.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="1" maxIdle="20" maxActive="20" maxWait="5000" password="xxx" type="jav

Re: SlowQueryReport

2013-06-04 Thread Daniel Mikusa
On Jun 4, 2013, at 6:26 AM, Lutischán Ferenc wrote: > Dear Users, > > Please help to me: > How to get SlowQueryReport statistics? Usually these are logged as WARN messages. Unless you use SlowQueryReportJmx and then they are logged and sent as JMX notifications. > > I tried: > > Map map =