log4j2로 JPA(hibernate) SQL Log 남기기

hibernate 프로퍼티 설정

hibernate.show_sql = false
hibernate.format_sql = true
hibernate.user_sql_comments = true

log4j2 설정

<Logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="TRACE" additivity="false">
    <AppenderRef ref="너의 어팬더" />
</Logger>
<Logger name="org.hibernate.SQL" level="DEBUG" additivity="false">
    <AppenderRef ref="너의 어팬더" />
</Logger>

스프링부트에서는

spring.jpa.properties.hibernate.format_sql=true
spring.jpa.properties.hibernate.show_sql=false
logging.level.org.hibernate.SQL=debug
logging.level.org.hibernate.type=trace