`application.properties`に次の行を追加して、Hibernate SQLクエリを記録します。

application.properties

#show sql statement
logging.level.org.hibernate.SQL=debug

#show sql values
logging.level.org.hibernate.type.descriptor.sql=trace

1. org.hibernate.SQL = debug

application.properties

logging.level.org.hibernate.SQL=debug

1.1クエリを選択します。

コンソール

2017-02-23 21:36:42 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__,
    customer0__.created__date as created__date2__0__, customer0__.email as email3__0__,
    customer0__.name as name4__0__ from customer customer0__

2. org.hibernate.type.descriptor.sql = trace

application.properties

logging.level.org.hibernate.SQL=debug
logging.level.org.hibernate.type.descriptor.sql=trace

2.1クエリとその値を選択します。

コンソール

2017-02-23 21:39:23 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__,
    customer0__.created__date as created__date2__0__, customer0__.email as email3__0__,
    customer0__.name as name4__0__ from customer customer0__

    2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([id1__0__]:[BIGINT]) -[1]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([created__date2__0__]:[TIMESTAMP]) -[2017-02-11 00:00:00.0]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([email3__0__]:[VARCHAR]) -[[email protected]]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([name4__0__]:[VARCHAR]) -[mkyong]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([id1__0__]:[BIGINT]) -[2]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([created__date2__0__]:[TIMESTAMP]) -[2017-02-12 00:00:00.0]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([email3__0__]:[VARCHAR]) -[[email protected]]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([name4__0__]:[VARCHAR]) -[yflow]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([id1__0__]:[BIGINT]) -[3]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([created__date2__0__]:[TIMESTAMP]) -[2017-02-13 00:00:00.0]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([email3__0__]:[VARCHAR]) -[[email protected]]2017-02-23 21:39:23 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([name4__0__]:[VARCHAR]) -[zilap]....

2.2クエリとその値を挿入します。

コンソール

2017-02-23 21:44:15 DEBUG org.hibernate.SQL – select customer

seq.nextval from dual
2017-02-23 21:44:15 DEBUG org.hibernate.SQL – insert into customer (created

date, email, name, id) values (?, ?, ?, ?)

2017-02-23 21:44:15 TRACE o.h.type.descriptor.sql.BasicBinder – binding parameter[1]as[TIMESTAMP]-[Thu Feb 23 21:44:15 SGT 2017]2017-02-23 21:44:15 TRACE o.h.type.descriptor.sql.BasicBinder – binding parameter[2]as[VARCHAR]-[aa]2017-02-23 21:44:15 TRACE o.h.type.descriptor.sql.BasicBinder – binding parameter[3]as[VARCHAR]-[a]2017-02-23 21:44:15 TRACE o.h.type.descriptor.sql.BasicBinder – binding parameter[4]as[BIGINT]-[1]…​.

参考文献

  1. リンク://spring-boot/spring-boot-slf4j-logging-example/[Spring Boot

SLF4Jロギングの例]