====== OSGi Container Managed JPA ======
There are some tutorials and chapters out there on the net which describe how to setup JPA in OSGi but most described setups are too simple and can't be used in production.
My requirements are
* Apache Karaf
* PostgreSQL
* JPA 2.0
* JTA
* Connection pool
* Configurable database connection properties
This article describes a working setup and starting point to build upon which doesn't necessarily mean that it is the best solution for everybody.
**This does not seem to work with nested transactions and OpenJPA 2.2.2!** Instead use PAX-JDBC.
===== Apache Karaf =====
I am using the current stable Apache Karaf 3 branch, Apache Karaf 3.0.3.
I install certain features which I need for my setup:
feature:install scr webconsole jndi jdbc
==== Installed Features ====
I later need to have the following features installed:
transaction | 1.1.1 | x | enterprise-3.0.3 | OSGi Transaction Manager
jpa | 2.0.0 | x | enterprise-3.0.3 | OSGi Persistence Container
openjpa | 2.2.2 | x | enterprise-3.0.3 | Apache OpenJPA 2.2.x persistence engine support
jndi | 3.0.3 | x | enterprise-3.0.3 | OSGi Service Registry JNDI access
jdbc | 3.0.3 | x | enterprise-3.0.3 | JDBC service and commands
===== JPA =====
Apache Karaf makes it very easy to add JPA support. Just install the feature:
feature:install jpa/2.0.0 openjpa/2.2.2
===== JTA =====
The transaction support is as easily installed as the JPA support.
feature:install transactions/1.1.1
==== Using Transactions ====
To use transactions in a service component and provide an ''EntityManager'' to that component the OSGi Blueprint service can be used. Just declare the Blueprint bean and expose it as an OSGi service.
===== PostgreSQL =====
PostgreSQL doesn't supply a bundle for its driver but luckily the Apache Service Mix project repackages the database driver. It can be retrieved from the standard Maven repository.
http://search.maven.org/#search%7Cga%7C1%7Corg.apache.servicemix.bundles.postgresql
The bundle just needs to be dropped into the deploy folder for deployment.
The bundle needs to be started prior to the JPA stuff so the bundle start level needs to be set to a lower value.
bundle:start-level 25
===== Data Sources =====
Data sources are created as OSGi services via blueprint. Create the ''blueprint.xml'' in a bundle in the folder ''OSGI-INF/blueprint''. This is the default location which can be configured in the MANIFEST.MF, see manifest file entry ''Bundle-Blueprint''.
==== Connection Pooling ====
I am using the PostgreSQL XA datasource as a base data source and configure the [[https://commons.apache.org/proper/commons-dbcp/apidocs/org/apache/commons/dbcp2/managed/BasicManagedDataSource.html | BasicManagedDataSource]] from the //commons-dbcp2// to use it as a data source for retrieving connections:
==== Configurable database connection properties ====
The database connection properties are configured via the OSGi ConfigAdmin service.
The configuration file ''sdm.persistence.database.cfg'' need to be created in the ''/etc'' folder.
service.pid=sdm.persistence.datasource
host=dbserver
database=dbname
user=dbuser
password=dbsecret
To tell blueprint to use the configuration from this configuration the following line was added to the ''blueprint.xml'' file.
Now the configuration can be accessed by its keys like ''${host}'' and it doesn't have to be packaged with the bundles.
Parameters like ''maxTotal'' and ''initialSize'' needs to be adjusted to the environment.
=== Needed Bundles ===
For connection pooling the projects ''commons-dbcp2'' and ''commons-pool2'' are needed which already package their software as bundles and can be retrieved from the standard Maven repository.
I have used
* commons-pool2 2.4.1
* commons-dbcp2 2.1
===== persistence.xml =====
org.apache.openjpa.persistence.PersistenceProviderImpl
osgi:service/jdbc/xasds
sdm.data.Entity
===== FAQ =====
==== Unsatisfied requirement(s): service:(service=javax.transaction.TransactionManager) ====
If the feature ''obr'' is installed prior to the installation of the feature ''openjpa'' it won't install the feature ''openjpa''.
karaf@root()> feature:install obr
karaf@root()> feature:install openjpa
Error executing command: Can't install feature openjpa/0.0.0:
Can not resolve feature:
Unsatisfied requirement(s):
---------------------------
service:(service=javax.transaction.TransactionManager)
Apache Aries Transaction Blueprint
===== Links =====
* [[http://karaf.apache.org | Apache Karaf]]
* [[http://search.maven.org | Search Maven Repository]]
* [[https://aries.apache.org | Apache Aries - OSGi Enterprise]]
{{tag>osgi karaf java}}