search

lesteryu / log4jdbc

Automatically exported from code.google.com/p/log4jdbc
0 stars 0 forks source link

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

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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 rust.b...@gmail.com on 6 Aug 2012 at 8:28

GoogleCodeExporter commented 9 years ago 
I get the same problem

Original comment by szre...@gmail.com on 17 Apr 2014 at 5:03

GoogleCodeExporter commented 9 years ago 
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 arthur.b...@gmail.com on 17 Apr 2014 at 10:27