log4j.xml写入数据库，只有SQL和参数，无其他信息

2024-04-05 07:13:11

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

<appender name="debug-out" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${openfireHome}/logs/debug.log" />
       <param name="MaxFileSize" value="1024KB"/>
       <param name="MaxBackupIndex" value="5"/>
       <layout class="org.apache.log4j.PatternLayout">
           <param name="ConversionPattern" value="%d{yyyy.MM.dd HH:mm:ss} %c - %m%n" />
       </layout>
       <filter class="org.apache.log4j.varia.LevelRangeFilter">
           <param name="LevelMax" value="debug" />
           <param name="AcceptOnMatch" value="true" />
       </filter>
   </appender>

<appender name="info-out" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${openfireHome}/logs/info.log" />
       <param name="MaxFileSize" value="1024KB"/>
       <param name="MaxBackupIndex" value="5"/>
       <layout class="org.apache.log4j.PatternLayout">
           <param name="ConversionPattern" value="%d{yyyy.MM.dd HH:mm:ss} %c - %m%n" />
       </layout>
       <filter class="org.apache.log4j.varia.LevelRangeFilter">
           <param name="LevelMax" value="info" />
           <param name="LevelMin" value="info" />
           <param name="AcceptOnMatch" value="true" />
       </filter>
   </appender>

<appender name="warn-out" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${openfireHome}/logs/warn.log" />
       <param name="MaxFileSize" value="1024KB"/>
       <param name="MaxBackupIndex" value="5"/>
       <layout class="org.apache.log4j.PatternLayout">
           <param name="ConversionPattern" value="%d{yyyy.MM.dd HH:mm:ss} %c - %m%n" />
       </layout>
       <filter class="org.apache.log4j.varia.LevelRangeFilter">
           <param name="LevelMax" value="warn" />
           <param name="LevelMin" value="warn" />
           <param name="AcceptOnMatch" value="true" />
       </filter>
   </appender>

   <appender name="error-out" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${openfireHome}/logs/error.log" />
       <param name="MaxFileSize" value="1024KB"/>
       <param name="MaxBackupIndex" value="5"/>
       <layout class="org.apache.log4j.PatternLayout">
           <param name="ConversionPattern" value="%d{yyyy.MM.dd HH:mm:ss} %c - %m%n" />
       </layout>
       <filter class="org.apache.log4j.varia.LevelRangeFilter">
           <param name="LevelMin" value="error" />
           <param name="AcceptOnMatch" value="true" />
       </filter>
   </appender>

   <appender name="mylogger-out" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${openfireHome}/logs/mylogger.log" />
       <param name="MaxFileSize" value="1024KB"/>
       <param name="MaxBackupIndex" value="5"/>
       <layout class="org.apache.log4j.PatternLayout">
           <param name="ConversionPattern" value="%d{yyyy.MM.dd HH:mm:ss} %c - %m%n" />
       </layout>
       <filter class="org.apache.log4j.varia.LevelRangeFilter">
           <param name="LevelMin" value="debug" />
           <param name="AcceptOnMatch" value="true" />
       </filter>
   </appender>

   <appender name="myDBlogger-out" class="org.apache.log4j.jdbc.JDBCAppender">
       <param name="URL" value="jdbc:mysql://192.168.10.207:3307/openfire" />
       <param name="Driver" value="com.mysql.jdbc.Driver"/>
       <param name="User" value="dx"/>
       <param name="Password" value="dxdxdx"/>
       <param name="Sql" value="INSERT INTO `openfire`.`ofLog` (`createDate`, `logContent`, `logLevel`, `logClass`) VALUES ('%d{yyyy-MM-dd HH:mm:ss}', '%m', '%p', '%c')"/>
   </appender>
   <logger name="MyLogger" additivity="false">
       <level value="debug" />
       <appender-ref ref="mylogger-out" />
   </logger>

   <logger name="MyDBLogger" additivity="false">
       <level value="debug" />
       <appender-ref ref="myDBlogger-out" />
   </logger>
    <root>
       <level value="debug" />
       <appender-ref ref="debug-out" />
       <appender-ref ref="info-out" />
       <appender-ref ref="warn-out" />
       <appender-ref ref="error-out" />
   </root>
</log4j:configuration>

最新文章

热门文章