[jira] [Created] (ARIES-1919) JPA connection closing over night and not reconnecting next day?

["Alex Weirig (JIRA)" <ji...@apache.org>]

Alex Weirig created ARIES-1919:
----------------------------------

             Summary: JPA connection closing over night and not reconnecting next day?
                 Key: ARIES-1919
                 URL: https://issues.apache.org/jira/browse/ARIES-1919
             Project: Aries
          Issue Type: Bug
          Components: JPA, tx-control
    Affects Versions: tx-control-1.0.1, jpa-2.7.2
         Environment: This is the list of bundles I installed to use JPA:
bundle:install -s mvn:org.apache.geronimo.specs/geronimo-jta_1.1_spec/1.1.1
bundle:install -s mvn:org.osgi/org.osgi.service.jdbc/1.0.0
bundle:install -s mvn:org.apache.felix/org.apache.felix.coordinator/1.0.2
bundle:install -s mvn:org.apache.aries.jpa.javax.persistence/javax.persistence_2.1/2.7.2
bundle:install -s mvn:org.apache.aries.jpa/org.apache.aries.jpa.api/2.7.2
bundle:install -s mvn:org.apache.aries.jpa/org.apache.aries.jpa.container/2.7.2
bundle:install -s mvn:org.apache.aries.jpa/org.apache.aries.jpa.support/2.7.2
bundle:install -s mvn:org.apache.felix/org.apache.felix.configurator/1.0.6
 
bundle:install -s mvn:org.apache.aries.tx-control/tx-control-provider-jpa-xa/1.0.1
bundle:install -s mvn:org.apache.aries.tx-control/tx-control-service-xa/1.0.1
bundle:install -s mvn:org.postgresql/postgresql/42.2.5
bundle:install -s mvn:org.hibernate/hibernate-osgi/5.2.12.Final
bundle:install -s mvn:org.hibernate/hibernate-core/5.2.9.Final
bundle:install -s mvn:org.osgi/org.osgi.service.jdbc/1.0.0
bundle:install -s mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.antlr/2.7.7_5
bundle:install -s mvn:com.fasterxml/classmate/1.3.3
bundle:install -s mvn:org.javassist/javassist/3.21.0-GA 
bundle:install -s mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.dom4j/1.6.1_5
bundle:install -s mvn:org.hibernate.common/hibernate-commons-annotations/5.0.1.Final
bundle:install -s mvn:org.jboss/jandex/2.0.3.Final
            Reporter: Alex Weirig
         Attachments: configuration.json, jpa_service_list.txt, jpa_stacktrace.txt, persistence.xml

Hello,

I'm facing an issue using Apache Aries JPA in an OSGi R7 enroute based application.

I've tried to follow the same approach as explained in the enroute tutorials to use JPA with TX control. I'm using karaf as runtime.

When I start my karaf and I connect to the database everything is working fine and I can work with the application all day long. The next day, when I try to read from the database, I get a stacktrace saying the connection is closed.

I'm not sure how I can control how the runtime handles connection opening and closing in the pool. I was expecting that if the connection got closed over night, the runtime would reopen it or use a new one from the pool?

I'm attaching a bunch of files, hopefully this can help identifying what I'm missing.

Many thanks in advance for your support.

Regards,

Alex

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)