wildfly-SWARM中使用postgresql的连接池

Question

我使用postgres、wildfly-swarm、hibernate，我的事务是bean管理的。

my Project-defaults.yml datasources：data-sources：part

 Adadawdadsa:
   driver-name: postgresql
   connection-url: dadadasdadas
   user-name: aawdwaasda
   password: waddsawdas
   jta: true
   use-java-context: true
   pool-name: awdasdadwaadads
   min-pool-size: 10
   initial-pool-size: 15
   max-pool-size: 40
   pool-prefill: false
   validate-on-match: true
   use-fast-fail: false
   connection-checker-class-name: org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker
   check-valid-connection-sql: "SELECT 1;"
   exception-sorter-class-name: org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter
   connection-properties: CharacterEncoding/ UTF-8 UseUnicode/true

在模拟应用程序和postgres之间的连接丢失（关闭DB、iptables丢弃数据包等，然后执行一些请求，然后再次启动DB或清除iptables丢弃规则）后，DB已启动，但Hibernate/Swarm无法再找到连接...有人能告诉我我做错了什么吗？

编辑：添加堆栈跟踪

null

编辑：添加了persistence.xml

<persistence-unit transaction-type="JTA" name="dadsadsadsa">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <jta-data-source>java:jboss/datasources/dadsadsadsaas</jta-data-source>
    <properties>
        <property name="hibernate.show_sql" value="false"/>
        <property name="hibernate.id.new_generator_mappings" value="false"/>

        <property name="db.migration.action" value="validate-migrate"/>
        <property name="db.migration.sql.prefix" value="adadsadsadsa-"/>
    </properties>
</persistence-unit>

Answer 1

Hibernate的内部连接池算法是初步的，是为开发和测试目的提供的。使用第三方池以获得最佳性能和稳定性。

要了解更多详细信息，请参阅有关连接池的参考资料。我发现它有用。

-

>

获取Hibernate-C3P0.jar
要将c3p0与Hibernate集成，需要从JBoss存储库获取Hibernate-C3P0.jar。pom.xml

null

JBoss存储库http://repository.JBoss.org/nexus/content/groups/public/

null

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>3.6.3.Final</version>
</dependency>

<!-- Hibernate c3p0 connection pool -->
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-c3p0</artifactId>
    <version>3.6.3.Final</version>
</dependency>

配置c3p0属性配置c3p0，将c3p0配置详细信息放在“persistence.xml”中，如下所示：

...
<properties>
  <!-- Configuring JDBC properties -->
  <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost/jpa_example" />
  <property name="javax.persistence.jdbc.user" value="root" />
  <property name="javax.persistence.jdbc.password" value="my_root_password" />
  <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />

  <!-- Hibernate properties -->
  <property name="hibernate.show_sql" value="true" />
  <property name="hibernate.format_sql" value="true" />
  <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
  <property name="hibernate.hbm2ddl.auto" value="validate" />

  <!-- Configuring Connection Pool -->
  <property name="hibernate.c3p0.min_size" value="5" />
  <property name="hibernate.c3p0.max_size" value="20" />
  <property name="hibernate.c3p0.timeout" value="500" />
  <property name="hibernate.c3p0.max_statements" value="50" />
  <property name="hibernate.c3p0.idle_test_period" value="2000" />
</properties>

也许C3P0-JDBC3连接和语句池引用也会有帮助。