Logging (level) configuration per package/class where the statement was executed

[zerat...@gmail.com]

Hi guys,

we are currently using log4jdbc and and are looking for JDBC logger that would enable fine-grained configuration of logging per package/class. Simply enabling/disabling inserts, updates etc. is not enough for us as we want to log some inserts and updates while not the others.

Is this is somehow achievable in p6spy? Basically we are looking for something like logback/log4j configuration block of loggers where you turn them on/off/change logging level on package or class basis from whence the statement was executed.

From reading the http://p6spy.github.io/p6spy/2.0/configandusage.html I'm not sure if this possible, the closest part to this was at the end of the appender section.

Thanks in the advance.

Regards,

Marek

[Quinton McCombs]

The closest that you can get currently is the logging of statements based on keywords found or not found in the SQL.  For example, you could restrict logging to only certain tables, views, stored procs, etc,  See the section titled 'filter, include, exclude' at http://p6spy.github.io/p6spy/2.0/configandusage.html for more details.  BTW - You can get more fine grain control by configuring a regular expression as well (see the next section below that one).

--
You received this message because you are subscribed to the Google Groups "p6spy users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to p6spy-users...@googlegroups.com.
To post to this group, send email to p6spy...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/p6spy-users/d707faf4-22e3-4f21-9ebf-471d1d99e844%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.