Springboot + Hibernate 日志打印sql

166 阅读1分钟

1.spring.hibernate.cfg.xml配置文件中show_sql参数值配置为true

<property name="hibernateProperties">
    <props>
        <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
        <prop key="hibernate.show_sql">true</prop>
        <prop key="hibernate.hbm2ddl.auto">none</prop>
        <prop key="javax.persistence.validation.mode">none</prop>
    </props>
</property>

image.png

2.在application.properties文件或者启动参数中增加以下的配置

log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
log4j.loggerorg.hibernate.type.descriptor.sql.BasicExtractor=TRACE

image.png