如何将Hibernate sql语句记录在日志文件中而不是控制台中

Question

我需要将Hibernate sql语句记录到日志文件中，而不是控制台中。我使用的是弹簧靴JPA。和：

spring.jpa.show-sql=true
logging.path=/logs

Answer 1

请在配置中添加以下行(如何在Spring Boot中记录SQL语句？(

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

spring.jpa.show-sql导致语句被记录到stdout Hibernate show sql等于stdout

如果你想要一个不同的Hibernate日志文件，你可以添加logback.xml

<configuration>
<appender name="fileAppender"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<file>${DEV_HOME}/[yourlognamefile].log</file>
<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
<Pattern>
%d{yyyy-MM-dd HH:mm:ss} - %msg%n
</Pattern>
</encoder>

<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<!-- rollover daily -->
<fileNamePattern>${DEV_HOME}/archived/[yourlognamefile].%d{yyyy-MM-dd}.%i.log
</fileNamePattern>
<timeBasedFileNamingAndTriggeringPolicy
class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
<maxFileSize>10MB</maxFileSize>
</timeBasedFileNamingAndTriggeringPolicy>
</rollingPolicy>

</appender>

<logger name="org.hibernate" level="DEBUG" />
<appender-ref ref="fileAppender"/>
</logger>
</configuration>

有关更多信息，您可以查看：https://dzone.com/articles/configuring-logback-with-spring-boot