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

淩亂°似流年 2023-09-30 11:14 16阅读 0赞

日志记录选项是特定于提供商的。您需要知道您使用的是哪种 JPA 实现。

*  休眠（[见这里][Link 1]）：
    
        <property name = "hibernate.show_sql" value = "true" />

<?xml version="1.0" encoding="UTF-8"?>
    <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
        <persistence-unit name="com.example_jpanetbeans2_jar_1.0-SNAPSHOTPU" transaction-type="RESOURCE_LOCAL">
            <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
            <class>com.example.jpanetbeans2.Books</class>
            <properties>
                <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/db?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"/>
                <property name="javax.persistence.jdbc.user" value="root"/>
                <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="javax.persistence.jdbc.password" value="root"/>
                <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
                <property name = "hibernate.show_sql" value = "true" />
            </properties>
        </persistence-unit>
    </persistence>

*  EclipseLink（[见这里][Link 2]）：
    
        <property name="eclipselink.logging.level" value="FINE"/>

<?xml version="1.0" encoding="UTF-8"?>
    <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
        <persistence-unit name="com.example_jpanetbeans_jar_1.0-SNAPSHOTPU" transaction-type="RESOURCE_LOCAL">
            <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
            <class>com.example.jpanetbeans.Books</class>
            <properties>
                <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/db?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"/>
                <property name="javax.persistence.jdbc.user" value="root"/>
                <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="javax.persistence.jdbc.password" value="root"/>
                <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
                <property name="eclipselink.logging.level" value="FINE"/>
    
            </properties>
        </persistence-unit>
    </persistence>

*  OpenJPA（[见这里][Link 3]）：
    
        <property name="openjpa.Log" value="DefaultLevel=WARN,Runtime=INFO,Tool=INFO,SQL=TRACE"/>

<?xml version="1.0" encoding="UTF-8"?>
    <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
        <persistence-unit name="com.example_jpanetbeans4_jar_1.0-SNAPSHOTPU" transaction-type="RESOURCE_LOCAL">
            <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
            <class>com.example.jpanetbeans4.Books</class>
            <properties>
                <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/db?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"/>
                <property name="javax.persistence.jdbc.user" value="root"/>
                <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="javax.persistence.jdbc.password" value="root"/>
                <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
                <property name="openjpa.Log" value="DefaultLevel=WARN,Runtime=INFO,Tool=INFO,SQL=TRACE"/>
            </properties>
        </persistence-unit>
    </persistence>

*  DataNucleus（[见这里][Link 4]）：
    
    将日志类别设置`DataNucleus.Datastore.N`
    
    此外，如果您正在使用 EclipseLink 并且想要输出 SQL 参数值，您可以将此属性添加到您的 persistence.xml 文件中：
    
        <property name="eclipselink.logging.parameters" value="true"/>
    
    `ative`为一个级别，例如`DEBUG`.

[Link 1]: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-programmatic
[Link 2]: http://wiki.eclipse.org/EclipseLink/Examples/JPA/Logging#Log_Level_Configuration
[Link 3]: http://openjpa.apache.org/builds/2.0.0/apache-openjpa-2.0.0/docs/manual/ref_guide_logging_openjpa.html
[Link 4]: http://www.datanucleus.org/products/accessplatform_4_1/logging.html