blocks|key|857167|text|请参阅Can't+make+hibernate+stop+showing+SQL+using+Spring+JPA+Vendor+Adapter|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|857168|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/679518/cant-make-hibernate-stop-showing-sql-using-spring-jpa-vendor-adapter^0|3|1X|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

See <a href="https://stackoverflow.com/questions/679518/cant-make-hibernate-stop-showing-sql-using-spring-jpa-vendor-adapter">Can&#39;t make hibernate stop showing SQL using Spring JPA Vendor Adapter</a>

blocks|key|1071721|text|此外，如果您正在使用EclipseLink并希望输出SQL参数值，则可以将此属性添加到persistence.xml文件中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071722|<property+name="eclipselink.logging.parameters"+value="true"/>|code-block|syntax|javascript|1071723|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|$]]

Also, if you're using EclipseLink and want to output the SQL parameter values, you can add this property to your persistence.xml file:

<pre><code>&lt;property name="eclipselink.logging.parameters" value="true"/&gt;
</code></pre>

blocks|key|1071753|text|在EclipseLink中，要在运行时获取特定查询的DatabaseQuery，您可以使用SQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071754|Query+query+=+em.createNamedQuery("findMe");+
Session+session+=+em.unwrap(JpaEntityManager.class).getActiveSession();+
DatabaseQuery+databaseQuery+=+((EJBQueryImpl)query).getDatabaseQuery();+
databaseQuery.prepareCall(session,+new+DatabaseRecord());

String+sqlString+=+databaseQuery.getSQLString();|code-block|syntax|javascript|1071755|此SQL将包含？对于参数。要转换带有参数的SQL，您需要一个带有参数值的DatabaseRecord。|1071756|DatabaseRecord+recordWithValues=+new+DatabaseRecord();
recordWithValues.add(new+DatabaseField("param1"),+"someValue");

String+sqlStringWithArgs+=+
+++++++++databaseQuery.getTranslatedSQLString(session,+recordWithValues);|1071757|来源：How+to+get+the+SQL+for+a+Query|offset|length|1071758|entityMap|0|LINK|mutability|MUTABLE|url|http://wiki.eclipse.org/EclipseLink/FAQ/JPA#How_to_get_the_SQL_for_a_Query.3F^0|0|0|0|0|3|U|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

In EclipseLink to get the SQL for a specific Query at runtime you can use the DatabaseQuery API:

<pre><code>Query query = em.createNamedQuery("findMe"); 
Session session = em.unwrap(JpaEntityManager.class).getActiveSession(); 
DatabaseQuery databaseQuery = ((EJBQueryImpl)query).getDatabaseQuery(); 
databaseQuery.prepareCall(session, new DatabaseRecord());

String sqlString = databaseQuery.getSQLString();
</code></pre>

This SQL will contain ? for parameters. To get the SQL translated with the arguments you need a DatabaseRecord with the parameter values.

<pre><code>DatabaseRecord recordWithValues= new DatabaseRecord();
recordWithValues.add(new DatabaseField("param1"), "someValue");

String sqlStringWithArgs = 
 databaseQuery.getTranslatedSQLString(session, recordWithValues);
</code></pre>

Source: <a href="http://wiki.eclipse.org/EclipseLink/FAQ/JPA#How_to_get_the_SQL_for_a_Query.3F" rel="noreferrer">How to get the SQL for a Query</a>

blocks|key|857300|text|要查看OpenJPA中的所有SQL和参数，请将以下两个参数放入persistence.xml：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857301|<property+name="openjpa.Log"+value="DefaultLevel=WARN,+Runtime=INFO,+Tool=INFO,+SQL=TRACE"/>
<property+name="openjpa.ConnectionFactoryProperties"+value="PrintParameters=true"+/>|code-block|syntax|javascript|857302|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|$]]

In order to view all the SQL and parameters in OpenJPA, put these two parameters in the persistence.xml:

<pre><code>&lt;property name="openjpa.Log" value="DefaultLevel=WARN, Runtime=INFO, Tool=INFO, SQL=TRACE"/&gt;
&lt;property name="openjpa.ConnectionFactoryProperties" value="PrintParameters=true" /&gt;
</code></pre>

blocks|key|1071864|text|此外，如果使用WildFly/JBoss，请将org.hibernate的日志记录级别设置为DEBUG|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071865|​|1071866|📷|atomic|offset|length|1071867|1071868|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6bdc135312c0e7d702bc31fd89122140.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Additionally, if using WildFly/JBoss, set the logging level of org.hibernate to DEBUG

<a href="https://i.stack.imgur.com/cV0mR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cV0mR.png" alt="Hibernate Logging in WildFly"></a>

blocks|key|857363|text|另一个good+option如果你有太多的日志，并且你只想放在一个临时的System.out.println()中，你可以，取决于你的提供者：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|857364|CriteriaBuilder+criteriaBuilder+=+getEntityManager().getCriteriaBuilder();
CriteriaQuery<ExaminationType>+criteriaQuery+=+criteriaBuilder.createQuery(getEntityClass());+

/*+For+Hibernate+*/
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(org.hibernate.query.Query.class).getQueryString());

/*+For+OpenJPA+*/+
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(org.apache.openjpa.persistence.QueryImpl.class).getQueryString());

/*+For+EclipseLink+*/
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(JpaQuery.class).getSQLString());|code-block|syntax|javascript|857365|entityMap|0|LINK|mutability|MUTABLE|url|https://antoniogoncalves.org/2012/05/24/how-to-get-the-jpqlsql-string-from-a-criteriaquery-in-jpa/^0|10|K|3|B|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Another <a href="https://antoniogoncalves.org/2012/05/24/how-to-get-the-jpqlsql-string-from-a-criteriaquery-in-jpa/" rel="nofollow noreferrer">good option</a> if you have too much log and you want to only put as a temporal <code>System.out.println()</code>, you can, depending on your provider do:
<pre><code>CriteriaBuilder criteriaBuilder = getEntityManager().getCriteriaBuilder();
CriteriaQuery&lt;ExaminationType&gt; criteriaQuery = criteriaBuilder.createQuery(getEntityClass()); 

/* For Hibernate */
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(org.hibernate.query.Query.class).getQueryString());

/* For OpenJPA */ 
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(org.apache.openjpa.persistence.QueryImpl.class).getQueryString());

/* For EclipseLink */
System.out.println(getEntityManager().createQuery(criteriaQuery).unwrap(JpaQuery.class).getSQLString());
</code></pre>

blocks|key|857392|text|使用Spring+Boot，只需将:+spring.jpa.show-sql=true添加到application.properties即可。这将显示查询，但没有实际参数(您将看到？而不是每个参数)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857393|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

With Spring Boot simply add: spring.jpa.show-sql=true to application.properties.
This will show the query but without the actual parameters (you will see ? instead of each parameter).

blocks|key|857439|text|在探索性开发期间，为了将SQL调试日志记录集中在我想要检查的特定方法上，我使用以下记录器语句来修饰该方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857440|import+org.slf4j.Logger;
import+org.slf4j.LoggerFactory;
import+ch.qos.logback.classic.Level;

((ch.qos.logback.classic.Logger)+LoggerFactory.getLogger("org.hibernate.SQL")).setLevel(Level.DEBUG);
entityManager.find(Customer.class,+customerID);
((ch.qos.logback.classic.Logger)+LoggerFactory.getLogger("org.hibernate.SQL")).setLevel(Level.INFO);|code-block|syntax|javascript|857441|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|$]]

During explorative development, and to focus the SQL debugging logging on the specific method I want to check, I decorate that method with the following logger statements:

<pre><code>import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import ch.qos.logback.classic.Level;

((ch.qos.logback.classic.Logger) LoggerFactory.getLogger("org.hibernate.SQL")).setLevel(Level.DEBUG);
entityManager.find(Customer.class, customerID);
((ch.qos.logback.classic.Logger) LoggerFactory.getLogger("org.hibernate.SQL")).setLevel(Level.INFO);

</code></pre>

blocks|key|1072016|text|用于输出SQL的配置(persistence.xml+EclipseLink+)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072017|<property+name="eclipselink.logging.level.sql"+value="FINE"+/>|code-block|syntax|javascript|1072018|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|$]]

EclipseLink to output the SQL(persistence.xml config):

<pre><code>&lt;property name="eclipselink.logging.level.sql" value="FINE" /&gt;
</code></pre>

blocks|key|857531|text|JPA提供程序可以为您设置它-如果有人不想通过JPA属性进行控制的话|type|unstyled|depth|inlineStyleRanges|entityRanges|data|857532|public+static+JpaProperties+properties()+{
++++++++final+JpaProperties+jpaProperties+=+new+JpaProperties();
++++++++jpaProperties.setShowSql(true);|code-block|syntax|javascript|857533|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|$]]

JPA provider can set it for you - incase if someone doesn't want to control through JPA properties
<pre><code>public static JpaProperties properties() {
 final JpaProperties jpaProperties = new JpaProperties();
 jpaProperties.setShowSql(true);
</code></pre>

When my code issues a call like this:

<pre><code>entityManager.find(Customer.class, customerID);
</code></pre>

How can I see the SQL query for this call? Assuming I don't have access to database server to profile/monitor the calls, is there way to log or view within my IDE the corresponding SQL queries issued by JPA calls? I'm going against SQL Server 2008 R2 using the jTDS driver.

How to view the SQL queries issued by JPA?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我的代码发出这样的调用时：entityManager.find(Customer.class, customerID);如何查看此调用的SQL查询？假设我不能访问数据库服务器来分析/监视调用，有没有办法在我的IDE中记录或查看由JPA调用发出的相应SQL查询？我反对使用jTDS驱动程序的SQL Server2008 ...

问如何查看JPA发出的SQL查询？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查看JPA发出的SQL查询？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查看JPA发出的SQL查询？
EN