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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: jpa-2.7.2, tx-control-1.0.1
• Component/s: JPA, tx-control
• Labels: OSGi

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

• Assignee: Unassigned
• Reporter: Alex Weirig
• Created: 08/Jul/19 06:22
• Updated: 08/Jul/19 06:22

Description

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