Can the id of mapped statement be shown in the sql log?

[vonlinee]

to help find the statement in sql log, can the id of statement be added into the sql log, like this :

[harawata]

Hello @vonlinee ,

In the log format pattern, the logger will be the statement ID.

With this pattern, for example, ...

mybatis-3/src/test/resources/logback-test.xml

Line 24 in a20b521

<pattern>%d{HH:mm:ss.SSS} %-5level [%thread] %logger{36} - %msg%n</pattern>

... the output would look as follows.

21:00:31.485 DEBUG [main] o.a.i.s.basetest.Mapper.insertUser - ==>  Preparing: insert into users values(?, ?)
21:00:31.499 DEBUG [main] o.a.i.s.basetest.Mapper.insertUser - ==> Parameters: 2(Integer), User2(String)
21:00:31.499 DEBUG [main] o.a.i.s.basetest.Mapper.insertUser - <==    Updates: 1

[vonlinee]

ok, thanks