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>
You need to be a member of Stax Developer Community to add comments!
Join Stax Developer Community