Stax Developer Community

Developer Community

DOWNLOAD (Apache License 2.0)
> staxlogger.jar
> StaxLogger-src.zip


----I studing English now, So my English is very poor, sorry----

JDBCAppender contains log4j. This appender is log write to DB, however it can't logging all stacktraces.
Therefore, to logging all stacktraces, I have enhanced log4j.

1. copy staxlogger.jar & log4j-1.2.15.jar to [/webapp/WEB-INF/lib].
2. create DB table.
3. add appender to log4j.xml.

Enjoy try it!!!

CREATE TABLE logtable (
date varchar(50),
priority varchar(8),
logger varchar(100),
line varchar(6),
message longblob
);

<appender name="JDBC" class="org.apache.log4j.jdbc.JDBCAppender">
<param name="URL" value="jdbc:stax://xxxxx" />
<param name="user" value="USERNAME" />
<param name="password" value="PASSWORD" />
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="bufferSize" value="1" />
<layout class="com.daisukeyamashita.log4j.StaxPatternLayout">
<param name="ConversionPattern" value="INSERT INTO logtable (DATE, PRIORITY,
LOGGER, LINE, MESSAGE) VALUES ('%d', '%p', '%c#%M', '%L', '%m');" />
</layout>
</appender>

Views: 4

Comment

You need to be a member of Stax Developer Community to add comments!

Join Stax Developer Community

Spike Washburn Comment by Spike Washburn on March 29, 2009 at 9:58am
This is great! Thanks for the contribution.

Quick Links

Send Feedback

If you have any questions or feedback about Stax, please drop us a note.

© 2012   Created by Spike Washburn.

Badges  |  Report an Issue  |  Terms of Service