blocks|key|565|text|尝试在您的属性文件中使用以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|566|logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE|code-block|syntax|javascript|567|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

try using this in your properties file:

<pre><code>logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
</code></pre>

blocks|key|4508251|text|这也适用于stdout：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4508252|spring.jpa.properties.hibernate.show_sql=true
spring.jpa.properties.hibernate.use_sql_comments=true
spring.jpa.properties.hibernate.format_sql=true|code-block|syntax|javascript|4508253|要记录值，请执行以下操作：|4508254|logging.level.org.hibernate.type=trace|4508255|只需将此添加到application.properties即可。|offset|length|style|CODE|4508256|entityMap^0|0|0|0|0|7|M|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

This works for stdout too:

<pre><code>spring.jpa.properties.hibernate.show_sql=true
spring.jpa.properties.hibernate.use_sql_comments=true
spring.jpa.properties.hibernate.format_sql=true
</code></pre>

To log values: 

<pre><code>logging.level.org.hibernate.type=trace
</code></pre>

Just add this to <code>application.properties</code>.

blocks|key|619|text|这对我很有效(YAML)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|620|spring:
++jpa:
++++properties:
++++++hibernate:
++++++++show_sql:+true
++++++++format_sql:+true
logging:
++level:
++++org:
++++++hibernate:
++++++++type:+trace|code-block|syntax|javascript|621|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This works for me (YAML):

<pre><code>spring:
 jpa:
 properties:
 hibernate:
 show_sql: true
 format_sql: true
logging:
 level:
 org:
 hibernate:
 type: trace
</code></pre>

blocks|key|960|text|要避免的设置|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961|您不应使用此设置：|962|spring.jpa.show-sql=true+|code-block|syntax|javascript|963|show-sql的问题在于，SQL语句是在控制台中打印出来的，因此无法像通常使用日志记录框架那样对其进行过滤。|offset|length|style|CODE|964|使用Hibernate日志记录|965|在日志配置文件中，如果添加以下记录器：|966|<logger+name="org.hibernate.SQL"+level="debug"/>|967|然后，Hibernate将在创建JDBC+PreparedStatement时打印SQL语句。这就是使用参数占位符记录语句的原因：|968|INSERT+INTO+post+(title,+version,+id)+VALUES+(?,+?,+?)|969|如果您想记录绑定参数值，只需添加以下记录器：|970|<logger+name="org.hibernate.type.descriptor.sql.BasicBinder"+level="trace"/>|971|设置BasicBinder记录器后，您将看到绑定参数值也被记录下来：|972|DEBUG+[main]:+o.h.SQL+-+insert+into+post+(title,+version,+id)+values+(?,+?,+?)
TRACE+[main]:+o.h.t.d.s.BasicBinder+-+binding+parameter+[1]+as+[VARCHAR]+-+[High-Performance+Java+Persistence,+part+1]
TRACE+[main]:+o.h.t.d.s.BasicBinder+-+binding+parameter+[2]+as+[INTEGER]+-+[0]
TRACE+[main]:+o.h.t.d.s.BasicBinder+-+binding+parameter+[3]+as+[BIGINT]+-+[1]|973|使用数据源代理|974|JDBC+OSS框架允许您代理实际的datasource-proxy+DataSource，如下图所示：|975|​|976|📷|atomic|977|978|您可以按如下方式定义Hibernate将使用的dataSource+bean：|979|@Bean
public+DataSource+dataSource(DataSource+actualDataSource)+{
++++SLF4JQueryLoggingListener+loggingListener+=+new+SLF4JQueryLoggingListener();
++++loggingListener.setQueryLogEntryCreator(new+InlineQueryLogEntryCreator());
++++return+ProxyDataSourceBuilder
++++++++.create(actualDataSource)
++++++++.name(DATA_SOURCE_PROXY_NAME)
++++++++.listener(loggingListener)
++++++++.build();
}|980|请注意，actualDataSource必须是您在应用程序中使用的连接池定义的DataSource。|981|接下来，您需要在日志框架配置文件中将net.ttddyy.dsproxy.listener日志级别设置为debug。例如，如果您使用的是Logback，则可以添加以下记录器：|982|<logger+name="net.ttddyy.dsproxy.listener"+level="debug"/>|983|启用datasource-proxy后，将按如下方式记录SQl语句：|984|Name:DATA_SOURCE_PROXY,+Time:6,+Success:True,
Type:Prepared,+Batch:True,+QuerySize:1,+BatchSize:3,
Query:["insert+into+post+(title,+version,+id)+values+(?,+?,+?)"],
Params:[(Post+no.+0,+0,+0),+(Post+no.+1,+0,+1),+(Post+no.+2,+0,+2)]|985|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/ttddyy/datasource-proxy|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/e1259eb5630cc44c3bd2182ea60283f5.png|imageAlt^0|0|0|0|0|8|0|0|0|0|L|H|0|0|0|0|2|B|0|0|0|Z|A|I|G|0|0|0|0|1|1|0|0|N|A|0|0|4|G|13|A|0|I|R|1G|5|0|0|2|G|0|0^^$0|@$1|2|3|4|5|6|7|28|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|29|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|2A|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|2B|8|@$K|2C|L|2D|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|2E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|2F|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|2G|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|2H|8|@$K|2I|L|2J|M|N]]|9|@]|A|$]]|$1|W|3|X|5|F|7|2K|8|@]|9|@]|A|$G|H]]|$1|Y|3|Z|5|6|7|2L|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|2M|8|@]|9|@]|A|$G|H]]|$1|12|3|13|5|6|7|2N|8|@$K|2O|L|2P|M|N]]|9|@]|A|$]]|$1|14|3|15|5|F|7|2Q|8|@]|9|@]|A|$G|H]]|$1|16|3|17|5|6|7|2R|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|2S|8|@$K|2T|L|2U|M|N]]|9|@$K|2V|L|2W|1|2X]]|A|$]]|$1|1A|3|1B|5|6|7|2Y|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|1E|7|2Z|8|@]|9|@$K|30|L|31|1|32]]|A|$]]|$1|1F|3|1B|5|6|7|33|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|34|8|@$K|35|L|36|M|N]]|9|@]|A|$]]|$1|1I|3|1J|5|F|7|37|8|@]|9|@]|A|$G|H]]|$1|1K|3|1L|5|6|7|38|8|@$K|39|L|3A|M|N]|$K|3B|L|3C|M|N]]|9|@]|A|$]]|$1|1M|3|1N|5|6|7|3D|8|@$K|3E|L|3F|M|N]|$K|3G|L|3H|M|N]]|9|@]|A|$]]|$1|1O|3|1P|5|F|7|3I|8|@]|9|@]|A|$G|H]]|$1|1Q|3|1R|5|6|7|3J|8|@$K|3K|L|3L|M|N]]|9|@]|A|$]]|$1|1S|3|1T|5|F|7|3M|8|@]|9|@]|A|$G|H]]|$1|1U|3|-4|5|6|7|3N|8|@]|9|@]|A|$]]]|1V|$1W|$5|1X|1Y|1Z|A|$20|21]]|22|$5|23|1Y|24|A|$25|26|27|-4]]]]

<h2>Settings to avoid</h2>
You should not use this setting:
<pre><code>spring.jpa.show-sql=true 
</code></pre>
The problem with <code>show-sql</code> is that the SQL statements are printed in the console, so there is no way to filter them, as you'd normally do with a Logging framework.
<h2>Using Hibernate logging</h2>
In your log configuration file, if you add the following logger:
<pre><code>&lt;logger name=&quot;org.hibernate.SQL&quot; level=&quot;debug&quot;/&gt;
</code></pre>
Then, Hibernate will print the SQL statements when the JDBC <code>PreparedStatement</code> is created. That's why the statement will be logged using parameter placeholders:
<pre><code>INSERT INTO post (title, version, id) VALUES (?, ?, ?)
</code></pre>
If you want to log the bind parameter values, just add the following logger as well:
<pre><code>&lt;logger name=&quot;org.hibernate.type.descriptor.sql.BasicBinder&quot; level=&quot;trace&quot;/&gt;
</code></pre>
Once you set the <code>BasicBinder</code> logger, you will see that the bind parameter values are logged as well:
<pre><code>DEBUG [main]: o.h.SQL - insert into post (title, version, id) values (?, ?, ?)
TRACE [main]: o.h.t.d.s.BasicBinder - binding parameter [1] as [VARCHAR] - [High-Performance Java Persistence, part 1]
TRACE [main]: o.h.t.d.s.BasicBinder - binding parameter [2] as [INTEGER] - [0]
TRACE [main]: o.h.t.d.s.BasicBinder - binding parameter [3] as [BIGINT] - [1]
</code></pre>
<h2>Using datasource-proxy</h2>
The <a href="https://github.com/ttddyy/datasource-proxy" rel="noreferrer">datasource-proxy</a> OSS framework allows you to proxy the actual JDBC <code>DataSource</code>, as illustrated by the following diagram:
<a href="https://vladmihalcea.com/the-best-way-to-log-jdbc-statements/" rel="noreferrer"><img src="https://i.stack.imgur.com/c67Gb.png" alt="DataSource-Proxy" /></a>
You can define the <code>dataSource</code> bean that will be used by Hibernate as follows:
<pre><code>@Bean
public DataSource dataSource(DataSource actualDataSource) {
 SLF4JQueryLoggingListener loggingListener = new SLF4JQueryLoggingListener();
 loggingListener.setQueryLogEntryCreator(new InlineQueryLogEntryCreator());
 return ProxyDataSourceBuilder
 .create(actualDataSource)
 .name(DATA_SOURCE_PROXY_NAME)
 .listener(loggingListener)
 .build();
}
</code></pre>
Notice that the <code>actualDataSource</code> must be the <code>DataSource</code> defined by the [connection pool][2] you are using in your application.
Next, you need to set the <code>net.ttddyy.dsproxy.listener</code> log level to <code>debug</code> in your logging framework configuration file. For instance, if you're using Logback, you can add the following logger:
<pre><code>&lt;logger name=&quot;net.ttddyy.dsproxy.listener&quot; level=&quot;debug&quot;/&gt;
</code></pre>
Once you enable <code>datasource-proxy</code>, the SQl statement are going to be logged as follows:
<pre><code>Name:DATA_SOURCE_PROXY, Time:6, Success:True,
Type:Prepared, Batch:True, QuerySize:1, BatchSize:3,
Query:[&quot;insert into post (title, version, id) values (?, ?, ?)&quot;],
Params:[(Post no. 0, 0, 0), (Post no. 1, 0, 1), (Post no. 2, 0, 2)]
</code></pre>

blocks|key|699|text|请使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|700|logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type=TRACE
spring.jpa.show-sql=true|code-block|syntax|javascript|701|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Please use:

<pre><code>logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type=TRACE
spring.jpa.show-sql=true
</code></pre>

blocks|key|657|text|如果您有一个logback-spring.xml文件或类似的文件，请向其中添加以下代码|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|658|<logger+name="org.hibernate.SQL"+level="trace"+additivity="false">
++++<appender-ref+ref="file"+/>
</logger>|code-block|syntax|javascript|659|这对我很有效。|660|要获取绑定变量，请执行以下操作：|661|<logger+name="org.hibernate.type.descriptor.sql"+level="trace">
++++<appender-ref+ref="file"+/>
</logger>|662|entityMap^0|6|I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

If you have a <code>logback-spring.xml</code> file or something like that, add the following code to it
<pre><code>&lt;logger name=&quot;org.hibernate.SQL&quot; level=&quot;trace&quot; additivity=&quot;false&quot;&gt;
 &lt;appender-ref ref=&quot;file&quot; /&gt;
&lt;/logger&gt;
</code></pre>
That works for me.
To get bind variables as well:
<pre><code>&lt;logger name=&quot;org.hibernate.type.descriptor.sql&quot; level=&quot;trace&quot;&gt;
 &lt;appender-ref ref=&quot;file&quot; /&gt;
&lt;/logger&gt;
</code></pre>

blocks|key|770|text|YAML的翻译接受答案对我来说很有用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771|logging:
++level:
++++org:
++++++hibernate:
++++++++SQL:
++++++++++TRACE
++++++++type:
++++++++++descriptor:
++++++++++++sql:
++++++++++++++BasicBinder:
++++++++++++++++TRACE|code-block|syntax|javascript|772|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Translated accepted answer to YAML works for me

<pre><code>logging:
 level:
 org:
 hibernate:
 SQL:
 TRACE
 type:
 descriptor:
 sql:
 BasicBinder:
 TRACE
</code></pre>

blocks|key|4508350|text|根据documentation的说法，它是：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4508351|spring.jpa.show-sql=true+#+Enable+logging+of+SQL+statements.|code-block|syntax|javascript|4508352|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html^0|2|D|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

According to <a href="https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html" rel="noreferrer">documentation</a> it is:

<pre><code>spring.jpa.show-sql=true # Enable logging of SQL statements.
</code></pre>

blocks|key|756|text|如果想要查看用于查询的实际参数，可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|757|logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql=TRACE|code-block|syntax|javascript|758|然后请注意，实际参数值显示为binding+parameter......|offset|length|style|CODE|759|+++2018-08-07+14:14:36.079+DEBUG+44804+---+[+++++++++++main]+org.hibernate.SQL++++++++++++++++++++++++:+select+employee0_.id+as+id1_0_,+employee0_.department+as+departme2_0_,+employee0_.joining_date+as+joining_3_0_,+employee0_.name+as+name4_0_+from+employee+employee0_+where+employee0_.joining_date=?
++++2018-08-07+14:14:36.079+TRACE+44804+---+[+++++++++++main]+o.h.type.descriptor.sql.BasicBinder++++++:+binding+parameter+[1]+as+[TIMESTAMP]+-+[Tue+Aug+07+00:00:00+SGT+2018]|760|entityMap^0|0|0|E|N|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

If you want to view the actual parameters used to query you can use

<pre><code>logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql=TRACE
</code></pre>

Then notice that actual parameter value is shown as <code>binding parameter......</code>

<pre><code> 2018-08-07 14:14:36.079 DEBUG 44804 --- [ main] org.hibernate.SQL : select employee0_.id as id1_0_, employee0_.department as departme2_0_, employee0_.joining_date as joining_3_0_, employee0_.name as name4_0_ from employee employee0_ where employee0_.joining_date=?
 2018-08-07 14:14:36.079 TRACE 44804 --- [ main] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [TIMESTAMP] - [Tue Aug 07 00:00:00 SGT 2018]
</code></pre>

blocks|key|4508625|text|在文件application.properties中使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4508626|#Enable+logging+for+config+troubeshooting
logging.level.org.hibernate.SQL=DEBUG
logging.level.com.zaxxer.hikari.HikariConfig=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE|code-block|syntax|javascript|4508627|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

use this code in the file application.properties:
<pre><code>#Enable logging for config troubeshooting
logging.level.org.hibernate.SQL=DEBUG
logging.level.com.zaxxer.hikari.HikariConfig=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
</code></pre>

blocks|key|829|text|如果您在使用此设置时遇到问题，并且它有时似乎可以工作，而在其他时间却不能工作-请考虑它不能工作的时间是否在单元测试期间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|830|许多人通过在测试继承层次结构中的某个位置声明的@TestPropertySources注释来声明自定义测试时间属性。这将覆盖您在application.properties或其他产品属性设置中设置的任何内容，因此您设置的那些值在测试时实际上会被忽略。|offset|length|style|CODE|831|entityMap^0|0|N|K|1S|M|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|I|$]]

If you're having trouble with this setting and it seems to work sometimes and not other times - consider if the times where it doesn't work are during unit tests.

Many people declare custom test-time properties via the <code>@TestPropertySources</code> annotation declared somewhere in your test inheritance hierarchy. This will override whatever you put in your <code>application.properties</code> or other production properties settings so those values you're setting are effectively being ignored at test-time.

blocks|key|875|text|将spring.jpa.properties.hibernate.show_sql=true放在application.properties中并不总是有帮助的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|876|您可以尝试将properties.put("hibernate.show_sql",+"true");添加到数据库配置的属性中。|877|public+class+DbConfig+{

++++@Primary
++++@Bean(name+=+"entityManagerFactory")
++++public+LocalContainerEntityManagerFactoryBean
++++entityManagerFactory(
++++++++++++EntityManagerFactoryBuilder+builder,
++++++++++++@Qualifier("dataSource")+DataSource+dataSource
++++)+{
++++++++Map<String,+Object>+properties+=+new+HashMap();
++++++++properties.put("hibernate.hbm2ddl.auto",+"validate");
++++++++properties.put("hibernate.show_sql",+"true");

++++++++return+builder
++++++++++++++++.dataSource(dataSource)
++++++++++++++++.packages("com.test.dbsource.domain")
++++++++++++++++.persistenceUnit("dbsource").properties(properties)
++++++++++++++++.build();
++++}|code-block|syntax|javascript|878|entityMap^0|1|19|0|6|19|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|U|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

Putting <code>spring.jpa.properties.hibernate.show_sql=true</code> in application.properties didn't help always.

You can try to add <code>properties.put("hibernate.show_sql", "true");</code> to the properties of the database configuration.

<pre><code>public class DbConfig {

 @Primary
 @Bean(name = "entityManagerFactory")
 public LocalContainerEntityManagerFactoryBean
 entityManagerFactory(
 EntityManagerFactoryBuilder builder,
 @Qualifier("dataSource") DataSource dataSource
 ) {
 Map&lt;String, Object&gt; properties = new HashMap();
 properties.put("hibernate.hbm2ddl.auto", "validate");
 properties.put("hibernate.show_sql", "true");

 return builder
 .dataSource(dataSource)
 .packages("com.test.dbsource.domain")
 .persistenceUnit("dbsource").properties(properties)
 .build();
 }
</code></pre>

blocks|key|4508589|text|您只需在application.properties中设置spring.jpa.show-sql=true，例如，您可以引用此https://github.com/007anwar/ConfigServerRepo/blob/master/application.yaml|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4508590|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/007anwar/ConfigServerRepo/blob/master/application.yaml^0|T|O|1R|21|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

You just need to set
<code>spring.jpa.show-sql=true</code> in application.properties
for example you may reffer this <a href="https://github.com/007anwar/ConfigServerRepo/blob/master/application.yaml" rel="nofollow noreferrer">https://github.com/007anwar/ConfigServerRepo/blob/master/application.yaml</a>

blocks|key|1202|text|对于stdout+SQL查询，您只需在application.properties中添加以下行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1203|spring.jpa.properties.hibernate.show_sql=true|code-block|syntax|javascript|1204|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can simply add the below lines in application.properties for stdout SQL queries:
<pre><code>spring.jpa.properties.hibernate.show_sql=true
</code></pre>

blocks|key|4508684|text|在我的yaml中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4508685|logging:
++level:
++++org.hibernate.SQL:+DEBUG
++++org.hibernate.type.descriptor.sql:+TRACE|code-block|syntax|javascript|4508686|Spring+boot版本:+2.3.5.RELEASE|4508687|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In my yaml:
<pre><code>logging:
 level:
 org.hibernate.SQL: DEBUG
 org.hibernate.type.descriptor.sql: TRACE
</code></pre>
Spring boot version: 2.3.5.RELEASE

blocks|key|1150|text|基本方法是在application.properties中添加以下行。这将使spring+boot能够记录所有执行的SQL查询：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1151|spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true|code-block|syntax|javascript|1152|第二行用于美化SQL语句。|1153|如果你想使用记录器，你可以使用下面的代码行：|1154|logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE|1155|第二行用于打印与查询绑定的所有参数。希望这对你有用。如果您有任何进一步的疑问，请告诉我！|1156|entityMap^0|6|M|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

The basic way is to add the following lines in your <code>application.properties</code>. This will enable spring boot to log all your SQL queries that get executed:
<pre><code>spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true
</code></pre>
The 2nd line is used to beautify the SQL Statements.
If you want to use loggers, you can use the following lines:
<pre><code>logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
</code></pre>
The 2nd line is used to print all the parameters that get bound with your queries.
Hope this works for you.
Please let me know if you have any further queries!

blocks|key|1186|text|在属性中添加这些。引用Hibernate+Show+SQL|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1187|#show+sql+statement
logging.level.org.hibernate.SQL=debug

#show+sql+values
logging.level.org.hibernate.type.descriptor.sql=trace|code-block|syntax|javascript|1188|entityMap|0|LINK|mutability|MUTABLE|url|https://springframework.guru/hibernate-show-sql/^0|B|I|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Add these in the properties. Quoting <a href="https://springframework.guru/hibernate-show-sql/" rel="nofollow noreferrer">Hibernate Show SQL</a>:
<pre><code>#show sql statement
logging.level.org.hibernate.SQL=debug

#show sql values
logging.level.org.hibernate.type.descriptor.sql=trace
</code></pre>

blocks|key|1247|text|如果您使用的是JdbcTemplate，请在application.properties文件中添加以下内容，以记录sql和参数值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1248|logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
logging.level.org.springframework.jdbc.core.StatementCreatorUtils=TRACE|code-block|syntax|javascript|1249|entityMap^0|M|M|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

If you are using JdbcTemplate, add the below in <code>application.properties</code> file to log sql and parameter values.
<pre><code>logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
logging.level.org.springframework.jdbc.core.StatementCreatorUtils=TRACE
</code></pre>

I want to log SQL statements in a file. 
I have the following properties in <code>application.properties</code>

<pre><code>spring.datasource.url=...
spring.datasource.username=user
spring.datasource.password=1234
spring.datasource.driver-class-name=net.sourceforge.jtds.jdbc.Driver

spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true

security.ignored=true
security.basic.enabled=false

logging.level.org.springframework.web=INFO
logging.level.org.hibernate=INFO
logging.file=c:/temp/my-log/app.log
</code></pre>

When I run my application 

<pre><code>cmd&gt;mvn spring-boot:run
</code></pre>

I can see sql statements in the console but they don't appear in a file app.log. The file contains only basic logs from spring.

What should I do to see sql statements in the log file?

How to log SQL statements in Spring Boot?

日志文件

单元测试

数据库

Java

我想在一个文件中记录SQL语句。我在application.properties中有以下属性spring.datasource.url=...spring.datasource.username=userspring.datasource.password=1234spring.datasource.driver-class-name=net.sourceforge.jtds.jdbc.Drive

问如何在Spring Boot中记录SQL语句？
EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Spring Boot中记录SQL语句？EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Spring Boot中记录SQL语句？
EN