log4j配置-oracle

 1，oracle 中建表语句

   create table "SYSTEM"."T_LOG4J"(
        "CREATEDATE" VARCHAR2(200) not null,
       "THREAD" VARCHAR2(200),
       "LEVER" VARCHAR2(200),
       "CLASS" VARCHAR2(200),
       "MESSAGE" VARCHAR2(1500),
        constraint "SYS_C009492" primary key ("CREATEDATE")
    );

 

2，log4j.priperty文件

log4j.rootLogger=error, A1 ,R, B1
#RollingFileAppender
log4j.appender.A1=org.apache.log4j.RollingFileAppender
log4j.appender.A1.File=c:sys.log
log4j.appender.A1.MaxFileSize=100KB
log4j.appender.A1.MaxBackupIndex=1
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] %m%n
#backup
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=log4j.log
log4j.appender.R.MaxFileSize=100KB
log4j.appender.R.MaxBackupIndex=1
log4j.appender.R.layout=org.apache.log4j.TTCCLayout

#ConsoleAppender
log4j.appender.B1=org.apache.log4j.ConsoleAppender
log4j.appender.B1.layout=org.apache.log4j.PatternLayout
log4j.appender.B1.layout.ConversionPattern=%-4r %-5p [%t] %37c %3x - %m%n
log4j.appender.B1.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n

#Database oracle
log4j.appender.JDBC.Threshold=INFO    
log4j.appender.JDBC=org.apache.log4j.jdbc.JDBCAppender     
log4j.appender.JDBC.driver=oracle.jdbc.driver.OracleDriver    
log4j.appender.JDBC.URL=jdbc:oracle:thin:@192.168.1.43:1521:Grady
log4j.appender.JDBC.user=system
log4j.appender.JDBC.password=grady    
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout    
log4j.appender.JDBC.sql=INSERT INTO t_log4j(createdate,thread,lever,class,MESSAGE)VALUES('%d{yyyy-MM-dd HH:mm:ss}','%t','%p','%c','%m')