= OpenJPA
:index-group: JPA
:jbake-date: 2018-12-05
:jbake-type: page
:jbake-status: published

OpenJPA is bundled with OpenEJB as the default persistence provider.

An example of working `persistence.xml` for OpenJPA:

[source,xml]
----
<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">

  <persistence-unit name="movie-unit">
    <jta-data-source>movieDatabase</jta-data-source>
    <non-jta-data-source>movieDatabaseUnmanaged</non-jta-data-source>
    <class>org.superbiz.injection.jpa.Movie</class>

    <properties>
      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
    </properties>
  </persistence-unit>
</persistence>
----

Where the datasources above are configured in your openejb.xml as
follows:

[source,xml]
----
<Resource id="movieDatabase" type="DataSource">
  JdbcDriver = org.hsqldb.jdbcDriver
  JdbcUrl = jdbc:hsqldb:mem:moviedb
</Resource>

<Resource id="movieDatabaseUnmanaged" type="DataSource">
  JdbcDriver = org.hsqldb.jdbcDriver
  JdbcUrl = jdbc:hsqldb:mem:moviedb
  JtaManaged = false
</Resource>
----

Or in properties as follows:

[source,java]
----
p.put("movieDatabase", "new://Resource?type=DataSource");
p.put("movieDatabase.JdbcDriver", "org.hsqldb.jdbcDriver");
p.put("movieDatabase.JdbcUrl", "jdbc:hsqldb:mem:moviedb");

p.put("movieDatabaseUnmanaged", "new://Resource?type=DataSource");
p.put("movieDatabaseUnmanaged.JdbcDriver", "org.hsqldb.jdbcDriver");
p.put("movieDatabaseUnmanaged.JdbcUrl", "jdbc:hsqldb:mem:moviedb");
p.put("movieDatabaseUnmanaged.JtaManaged", "false");
----

== Common exceptions

=== Table not found in statement

Or as derby will report it "Table 'abc.xyz' doesn't exist"

Someone has to create the database structure for your persistent
objects. If you add the _openjpa.jdbc.SynchronizeMappings_ property as
shown below OpenJPA will auto-create all your tables, all your primary
keys and all foreign keys exactly to match your objects.

[source,xml]
----
<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">

 <persistence-unit name="movie-unit">
   <!-- your other stuff -->

   <properties>
     <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
   </properties>
 </persistence-unit>
</persistence>
----

== Auto-commit can not be set while enrolled in a transaction

Pending

== This broker is not configured to use managed transactions.

=== Setup

Using a EXTENDED persistence context ...

[source,java]
----
@PersistenceContext(unitName = "movie-unit", type = PersistenceContextType.EXTENDED)
EntityManager entityManager;
----

on a persistence unit setup as RESOURCE_LOCAL ...

[source,xml]
----
<persistence-unit name="movie-unit" transaction-type="RESOURCE_LOCAL">
  ...
</persistence-unit>
----

inside a transaction.

[source,java]
----
@TransactionAttribute(TransactionAttributeType.REQUIRED)
public void addMovie(Movie movie) throws Exception {
    entityManager.persist(movie);
}
----

Note the default transaction attribute for any ejb method is REQUIRED
unless explicitly set otherwise in the bean class or method in question.

=== Solutions

You can either:

[arabic]
. Change your bean, or it's method to use
`TransactionAttributeType.NOT_REQUIRED` or
`TransactionAttributeType.NEVER` which will guarantee it will not be
invoked in a JTA transaction.
. Change your `persistence.xml` so the persistence-unit uses
`transaction-type="TRANSACTION"` making it capable of participating in a
JTA transaction.
