A JPA Entity is a class which represents persistent data stored in a database.

In most cases a concrete or an abstract class can be an Entity. Entity classes support mixed inheritance: the superclass and/or subclass of an Entity does not have to be an Entity.

Any application-defined object with the following characteristics can be an Entity:

• It can be made persistent,
• It has a persistent identity (i.e. a unique key),
• It is not a primitive, a primitive wrapper of build-in object.

All Entities must have a persistent id (i.e. a database primary key). This is known as the entity identity (or persistence identity). JPA supports the following entity identities:

• Single field identity (like our long uidPk field).
• Composite primary keys (provided by an Identity class),

The Entity identity must be defined on the root entity or mapped superclass of the hierarchy. Elastic Path's domain model defines the uidPk on the Persistable interface. Persistable classes need to implement the getUidPk() method with the @Id annotation and setUidPk() method.

JPA supports several strategies for primary key generation:

• Auto - leave the decision up to the JPA implementation.
• Identity - the database will assign an identity value on insert.
• Sequence - use a datastore sequence to generate a value.
• Table - use a sequence table to generate a field value.

Elastic Path's domain model uses the Table generator. Table works with all databases, and offers the best overall performance. Elastic Path's persistence classes defines the generator table JPA_GENERATED_KEYS with the columns ID and LAST_VALUE, a name and primary key value matching the name of the database table that the class will be persisted to. JPA uses this table to keep track of the last identifier value used to ensure the next one used is unique. You can configure the number of values to allocate in memory for each trip to the database (the default is 50). Allocating values in memory allows the JPA runtime to avoid accessing the database for every sequence request.

The annotations on the getUidPk() method are as follows:

@Id
@Column(name = "UIDPK")
@GeneratedValue(strategy = GenerationType.TABLE, generator = TABLE_NAME)
@TableGenerator(name = TABLE_NAME, table = "JPA_GENERATED_KEYS",
                pkColumnName = "ID", valueColumnName = "LAST_VALUE", pkColumnValue = TABLE_NAME)

In the <properties> element of jpa-persistence.xml, you can set a number of different properties. By default, Elastic Path sets the following:

                core/ep-core/src/main/resources/META-INF/jpa-persistence.xml
	<properties>
		<property name="openjpa.DataCacheManager" value="ehcache" />
		<property name="openjpa.ConnectionFactoryName" value="java:comp/env/jdbc/epjndi"/commerce-legacy/>
		<property name="openjpa.Log" value="slf4j"/commerce-legacy/>
		<property name="openjpa.ConnectionFactoryProperties" value="PrettyPrint=true, PrettyPrintLineLength=120, PrintParameters=true"/commerce-legacy/>
		<property name="openjpa.jdbc.EagerFetchMode" value="parallel"/commerce-legacy/>
		<property name="openjpa.jdbc.SubclassFetchMode" value="parallel"/commerce-legacy/>
		<property name="openjpa.DetachState" value="loaded(DetachedStateField=true,AccessUnloaded=false)"/commerce-legacy/>
		<property name="openjpa.Multithreaded" value="true"/commerce-legacy/>
		<property name="openjpa.AutoDetach" value="close, commit, nontx-read"/commerce-legacy/>
		<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100, SupportsSubselect=true, SupportsCorrelatedSubselect=false"/commerce-legacy/>
		<property name="openjpa.jdbc.TransactionIsolation" value="read-committed"/commerce-legacy/>
	
		<!-- Uncomment the section below to enable data caching, comment them out to disable -->
		<property name="openjpa.DataCache" value="true"/commerce-legacy/>
		<property name="openjpa.RemoteCommitProvider" value="sjvm"/commerce-legacy/>
		<property name="openjpa.QueryCompilationCache" value="true(cacheSize=5000,softReferenceSize=0)"/commerce-legacy/>
		<property name="openjpa.jdbc.FinderCache" value="false"/commerce-legacy/>
			
		<property name="openjpa.QueryCache" value="false"/commerce-legacy/>
		<property name="openjpa.jdbc.QuerySQLCache" value="false"/commerce-legacy/>
			
		<!-- OpenJPA 2.x compatibility against spec -->
		<property name="openjpa.Compatibility"
				value="convertPositionalParametersToNamed=true,ignoreDetachedStateFieldForProxySerialization=true"/commerce-legacy/>
			
		<!-- Pre-Load Metadata -->
		<property name="openjpa.MetaDataRepository" value="Preload=true"/commerce-legacy/>
	</properties>
               

The following table gives a brief summary of OpenJPA properties and their purposes:

Most annotations are placed directly into the class files of the objects to be persisted. This makes it easy to maintain consistency between the objects and their persistence definition: there is no need to go find the "mapping file". Annotations are generally quicker to type than XML mapping definitions and IDEs support annotations including syntax checking and auto-completion. The exception to the rule is annotations that define named queries (see below).

Annotations can be at the field level, where the persistence layer writes directly to the field, or at the property level, where the persistence layer uses the getter and setter methods. You cannot mix field and property level annotations within the same class hierarchy.

As a standard, our object model uses property level annotations. The annotations in the class files are written above the getter method for each property.

Here's a list of some of the more common simple annotations:

Note that properties in a class defined as an Entity that do not have any annotations may still be treated as persistable depending on the type. To avoid any confusion, ensure you annotate all property getters including @Basic and @Transient properties.

The following lists of some of the annotations commonly used for mapping relationships in JPA:

JPA provides two annotations for supporting inheritance:

OpenJPA provides some useful annotations in addition to those provided by the JPA specification. Many of these are used by Elastic Path due to the complexity of the domain object model. Commonly used OpenJPA-specific are as follows:

Below is an example of an annotated class file which shows many of the annotation types in use:

@Entity
@Table(name = "TPRODUCT")
public class ProductImpl extends AbstractEntityImpl implements Product {

  ...

  @Basic
  @Column(name = "START_DATE")
  public Date getStartDate() {
    return this.startDate;
  }

  @Version
  @Column(name = "LAST_MODIFIED_DATE")
  @Temporal(TemporalType.TIMESTAMP)
  public Date getLastModifiedDate() {
    return lastModifiedDate;
  }

  @ManyToOne(targetEntity = ProductTypeImpl.class)
  @JoinColumn(name = "PRODUCT_TYPE_UID")
  public ProductType getProductType() {
    return this.productType;
  }

  @Transient
  public ProductSku getDefaultSku() {
    if (defaultSku == null && productSkus != null && productSkus.size() > 0) {
      return (ProductSku) productSkus.values().iterator().next();
    }
    return defaultSku;
  }

  @OneToMany(targetEntity = ProductPriceImpl.class,
             cascade = { CascadeType.PERSIST, CascadeType.REMOVE })
  @MapKey(name = "currencyCode")
  @ElementJoinColumn(name = "PRODUCT_UID")
  public Map getProductPrices() {
    return productPrices;
  }

  ...

}

JPQL executes over the abstract persistence schema (the entities you've created) defined by your persistence unit, rather than over the database like traditional SQL. JPQL supports a SQL-like syntax, and dynamic and static (named) queries.

Below is an example of a JPQL query:

SELECT [PD:<result>]
    [PD:FROM <candidate-class(es)>]
    [PD:WHERE <filter>]
    [PD:GROUP BY <grouping>]
    [PD:HAVING <having>]
    [PD:ORDER BY <ordering>]

Below is a simple query for all CategoryTypeImpl entities:

SELECT ct FROM CategoryTypeImpl ct

The optional where clause places criteria on matching results, for example:

SELECT j FROM ImportJobImpl j WHERE j.name = '01-SnapItUp'

You can also specify parameters, for example:

SELECT c FROM CategoryImpl c WHERE c.code = ?1

JPQL queries may specify one or more join fetch declarations, which allow the query to specify which fields in the returned instances will be pre-fetched

SELECT ct FROM CategoryTypeImpl ct JOIN FETCH ct.categoryAttributeGroupAttributes

Multiple fields may be specified in separate join fetch declarations. You may want to use other join types depending on the data, e.g. left outer join fetch.

JPA supports named queries. While named queries can be defined in the annotations of a class – usually the class in which the named query is most relevant – they can also be defined external to the implementation class source files in XML files. In this case, each Java package has its own named queries XML file in the following location: META-INF/ <packagename>-orm.xml.. This is useful for keeping all the named queries specific to a package in the same place while allowing easier extensibility, so that queries can be modified without requiring the application to be recompiled.

Here is an example of named queries in an XML file:

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" 
    version="1.0">
    <package>com.elasticpath.domain.customer.impl</package>
    <entity class="CustomerDeletedImpl">
        <named-query name="CUSTOMER_UIDS_SELECT_BY_DELETED_DATE">
            <query>select pd.customerUid from CustomerDeletedImpl as pd where pd.deletedDate &gt;= ?1</query>
        </named-query>
    </entity>
    <entity class="CustomerGroupImpl">
        <named-query name="CUSTOMERGROUP_SELECT_ALL">
            <query>select cg from CustomerGroupImpl cg</query>
        </named-query>
        <named-query name="CUSTOMERGROUP_FIND_BY_NAME">
            <query>select cg from CustomerGroupImpl cg where cg.name = ?1</query>
        </named-query>
    </entity>
</entity-mappings>

One of the key interfaces in the Java Persistence API is the EntityManager. This is similar to Hibernate's Session interface, providing services for CRUD operations (persist, remove, find, merge etc), creating Query instances and interfacing to the Transaction API.

Spring provides JPA integration, implementing JPA Container responsibilities. It includes beans like LocalEntityManagerFactoryBean which make it easy to configure the Entity Manager Factory through Spring configuration files, and SharedEntityManagerBean which provides a shared EntityManager reference.

Elastic Path integrates JPA with its core persistence model. In general, Elastic Path uses Spring Inversion of Control and Dependency Injection when possible.

Elastic Path provides the following classes for persistence. You can find these in the com.elasticpath.persistence.openjpa.impl package of ep-persistence-openjpa.

The majority of the time you'll just use the persistence-api PersistenceEngine interface, and configure Spring to inject the JPA implementation, so your code generally doesn't need to know anything about JPA.

JPA does not support the Locale and Currency types so some special OpenJPA annotations are required when using these datatypes.

For example, here are annotated getters for Locale and Currency fields:

@Persistent(optional = false)
  @Externalizer("toString")
  @Factory("org.apache.commons.lang.LocaleUtils.toLocale")
  @Column(name = "LOCALE", length = 20)
  public Locale getLocale() {
    return locale;
  }

  @Persistent
  @Column(name = "CURRENCY", length = 3)
  @Externalizer("getCurrencyCode")
  @Factory("com.elasticpath.commons.util.impl.UtilityImpl.currencyFromString")
  public Currency getCurrency() {
    return currency;
  }

This tells JPA the externalizer method to use to convert the field into its external form for database storage (eg getCurrencyCode()) for Currency), and to the full class and method to instantiate the field from the external form stored in the database.

Like Locale and Currency, extensible enums use the Externalizer and Factory annotations for conversion:

/**
* Get the status of the order.
*
* @return the order status
*/
@Override
@Persistent(optional = false)
@Column(name = "STATUS")
@Externalizer("getName")
@Factory("valueOf")
public OrderStatus getStatus() {
   return status;
}
            

JPA requires all entities to have a default constructor which it will call when the persistence layer starts up. If there is no default constructor the build-time enhancer will add one.

Be careful if your constructor expects other objects to be previously instantiated. For example:

public ShoppingCartImpl() {
  super();
  this.shippingServiceLevelList = new ArrayList();
  this.viewHistory = (ViewHistory) getElasticPath().getBean("viewHistory");
}

The above is an old snippet from ShoppingCartImpl which has been re-implemented as a JPA Entity. Before this class was annotated as a JPA Entity, the constructor wasn't being called until the ElasticPathImpl bean factory added a bean for ShoppingCartImpl, so the call to getElasticPath() would always work. However, once this class was added to the list of persistence entities, the constructor was being called before ElasticPathImpl was being instantiated, so the call to getElasticPath() would fail.

The work around is to put any code in the constructor that relies on other objects in a more appropriate place. In this particular case the code to get the viewHistory bean was moved into the getViewHistory method of ShoppingCartImpl.

The mapping tool can generate a schema from your object model. It is very useful for checking if your annotations map the object(s) to the current schema, or for generating the SQL if you add a new object.

You can run the tool by calling the following Maven command in the ep-core directory:

mvn -Dopenjpa.ConnectionDriverName=com.mysql.jdbc.Driver openjpa:sql

The generated file, database.sql, can be found in ep-core/target.