`

log4j指定输出源append、存入数据库并自定义参数

 
阅读更多

在log4j中可以指定特定的输出源append。在数据库记录日志时，可以将日志文件记录到多个数据库表中。

Java代码 复制代码 
  1. # This is the configuring for logging displayed in the Application Server   
  2. log4j.rootCategory=DEBUG,logfile,stdout   
  3.   
  4. log4j.logger.SYSTEM = INFO,JDBC   
  5. log4j.logger.OPERATION = INFO,JDBC2   
  6.   
  7. #stdout configure   
  8. log4j.appender.stdout=org.apache.log4j.ConsoleAppender   
  9. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout   
  10. log4j.appender.stdout.layout.ConversionPattern= %d %p [%c] - <%m>%n   
  11.   
  12. #logfile configure   
  13. log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender   
  14. log4j.appender.logfile.File=../logs/moca_stm_stm.log   
  15. log4j.appender.logfile.layout=org.apache.log4j.PatternLayout   
  16. log4j.appender.logfile.layout.ConversionPattern= %d{yyyy MM dd HH:mm:ss} %p [%c] - <%m>%n   
  17.   
  18. #JDBC configure   
  19. log4j.appender.JDBC.Threshold=INFO   
  20. log4j.appender.JDBC=org.apache.log4j.jdbc.JDBCAppender    
  21. log4j.appender.JDBC.driver=oracle.jdbc.driver.OracleDriver   
  22. log4j.appender.JDBC.URL=jdbc:oracle:thin:@192.168.140.13:1521:DMPT   
  23. log4j.appender.JDBC.user=moca_stm   
  24. log4j.appender.JDBC.password=moca_stm   
  25. log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout   
  26. log4j.appender.JDBC.sql=INSERT INTO XK_SYS_LOG(USERID,LOGTIME,LOGLEVEL,LOCATION,MESSAGE)VALUES('%X{userId}','%d{yyyy-MM-dd HH:mm:ss}','%p','%l','%m')   
  27.   
  28.   
  29. log4j.appender.JDBC2.Threshold=INFO   
  30. log4j.appender.JDBC2=org.apache.log4j.jdbc.JDBCAppender    
  31. log4j.appender.JDBC2.driver=oracle.jdbc.driver.OracleDriver   
  32. log4j.appender.JDBC2.URL=jdbc:oracle:thin:@192.168.140.13:1521:DMPT   
  33. log4j.appender.JDBC2.user=moca_stm   
  34. log4j.appender.JDBC2.password=moca_stm   
  35. log4j.appender.JDBC2.layout=org.apache.log4j.PatternLayout   
  36. log4j.appender.JDBC2.sql=INSERT INTO XK_SYS_LOG_2(USERID,LOGTIME,LOGLEVEL,LOCATION,MESSAGE)VALUES('%X{userId}','%d{yyyy-MM-dd HH:mm:ss}','%p','%l','%m')   
# This is the configuring for logging displayed in the Application Server
log4j.rootCategory=DEBUG,logfile,stdout

log4j.logger.SYSTEM = INFO,JDBC
log4j.logger.OPERATION = INFO,JDBC2

#stdout configure
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern= %d %p [%c] - <%m>%n

#logfile configure
log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.logfile.File=../logs/moca_stm_stm.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern= %d{yyyy MM dd HH:mm:ss} %p [%c] - <%m>%n

#JDBC configure
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.140.13:1521:DMPT
log4j.appender.JDBC.user=moca_stm
log4j.appender.JDBC.password=moca_stm
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC.sql=INSERT INTO XK_SYS_LOG(USERID,LOGTIME,LOGLEVEL,LOCATION,MESSAGE)VALUES('%X{userId}','%d{yyyy-MM-dd HH:mm:ss}','%p','%l','%m')


log4j.appender.JDBC2.Threshold=INFO
log4j.appender.JDBC2=org.apache.log4j.jdbc.JDBCAppender 
log4j.appender.JDBC2.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.JDBC2.URL=jdbc:oracle:thin:@192.168.140.13:1521:DMPT
log4j.appender.JDBC2.user=moca_stm
log4j.appender.JDBC2.password=moca_stm
log4j.appender.JDBC2.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC2.sql=INSERT INTO XK_SYS_LOG_2(USERID,LOGTIME,LOGLEVEL,LOCATION,MESSAGE)VALUES('%X{userId}','%d{yyyy-MM-dd HH:mm:ss}','%p','%l','%m')



测试类

Java代码 复制代码
  1. package test;   
  2.   
  3. import org.apache.log4j.Logger;   
  4. import org.apache.log4j.MDC;   
  5.   
  6. public class LogTest {   
  7.     private static Logger logger = Logger.getLogger("OPERATION");   
  8.     //private static Logger logger = Logger.getLogger("SYSTEM");   
  9.     //private static Logger logger = Logger.getLogger(LogTest.class);   
  10.     public static void main(String[] args) {   
  11.         MDC.put("userId", "用户ID");   
  12.         logger.error("testError");      
  13.     }   
  14. }  

http://hunray.iteye.com/blog/738173

分享到：
| 动态添加的表单action，只能提交一次
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics