log4j 写入oracle,log4j各种输出配置

Log4j基本输出配置：log4j.rootLogger=DEBUG,CONSOLE,DATABASE,FILE,ROLLING_FILE,A1,SOCKET,MAIL

#log4j.logger.cn.com.baidu.dao=DEBUG,CONSOLE,FILE,ROLLING_FILE

#children-logger是否使用 rootLogger的配置

log4j.additivity.org.apache=false

# 应用于控制台

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

log4j.appender.CONSOLE.Target=System.out

log4j.appender.CONSOLE.encoding=utf-8

log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout

log4j.appender.CONSOLE.layout.ConversionPattern=[%-5p]%l - %m%n

#应用于文件

log4j.appender.FILE=org.apache.log4j.FileAppender

log4j.appender.FILE.File=E:/work/logs/OfflineMap.log

log4j.appender.FILE.Append=false

log4j.appender.FILE.encoding=utf-8

log4j.appender.FILE.layout=org.apache.log4j.PatternLayout

log4j.appender.FILE.layout.ConversionPattern=%d-%-4r [%t]%-5p%l %x- %m%n

# 应用于文件回滚

log4j.appender.ROLLING_FILE=org.apache.log4j.RollingFileAppender

log4j.appender.ROLLING_FILE.File=E:/work/logs/OfflineMap.r.log

log4j.appender.ROLLING_FILE.Threshold=INFO

log4j.appender.ROLLING_FILE.Append=true

log4j.appender.ROLLING_FILE.Encoding=utf-8

log4j.appender.ROLLING_FILE.MaxFileSize=10240KB

log4j.appender.ROLLING_FILE.MaxBackupIndex=10

log4j.appender.ROLLING_FILE.layout=org.apache.log4j.PatternLayout

log4j.appender.ROLLING_FILE.layout.ConversionPattern=[framework] %d - %c -%-4r[%t] %-5p %c %x - %m%n

# 每天新建日志

log4j.appender.A1=org.apache.log4j.DailyRollingFileAppender

log4j.appender.A1.File=/monitor/logs/logfile.log

log4j.appender.A1.Encoding=utf-8

log4j.appender.A1.Threshold=DEBUG

log4j.appender.A1.DatePattern='.'yyyy-MM-dd

log4j.appender.A1.layout=org.apache.log4j.PatternLayout

log4j.appender.A1.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L : %m%n

# 用于数据库

log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender

log4j.appender.DATABASE.URL=jdbc:oracle:thin:@192.168.1.23:1521:OraclTest

log4j.appender.DATABASE.driver=oracle.jdbc.driver.OracleDriver

log4j.appender.DATABASE.user=admin

log4j.appender.DATABASE.password=admin

log4j.appender.CONSOLE.Threshold=WARN

log4j.appender.DATABASE.sql=INSERT INTO

LOG4J(stamp,thread,infolevel,class,messages) VALUES ('%d{yyyy-MM-dd

HH:mm:ss}', '%t', '%p', '%l','%m')

# INSERT INTO LOG4J (Message) VALUES ('[framework] %d - %c -%-4r [%t] %-5p %c%x - %m%n')

# 写入数据库中的表LOG4J的Message字段中，内容％d(日期)%c:日志信息所在地(类名)%p:日志信息级别%m: 产生的日志具体信息 %n: 输出日志信息换行

log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout

log4j.appender.DATABASE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t]%-5p %c %x - %m%n

#应用于socket

log4j.appender.SOCKET=org.apache.log4j.RollingFileAppender

log4j.appender.SOCKET.RemoteHost=localhost

log4j.appender.SOCKET.Port=60001

log4j.appender.SOCKET.LocationInfo=true

log4j.appender.SOCKET.layout=org.apache.log4j.PatternLayout

log4j.appender.SOCKET.layout.ConversionPattern=[start]%d{DATE}[DATE]%n%p[PRIORITY]%n%x[NDC]%n%t[THREAD]%n%c[CATEGORY]%n%m[MESSAGE]%n%n

#发送日志给邮件

log4j.appender.MAIL=org.apache.log4j.net.SMTPAppender

log4j.appender.MAIL.Threshold=FATAL

log4j.appender.MAIL.BufferSize=10

log4j.appender.MAIL.From=web@www.baidu.com

log4j.appender.MAIL.SMTPHost=www.baidu.com

log4j.appender.MAIL.Subject=Log4J Message

log4j.appender.MAIL.To=web@www.baidu.com

log4j.appender.MAIL.layout=org.apache.log4j.PatternLayout

log4j.appender.MAIL.layout.ConversionPattern=[framework] %d - %c -%-4r [%t]%-5p %c %x - %m%n