log4j记录日志到sqlserver数据库

log4j.properties配置

# JDBC Appender 
log4j.rootLogger=DEBUG,DB
log4j.appender.database=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.database.BufferSize=10
log4j.appender.DB=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DB.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
log4j.appender.DB.URL=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=TR
log4j.appender.DB.user=sa
log4j.appender.DB.password=sa
log4j.appender.DB.sql=insert into DBlog (Class,Mothod,CreateTime,LogLevel,MSG) values ('%C','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m')
log4j.appender.DB.layout=org.apache.log4j.PatternLayout