You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-user@logging.apache.org by James Stauffer <js...@spscommerce.com> on 2004/08/13 22:18:42 UTC

Marking Database logs

I find it very useful to mark Database logs so I can see how they have been
processed.  What do you think of adding a column to logging_event for that
purpose?  Of course there is nothing to prevent it from being added but it
might be good to encourage it.

FYI my marking scheme is as follows.
-1: Default/Unprocessed
-2: Ignore (Something normal, not important, etc)
-3: Coded (Code changed in a future build that will either improve or
remove)

I then have an SQL statement that sets that flag based on the
rendered_message or trace_line.
I can provide more details if desire.  This allows me to easily find the
most common types of logs that I need to research next.  BTW our app
generates about 1,500 logs/day so maybe that is a lot and this wouldn't be
very useful to most people.

James Stauffer