配置log4j2.xml输出MyBatis的SQL日志

最新推荐文章于 2024-07-26 21:37:59 发布

wjxbj

最新推荐文章于 2024-07-26 21:37:59 发布

阅读量2.7k

点赞数 1

分类专栏： java基础文章标签： log4j2.xml MyBatis

java基础专栏收录该内容

170 篇文章 0 订阅

订阅专栏

在工作中，排查问题时难免需要输出MyBatis真正执行的SQL及参数，需查看SQL信息，如下是一种配置方法：

log4j2.xml

<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="info">
	<Appenders>
		<Console name="console" target="SYSTEM_OUT">
			<PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5p %c{1}(%F:%L) - %m%n" />
		</Console>
		<RollingFile name="fixedTimeFileAppender" fileName="app/projectName.log"
			filePattern="app/projectName.log.%d{yyyy-MM-dd}.%i.log">
			<PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5p %c{1}(%L) - %m%n" />
			<Policies>
				<TimeBasedTriggeringPolicy />
				<SizeBasedTriggeringPolicy size="200 MB" />
			</Policies>
			<DefaultRolloverStrategy max="24" />
		</RollingFile>
		<RollingFile name="fixedTimeFileSQLAppender" fileName="app/projectName-sql.log"
			filePattern="app/projectName-sql.log.%d{yyyy-MM-dd}.%i.log">
			<PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5p %c{1}(%L) - %m%n" />
			<Policies>
				<TimeBasedTriggeringPolicy />
				<SizeBasedTriggeringPolicy size="200 MB" />
			</Policies>
			<DefaultRolloverStrategy max="24" />
		</RollingFile>
		
		<Async name="async" bufferSize="512">
			<AppenderRef ref="fixedTimeFileAppender" />
		</Async>
		<Async name="asyncsql" bufferSize="512" level="debug">
			<AppenderRef ref="fixedTimeFileSQLAppender" />
		</Async>
	</Appenders>
	<Loggers>
		<Logger name="cn.bijian" level="info" additivity="false">
			<AppenderRef ref="async" />
		</Logger>
		
		<Logger name="cn.bijian.projectName.dao" level="debug" additivity="false">
			<AppenderRef ref="asyncsql" />
		</Logger>
		
		<Root level="info">
			<AppenderRef ref="async" />
		</Root>
	</Loggers>
</Configuration>