log4j.rootLogger=error, A2,ccfile,DATABASE
log4j.appender.A2=org.apache.log4j.ConsoleAppender
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=%d [%t] %-5p %c - %m%n
#for file
log4j.appender.ccfile.layout=org.apache.log4j.PatternLayout
log4j.appender.ccfile.layout.ConversionPattern=%d [%t] %-5p %c - %m%n
log4j.appender.ccfile=org.apache.log4j.RollingFileAppender
log4j.appender.ccfile.File=ccexample.log
log4j.appender.ccfile.MaxFileSize=10000KB
log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
#log4j.appender.DATABASE.BufferSize=10
log4j.appender.DATABASE.URL=jdbc:oracle:thin:@127.0.0.1:1521:orcl2
log4j.appender.DATABASE.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.DATABASE.user=qp
log4j.appender.DATABASE.password=qp
log4j.appender.DATABASE.sql=INSERT INTO tbl_log VALUES ('%m')
log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
#log4j.category.cn.javass.crm=error
#log4j.category.cn.javass.wf=debug