logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ceki Gülcü <...@qos.ch>
Subject Re: JDBCAppender update
Date Fri, 08 Jun 2001 07:27:45 GMT

Hi,

Is the new JDBCAppender available to the wider public? Ceki

At 09:12 05.06.2020 -0700, you wrote:
>I spent a lot of time yesterday updating my JDBCAppender.
>Looks like that was appropriate timing.
>
>The new version of my appender has bean-like get/set methods
>(plus the now deprecated setOption methods).
>Setting a database driver is a new option.
>
>Most valuably though I've made the sql setting much more
>powerful.  You can now use all the conversion patterns from
>PatternLayout within the configured statement to separate
>items into different columns and the like ie:
>
>log4j.appender.jdbc.sql=insert into logTable (message,
>class, priority, log_date) values ('%m', '%c', '%p', '%d')
>
>or
>
>log4j.appender.jdbc.sql=insert into logTable
>(class_and_message, priority) values ('%c %m', '%p')
>
>optionally you can explicitly attach a Layout and it's
>output from format(LoggingEvent) will replace any "%m" in
>your sql.  And as always it's easy to subclass and override
>for even more control.
>
>The JDBCAppender class, two example classes, and an example
>properties file are attached.
>I'll be putting up an additional web page about it all on my
>own server in a few days.  I'll let you know when that
>happens.
>
>Ceki, I tried to keep my indenting close to your standard
>this time.  I hope it helps.
>
>Kevin Steppe
>
>ps. I'm looking for work if anyone is hiring in the SF Bay
>Area.

--
Ceki Gülcü


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: log4j-user-help@jakarta.apache.org


Mime
View raw message