現(xiàn)象
springboot+logback本地調(diào)試有sql日志,但是生產(chǎn)環(huán)境日志文件中沒(méi)有sql日志
解決
①注釋掉#mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
注釋掉就可以在生產(chǎn)打印sql日志,如果不注釋?zhuān)荒茉诳刂婆_(tái)打印sql
②主要是logback配置文件中
<logger name="com.keji.xiangmu" level="DEBUG"/>?
name原來(lái)是帶*號(hào)的盯捌,但是發(fā)現(xiàn)識(shí)別不了纤壁,打印不了日志轿亮,所以就具體到每一個(gè)dao的路徑空凸,或者寫(xiě)一個(gè)總路徑避矢,
完整的logback-spring.xml日志文件如下:
```
<configuration>
<property name="LOG_HOME" value="logs" />
<appender name="consoleLog" class="ch.qos.logback.core.ConsoleAppender">
<layout class="ch.qos.logback.classic.PatternLayout">
<pattern>
%d - %msg%n
</pattern>
</layout>
</appender>
<appender name="fileInfoLog" class="ch.qos.logback.core.rolling.RollingFileAppender">
<filter class="ch.qos.logback.classic.filter.LevelFilter">
<level>ERROR</level>
<onMatch>DENY</onMatch>
<onMismatch>ACCEPT</onMismatch>
</filter>
<encoder>
<pattern>
%d - %msg%n
</pattern>
</encoder>
? ? ? ? <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
? ? ? ? ? ? <fileNamePattern>${LOG_HOME}/info.%d{yyyy-MM-dd}.log</fileNamePattern>
<maxHistory>30</maxHistory>
<totalSizeCap>1GB</totalSizeCap>
</rollingPolicy>
</appender>
<appender name="fileErrorLog" class="ch.qos.logback.core.rolling.RollingFileAppender">
<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
<level>ERROR</level>
</filter>
<encoder>
<pattern>
%d - %msg%n
</pattern>
</encoder>
? ? ? ? <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
? ? ? ? ? ? <fileNamePattern>${LOG_HOME}/error.%d{yyyy-MM-dd}.log</fileNamePattern>
<maxHistory>30</maxHistory>
<totalSizeCap>1GB</totalSizeCap>
</rollingPolicy>
</appender>
<logger name="com.keji.xiangmu" level="DEBUG"/>
<root level="info">
<appender-ref ref="consoleLog"/>
<appender-ref ref="fileInfoLog"/>
<appender-ref ref="fileErrorLog"/>
</root>
</configuration>
```