dubbo-provider jar包:
sqlmap-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 全局参数 -->
<settings>
<!-- 设置但JDBC类型为空时,某些驱动程序 要指定值,default:OTHER,插入空值时不需要指定类型 -->
<setting name="jdbcTypeForNull" value="NULL"/>
<!-- 打印查询语句 : 打开时控制台有输出,但是logback sqlAsyncAppender 将无输出-->
<!--<setting name="logImpl" value="STDOUT_LOGGING" />-->
<!-- 控制打印mybatis日志输出到指定文件 -->
<setting name="logPrefix" value="mapper."/>
</settings>
<typeAliases>
<typeAlias alias="hashMap" type="java.util.HashMap"/>
</typeAliases>
</configuration>
logback-Config.xml
<included>
<property name="baseLogFilePath" value="./logs" />
<!-- log level config -->
<property name="qifuLevel" value="INFO" />
<property name="mybatisLevel" value="INFO" />
<property name="frameworkLevel" value="INFO" />
<property name="javaSql" value="INFO" />
<property name="defaultLevel" value="INFO" />
</included>
logback.xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="true">
<include resource="logbackConfig.xml"/>
<contextName>crm-provider-pms</contextName>
<!-- console appender定义 -->
<appender name="consoleAppender" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<charset>UTF-8</charset>
<pattern>[%d{yyyy-MM-dd HH:mm:ss.SSS} %5p %c:%L] [%thread] %m%n</pattern>
</encoder>
</appender>
<!-- info日志 -->
<appender name="dubboInfoAppender"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>${baseLogFilePath}/crm-provider-pms-info.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<FileNamePattern>${baseLogFilePath}/crm-provider-pms-info.log.%d{yyyy-MM-dd}
</FileNamePattern>
<maxHistory>30</maxHistory>
</rollingPolicy>
<encoder>
<charset>UTF-8</charset>
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{68} %line - %msg%n</Pattern>
</encoder>
<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
<level>DEBUG</level>
</filter>
</appender>
<!-- error日志 -->
<appender name="dubboErrorAppender"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>${baseLogFilePath}/crm-provider-pms-info.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<FileNamePattern>${baseLogFilePath}/crm-provider-pms-info.log.%d{yyyy-MM-dd}
</FileNamePattern>
<maxHistory>30</maxHistory>
</rollingPolicy>
<encoder>
<charset>UTF-8</charset>
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{68} %line - %msg%n</Pattern>
</encoder>
<filter class="ch.qos.logback.classic.filter.LevelFilter">
<level>ERROR</level>
<onMatch>ACCEPT</onMatch>
<onMismatch>DENY</onMismatch>
</filter>
</appender>
<appender name="dubboAsyncInfoAppender" class="ch.qos.logback.classic.AsyncAppender">
<!-- 丢失日志.默认的,如果队列的80%已满,则会丢弃TRACT、DEBUG、INFO级别的日志 -->
<discardingThreshold>0</discardingThreshold>
<!-- 更改默认的队列的深度,该值会影响性能.默认值为256 -->
<queueSize>128</queueSize>
<includeCallerData>true</includeCallerData>
<appender-ref ref="dubboInfoAppender"/>
<appender-ref ref="dubboErrorAppender"/>
</appender>
<!-- sql 语句输出 -->
<appender name="sqlAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>${baseLogFilePath}/crm-provider-pms-sql.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<fileNamePattern>${baseLogFilePath}/crm-provider-pms-sql.log.%d{yyyy-MM-dd-HH}
</fileNamePattern>
<maxHistory>100</maxHistory>
</rollingPolicy>
<encoder>
<charset>UTF-8</charset>
<pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} %line - %msg%n
</pattern>
</encoder>
<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
<level>DEBUG</level>
</filter>
</appender>
<!-- file asynch appender -->
<appender name="sqlAsyncAppender" class="ch.qos.logback.classic.AsyncAppender">
<!-- 不丢失日志.默认的,如果队列的80%已满,则会丢弃TRACT、DEBUG、INFO级别的日志 -->
<discardingThreshold>0</discardingThreshold>
<!-- 更改默认的队列的深度,该值会影响性能.默认值为256 -->
<queueSize>124</queueSize>
<appender-ref ref="sqlAppender"/>
</appender>
<logger name="com.qf58.crm" level="${qifuLevel}" additivity="true">
<appender-ref ref="dubboAsyncInfoAppender"/>
</logger>
<logger name="org.mybatis.spring" level="${mybatisLevel}" additivity="true"/>
<logger name="com.alibaba.dubbo" level="INFO" additivity="true"/>
<logger name="org.springframework" level="${frameworkLevel}" additivity="true"/>
<logger name="org.apache" level="INFO" additivity="true"/>
<!-- mybatis log config -->
<logger name="org.apache.ibatis" level="${mybatisLevel}" additivity="true" />
<!-- sql log config -->
<logger name="mapper" level="DEBUG" additivity="true">
<appender-ref ref="sqlAsyncAppender"/>
</logger>
<logger name="java.sql.Connection" level="${javaSql}" additivity="true"/>
<logger name="java.sql.Statement" level="${javaSql}" additivity="true"/>
<logger name="java.sql.PreparedStatement" level="${javaSql}" additivity="true"/>
<root level="${defaultLevel}">
<appender-ref ref="consoleAppender"/>
</root>
</configuration>
dubbo-consumer war包:
logbackConfig.xml
<included>
<property name="baseLogFilePath" value="${catalina.base:-.}/logs" />
<!-- log level config -->
<property name="qifuLevel" value="INFO" />
<property name="cacheLevel" value="INFO" />
<property name="frameworkLevel" value="INFO" />
<property name="apacheLevel" value="DEBUG" />
</included>
logback.xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="true">
<include resource="logbackConfig.xml"/>
<contextName>crm-web-pms</contextName>
<!-- console appender定义 -->
<appender name="consoleAppender" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<charset>UTF-8</charset>
<pattern>[%d{yyyy-MM-dd HH:mm:ss.SSS} %5p %c:%L] [%thread] %m%n</pattern>
</encoder>
</appender>
<!-- error日志 -->
<appender name="sysWarnAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>${baseLogFilePath}/sys_error.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<FileNamePattern>${baseLogFilePath}/sys_error.log.%d{yyyy-MM-dd}
</FileNamePattern>
<maxHistory>90</maxHistory>
</rollingPolicy>
<encoder>
<charset>UTF-8</charset>
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{68} %line - %msg%n
</Pattern>
</encoder>
<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
<level>WARN</level>
</filter>
</appender>
<!-- file asynch appender -->
<appender name="sysAsyncWarnAppender" class="ch.qos.logback.classic.AsyncAppender">
<!-- 不丢失日志.默认的,如果队列的80%已满,则会丢弃TRACT、DEBUG、INFO级别的日志 -->
<discardingThreshold >0</discardingThreshold>
<!-- 更改默认的队列的深度,该值会影响性能.默认值为256 -->
<queueSize>512</queueSize>
<includeCallerData>true</includeCallerData>
<appender-ref ref="sysWarnAppender"/>
</appender>
<!-- 错误日志记录定义 -->
<appender name="errorAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>${baseLogFilePath}/crm-web-pms_error.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<fileNamePattern>${baseLogFilePath}/crm-web-pms_error.log.%d{yyyy-MM-dd-HH}
</fileNamePattern>
<maxHistory>30</maxHistory>
</rollingPolicy>
<encoder>
<charset>UTF-8</charset>
<pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} %line - %msg%n</pattern>
</encoder>
<filter class="ch.qos.logback.classic.filter.LevelFilter">
<level>ERROR</level>
<onMatch>ACCEPT</onMatch>
<onMismatch>DENY</onMismatch>
</filter>
</appender>
<appender name="fileAsyncErrAppender" class="ch.qos.logback.classic.AsyncAppender">
<!-- 不丢失日志.默认的,如果队列的80%已满,则会丢弃TRACT、DEBUG、INFO级别的日志 -->
<discardingThreshold >0</discardingThreshold>
<!-- 更改默认的队列的深度,该值会影响性能.默认值为256 -->
<queueSize>128</queueSize>
<includeCallerData>true</includeCallerData>
<appender-ref ref="errorAppender"/>
</appender>
<logger name="org.springframework" level="${frameworkLevel}" additivity="true"/>
<!-- mybatis log config -->
<logger name="org.apache" level="${apacheLevel}" additivity="true"/>
<!-- 错误日志记录文件 -->
<logger name="com.qf58.crm" level="${qifuLevel}" additivity="true">
<appender-ref ref="fileAsyncErrAppender"/>
</logger>
<root level="DEBUG">
<appender-ref ref="consoleAppender"/>
<appender-ref ref="sysAsyncWarnAppender"/>
</root>
</configuration>