Springブート – Hibernate SQLクエリを表示する
`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]….