content/openjpa.mdtext

Title: OpenJPA
OpenJPA is bundled with OpenEJB as the default persistence provider.

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

    <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:
    
    <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:

    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.
    
    <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>


<a name="OpenJPA-Auto-commitcannotbesetwhileenrolledinatransaction"></a>
## Auto-commit can not be set while enrolled in a transaction

Pending

<a name="OpenJPA-Thisbrokerisnotconfiguredtousemanagedtransactions."></a>
## This broker is not configured to use managed transactions.

<a name="OpenJPA-Setup"></a>
### Setup

Using a EXTENDED persistence context ...

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

on a persistence unit setup as RESOURCE_LOCAL ...

    <persistence-unit name="movie-unit" transaction-type="RESOURCE_LOCAL">
      ...
    </persistence-unit>

    
inside of a transaction.

    @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.

<a name="OpenJPA-Solutions"></a>
### Solutions

You can either:

1. 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.
1. Change your persistence.xml so the persistence-unit uses `transaction-type="TRANSACTION"` making it capable of participating in a JTA transaction.