log_home=./infoLogs
log4j.rootCategory=ERROR,console
log4j.logger.LOG= INFO,LOG
log4j.logger.YY= INFO,YY
log4j.logger.BASIC= INFO,BASIC
log4j.logger.JOB= INFO,JOB
log4j.logger.ORDER= INFO,ORDER
log4j.logger.MSG= INFO,MSG
log4j.logger.REPORTFROMS= INFO,REPORTFROMS
log4j.logger.SURVEY= INFO,ERROR,SURVEY
#stdout
log4j.appender.console=org.apache.log4j.ConsoleAppender 
log4j.appender.console.Threshold=ERROR 
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss}[System]%m%n


log4j.appender.JOB.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.JOB.layout=org.apache.log4j.PatternLayout
log4j.appender.JOB.File=${log_home}/logs/job
log4j.appender.JOB.DatePattern=yyyy-MM-dd'.log'
log4j.appender.JOB=org.apache.log4j.DailyRollingFileAppender


#log4j.appender.YY.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss}$%l$%m%n
log4j.appender.YY.layout=org.apache.log4j.PatternLayout
log4j.appender.YY.File=${log_home}/logs/YYGH
log4j.appender.YY.DatePattern=yyyy-MM-dd'.log'
log4j.appender.YY.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.YY=org.apache.log4j.DailyRollingFileAppender

log4j.appender.BASIC.layout=org.apache.log4j.PatternLayout
log4j.appender.BASIC.File=${log_home}/logs/BASIC
log4j.appender.BASIC.DatePattern=yyyy-MM-dd'.log'
log4j.appender.BASIC.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.BASIC=org.apache.log4j.DailyRollingFileAppender

log4j.appender.LOG.layout=org.apache.log4j.PatternLayout
log4j.appender.LOG.File=${log_home}/logs/LOG
log4j.appender.LOG.DatePattern=yyyy-MM-dd'.log'
log4j.appender.LOG.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.LOG=org.apache.log4j.DailyRollingFileAppender

log4j.appender.ORDER.layout=org.apache.log4j.PatternLayout
log4j.appender.ORDER.File=${log_home}/logs/ORDER
log4j.appender.ORDER.DatePattern=yyyy-MM-dd'.log'
log4j.appender.ORDER.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.ORDER=org.apache.log4j.DailyRollingFileAppender

log4j.appender.MSG.layout=org.apache.log4j.PatternLayout
log4j.appender.MSG.File=${log_home}/logs/MSG
log4j.appender.MSG.DatePattern=yyyy-MM-dd'.log'
log4j.appender.MSG.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.MSG=org.apache.log4j.DailyRollingFileAppender

log4j.appender.REPORTFROMS.layout=org.apache.log4j.PatternLayout
log4j.appender.REPORTFROMS.File=${log_home}/logs/REPORTFROMS
log4j.appender.REPORTFROMS.DatePattern=yyyy-MM-dd'.log'
log4j.appender.REPORTFROMS.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.REPORTFROMS=org.apache.log4j.DailyRollingFileAppender

log4j.appender.SURVEY.layout.ConversionPattern=[%-p] %d{yyyy-MM-dd HH:mm:ss} >> [%t] %l: %m %x %n
log4j.appender.SURVEY.layout=org.apache.log4j.PatternLayout
log4j.appender.SURVEY.File=${log_home}/logs/SURVEY
log4j.appender.SURVEY.DatePattern=yyyy-MM-dd'.log'
log4j.appender.SURVEY=org.apache.log4j.DailyRollingFileAppender

#log4j.logger.business=INFO,db
log4j.appender.db=org.apache.log4j.jdbc.JDBCAppender 
#log4j.appender.db=JDBCExtAppender
log4j.appender.db.Threshold=INFO 
log4j.appender.db.BufferSize=1
#log4j.appender.db.sqlname=log
#log4j.appender.db.driver=net.sourceforge.jtds.jdbc.Driver
#log4j.appender.db.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.db.driver=com.mysql.jdbc.Driver
#log4j.appender.db.URL=jdbc:oracle:thin:@172.18.20.152:1521:basic
log4j.appender.db.URL=jdbc:mysql://172.18.20.111:3306/hos
#log4j.appender.db.URL=jdbc:jtds:SqlServer://172.18.20.21:1433;DatabaseName=HOS
log4j.appender.db.user=hos
log4j.appender.db.password=jkzl123456
#log4j.appender.db.sql=insert into sys_log4j_log (id,LogName,UserName,Class,Method,createTime,LogLevel,MSG,LOGGUID,ORDERID) values (sys_guid(),'%X{LogName}','%X{UserName}','%l','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m','%X{LOGGUID}','%X{Orderid}')
log4j.appender.db.sql=insert into SYS_LOG4J_LOG (id,LogName,UserName,Class,Method,createTime,LogLevel,MSG,LOGGUID,ORDERID) values (REPLACE(UUID(),'-','') ,'%X{LogName}','%X{UserName}','%l','%M','%d{%Y-%m-%d %H:%i:%s}','%p','%m','%X{LOGGUID}','%X{Orderid}')
log4j.appender.db.layout=org.apache.log4j.PatternLayout