Log mybatis sql query

To log SQL queries from a specific mapper in mybatis, add the mapper namespace to the logger level.

Eg :

If this is the mapper file,

<mapper namespace=”customer”>

Then to log statements that are defined in this mapper xml,

<logger name=”customer”> 
    <level value=”trace”/>
    <appender-ref ref=”consoleAppender” />
</logger>

Reference :
http://www.mybatis.org/mybatis-3/logging.html

Originally published at cheeky-chinnu.blogspot.com on January 8, 2019.