Hibernate 쿼리 로그

[raycon]

# logs the SQL statements
logging.level.org.hibernate.SQL=DEBUG
# Logs the JDBC parameters passed to a query
logging.level.org.hibernate.type=TRACE

[raycon]

JdbcTemplate 로그

logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
logging.level.org.springframework.jdbc.core.StatementCreatorUtils=TRACE

[raycon]

쿼리를 보기 좋게 출력하려면

spring.jpa.properties.hibernate.format_sql=true