Re: SlowQueryReport

2013-06-06 Thread Daniel Mikusa
letContextEvent event) { > >ServletContext context = event.getServletContext(); > >Scheduler scheduler = new Scheduler(); > >Task slowQueryReport = new SlowQueryReport(); > >try { > >i

Re: SlowQueryReport

2013-06-06 Thread Lutischán Ferenc
public void contextInitialized(ServletContextEvent event) { ServletContext context = event.getServletContext(); Scheduler scheduler = new Scheduler(); Task slowQueryReport = new SlowQueryReport(); try { if (Tools.isTest()) { schedu

Re: SlowQueryReport

2013-06-05 Thread Daniel Mikusa
ry="select 1" > jdbcInterceptors="ConnectionState;SlowQueryReportJmx(threshold=1000)" > testOnBorrow="true"/> > > There is my java code: >Map map = > SlowQueryReportJmx.getPoolStats("java:comp/env/jdbc/" + poolName); And

Re: SlowQueryReport

2013-06-05 Thread Lutischán Ferenc
; testOnBorrow="true"/> There is my java code: Map map = SlowQueryReportJmx.getPoolStats("java:comp/env/jdbc/" + poolName); I tried the config with jdbcInterceptors="ConnectionState;SlowQueryReport(threshold=1000)", but there is no messages in the Tomca

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 t

SlowQueryReport

2013-06-04 Thread Lutischán Ferenc
Dear Users, Please help to me: How to get SlowQueryReport statistics? I tried: Map map = SlowQueryReport.getPoolStats("java:comp/env/jdbc/xxx"); and Map map = SlowQueryReport.getPoolStats("xxx"); The result in both case was a null map. T

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-10 Thread Michael-O
-O wrote: I recently have started using the SlowQueryReport to tackle performance issues. The log message, unfortunately, does not contain the parameters passed to the prepared statements. Though AbstractQueryReport receives this information in protected String report*Query(String query, Object

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Nick Williams
rote: >>>>> >>>>>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 >>>>>> >>>>>> Michael, >>>>>> >>>>>> On 5/8/13 3:01 AM, Michael-O wrote: >>>>>>> I rec

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Christopher Schultz
M, Michael-O wrote: >>> I recently have started using the SlowQueryReport to tackle >>> performance issues. The log message, unfortunately, does not >>> contain the parameters passed to the prepared statements. >>> Though AbstractQueryReport receives this inform

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Christopher Schultz
;>> Nick, >>> >>> On 5/8/13 8:08 AM, Nick Williams wrote: >>>> >>>> On May 8, 2013, at 6:54 AM, Christopher Schultz wrote: >>>> >>>>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 >>>>> >>>

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Nick Williams
6:54 AM, Christopher Schultz wrote: >>> >>>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 >>>> >>>> Michael, >>>> >>>> On 5/8/13 3:01 AM, Michael-O wrote: >>>>> I recently have started using the SlowQueryRepor

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Michael-O
Christopher, Am 2013-05-08 13:54, schrieb Christopher Schultz: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Michael, On 5/8/13 3:01 AM, Michael-O wrote: I recently have started using the SlowQueryReport to tackle performance issues. The log message, unfortunately, does not contain the

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Michael-O
wrote: I recently have started using the SlowQueryReport to tackle performance issues. The log message, unfortunately, does not contain the parameters passed to the prepared statements. Though AbstractQueryReport receives this information in protected String report*Query(String query, Object[] args

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Michael-O
Am 2013-05-08 14:08, schrieb Nick Williams: On May 8, 2013, at 6:54 AM, Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Michael, On 5/8/13 3:01 AM, Michael-O wrote: I recently have started using the SlowQueryReport to tackle performance issues. The log message

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Christopher Schultz
el-O wrote: >>> I recently have started using the SlowQueryReport to tackle >>> performance issues. The log message, unfortunately, does not >>> contain the parameters passed to the prepared statements. >>> Though AbstractQueryReport receives this inform

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Nick Williams
On May 8, 2013, at 6:54 AM, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Michael, > > On 5/8/13 3:01 AM, Michael-O wrote: >> I recently have started using the SlowQueryReport to tackle >> performance issues. The log me

Re: Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Michael, On 5/8/13 3:01 AM, Michael-O wrote: > I recently have started using the SlowQueryReport to tackle > performance issues. The log message, unfortunately, does not > contain the parameters passed to the prepared statement

Print parameters in Tomcat JDBC Pool's SlowQueryReport

2013-05-08 Thread Michael-O
Hi, I recently have started using the SlowQueryReport to tackle performance issues. The log message, unfortunately, does not contain the parameters passed to the prepared statements. Though AbstractQueryReport receives this information in protected String report*Query(String query, Object