log4j日誌寫入資料庫

log4j.rootLogger=jdbc ,stdout,file

將日誌寫入資料庫

log4j.appender.jdbc.layout=org.apache.log4j.PatternLayout
log4j.logger.org.springframework=ERROR 
log4j.appender.jdbc=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.jdbc.driver=net.sourceforge.jtds.jdbc.Driver
log4j.appender.jdbc.URL=jdbc\:jtds\:sqlserver\://127.0.0.1\:1433;DatabaseName\=dqaudit
log4j.appender.jdbc.user=sa
log4j.appender.jdbc.password=123

log4j.appender.jdbc.sql=INSERT INTO log(username,Lg_Date,Lg_Thread,Lg_Level,Lg_Class,Lg_Message) VALUES ('%X{username}','%d{yyyy-MM-dd HH:mm:ss}', '%t', '%p', '%l', '%m')

log4j.appender.stdout= org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.err
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern = [%d{yyyy-MM-dd HH/:mm/:ss}]%-5p %c(line/:%L) %x-%m%n

# Output to the File輸入到檔案
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=../logs/dqaudit.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%n%-d{yyyy-MM-dd HH\:mm\:ss}%n[%p]-[Thread\: %t]-[%C.%M()]\: %m%n