log4j使用（发邮件，写入不同表）

log4j.rootLogger=DEBUG,DB,DB2,CONSOLE,MAIL

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

log4j.appender.CONSOLE.Target=System.out
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%C - %m


log4j.appender.DB=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DB.Threshold=INFO
log4j.appender.DB.bufferSize =1
log4j.appender.DB.URL=jdbc:oracle:thin:@192.168.1.151:1521:ora11
log4j.appender.DB.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.DB.user=t**
log4j.appender.DB.password=**
log4j.appender.DB.sql=INSERT INTO LOG_4j (ClassName, LogValue) VALUES ('%C','%m')
log4j.appender.DB.layout=org.apache.log4j.PatternLayout

log4j.appender.DB2=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DB2.Threshold=error
log4j.appender.DB2.bufferSize =1
log4j.appender.DB2.URL=jdbc:oracle:thin:@192.168.1.151:1521:ora11
log4j.appender.DB2.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.DB2.user=**
log4j.appender.DB2.password=**
log4j.appender.DB2.sql=INSERT INTO LOG_4j2(ClassName, LogValue) VALUES ('%C','%m')
log4j.appender.DB2.layout=org.apache.log4j.PatternLayout

 log4j.appender.MAIL=org.apache.log4j.net.SMTPAppender
 log4j.appender.MAIL.Threshold=ERROR
 log4j.appender.MAIL.BufferSize=1
 log4j.appender.MAIL.To=**@163.com
 log4j.appender.MAIL.From=**@163.com
 log4j.appender.MAIL.SMTPUsername=**
 log4j.appender.MAIL.SMTPPassword=**
 log4j.appender.MAIL.Subject=ErrorLog
 log4j.appender.MAIL.SMTPHost=smtp.163.com
 log4j.appender.MAIL.layout=org.apache.log4j.PatternLayout
 log4j.appender.MAIL.layout.ConversionPattern=%C - %m