properties文件如下写:
# 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.
绿色标记的部分就是插入数据库的代码。这个是连接postgre的例子,如果是其他数据库用相应的连接设置就可以了。
# 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.
绿色标记的部分就是插入数据库的代码。这个是连接postgre的例子,如果是其他数据库用相应的连接设置就可以了。