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