OpenJPA 输出 SQL 日志和使用连接池的方法

关注

转载最新推荐文章于 2025-10-04 21:03:27 发布 3.2k 阅读 AI 写同款· GEO 优化 ›

使用OpenJPA进行Java API开发中的数据持久化接下来，我们需要定义持久化实体类，这些类将映射到数据库表。例如，假设我们有一个名为User的实体类，包含id和nameEntity;Id;@Entity@Id// ...在上述代码中，我们使用了@Entity注解将该类标记为一个持久化实体。@Id注解指定了该类的id属性为主键，并且使用了注解指定了主键的生成策略为自增长。阅读详情

How do I see the SQL that OpenJPA is executing?

OpenJPA provides configurable channel-based logging, as described in the chapter on Logging. The simplest example of enabling verbose logging is by using the following property in your persistence.xml file:

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    version="1.0">
    <persistence-unit name="example-logging" transaction-type="RESOURCE_LOCAL">
        <properties>
            <property name="openjpa.Log" value="SQL=TRACE"/>
        </properties>
    </persistence-unit>
</persistence>

How do I enable connection pooling in OpenJPA?

OpenJPA doesn't include any built-in connection pool, but you can use any third-party connection pool that is configurable via the JDBC DataSource API (which most are). The following persistence.xml example shows how to use OpenJPA with a Apache Derby database and the Apache DBCP connection pool:

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    version="1.0">
    <persistence-unit name="example-derby" transaction-type="RESOURCE_LOCAL">
        <properties>
            <property name="openjpa.ConnectionProperties" 
                value="DriverClassName=org.apache.derby.jdbc.ClientDriver,
                  Url=jdbc:derby://localhost:1527/database, 
                  MaxActive=100, 
                  MaxWait=10000, 
                  TestOnBorrow=true, 
                  Username=user, 
                  Password=secret"/>
            <property name="openjpa.ConnectionDriverName" 
                value="org.apache.commons.dbcp.BasicDataSource"/>
        </properties>
    </persistence-unit>
</persistence>

See the documentation on Using a Third-Party DataSource for further details.

收录于