我的Log4j 日志写入数据库配置

最新推荐文章于 2021-04-04 05:27:43 发布

原创最新推荐文章于 2021-04-04 05:27:43 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#log4j #数据库 #postgresql #jboss #insert #database

本文介绍如何在项目中配置Log4j日志记录工具，包括设置日志级别、控制台输出、文件滚动策略及数据库日志存储等内容。通过详细配置项说明，帮助开发者快速上手Log4j。

文件名log4j.properties 存放在项目的WEB-INF/classes里面
# For JBoss: Avoid to setup Log4J outside $JBOSS_HOME/server/default/deploy/log4j.xml!
# For all other servers: Comment out the Log4J listener in web.xml to activate Log4J.
#log4j.rootLogger=INFO, stdout, logfile ,DATABASE
log4j.rootLogger=INFO, stdout, logfile
log4j.addivity.org.apache=true
log4j.appender.DATABASE.Threshold=INFO
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - <%m>%n
log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=c:/srs.log
log4j.appender.logfile.MaxFileSize=512KB
log4j.appender.logfile.MaxBackupIndex=3
Pattern to output: date priority [category] - message
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n
#========================================================================================
#log4j.appender.DATABASE.BufferSize=10
#log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
#log4j.appender.DATABASE.URL=jdbc:postgresql://192.168.0.20:5432/small_rs
#log4j.appender.DATABASE.driver=org.postgresql.Driver
#log4j.appender.DATABASE.user=postgres
#log4j.appender.DATABASE.password= postgres
#log4j.appender.DATABASE.sql=INSERT INTO com_log VALUES ('12','%d{yyyy-MM-dd HH:mm:ss}', '123', '123','%p','%m','0','0',%d{yyyy-MM-dd})
#log4j.appender.DATABASE.sql=INSERT INTO com_log VALUES ('12','%d{yyyy-MM-dd HH:mm:ss}', '123', '123','%p','%m','1','0','%d{yyyy-MM-dd}')
#log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
# Keep three backup files.