Allow filtering of jdbc.sqlonly statements (i.e., "select 1")

[GoogleCodeExporter]

What steps will reproduce the problem?
1. use a connection pool and configure a validationQuery (e.g., "select 1")
2. turn on jdbc.sqlonly logging
3. start a webapp (or long lived application).  Upon use of the application (in 
our case, scheduled jobs every minute), I just get a fairly large overhead of 
duplicate (or at least useless) "select 1" output lines.

What is the expected output? What do you see instead?

I would like to see all sql statements but ignore "select 1"


What version of the product are you using? On what operating system?
1.2.   Linux OS.


Please provide any additional information below.

Original issue reported on code.google.com by [email protected] on 6 Aug 2012 at 8:28

[GoogleCodeExporter]

I get the same problem

Original comment by [email protected] on 17 Apr 2014 at 5:03

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

This is not a bug. It's showing the actual SQL coming from the application.
I understand that it's just noise that you want to filter out.
Good idea. although I'm not sure of a simple way to implement it.

Original comment by [email protected] on 17 Apr 2014 at 10:27

• Added labels: Priority-Low, Type-Enhancement
• Removed labels: Priority-Medium, Type-Defect