Effective pattern for data access with JPA

Posted: May 5th, 2011 | Author: | 4 Comments »

Since Java EE 6 is out, many of patterns and blueprints that were described with J2EE are deprecated. The main reason is due to the new architecture offers new components that simplify the development. One of these components is EntityManager, which can be consider as the implementation of DAO pattern. This object provides us common functions to operate with our model in a relational database. Some of these functions are save, retrieve, update and delete entities, that is, tipical CRUD operations.

Where is the problem?

It all depends on how you layerizer your application. Many of code that you can see about data access with JPA uses the EntityManager injected directly in the business objects or web controllers. In my opinion, with this approach couples too much the business logic with the technology used in the persistence layer. Think for a moment that an entire application developed by using this way has serious performance problems and the reponsible determines to move the persistence layer to NoSql approach, this decision would mean having to change this reference from every class. As you can see, it would mean an unbelievable effort.

Creating the indirection

First of all, the idea of using a facade to access JPA looks mandatory if we want to uncouple the technology with the data access. In this line, the next interface is proposed:

public interface PersistenceService<K, E> {

	E save(E entity);

	E update(E entity);

	void remove(E entity);

	E findById(K id);

	List<E> findAll();

	Long getTotalResult();

By using Java Generics this interface provides the common operation with entities. Each class that implements this interface have to indicate what the type of entity it manages E and the type of identificator K. Obviously, this class will have to implement the methods too 😀

Now, we have to define abstract classes either for the entities or for persistence services. These abstract classes help us to put in the same location all the common code, leaving the concrete classes that they implements only the specific code.

In JPA to model entities, we need a classes with Entity annotation, but there is some code that is mandatory in each entity, for example the identificator. In addition, we use named queries for those queries that are typical in any scenario, so the entities need the constants for these named queries. The abstract entity is as follow:

@Inheritance(strategy = InheritanceType.JOINED)
public abstract class AbstractEntity implements Serializable {
    public static final String FIND_ALL = "Entity.findAll";
    public static final String TOTAL_RESULT = "Entity.totalResult";
    private static final long serialVersionUID = 1L;
    @GeneratedValue(strategy = GenerationType.AUTO)
    protected Long id;
    // Getters and Setters    

With @MappedSuperclass and @Inheritance we indicates that this class doesn’t have to be mapped to a table and the constants will be used in the named queries. Due to JPA 2.0 doesn’t allow inheritance for named queries, these two queries will be defined in each specific entity.

Now, the code for the abstract persistence service. This class performs the CRUD operations through the EntityManager. The code is:

public abstract class AbstractJPAPersistenceService<K, E extends AbstractEntity> implements PersistenceService<K, E> {

    protected Class<E> entityClass;

    protected EntityManager em;

    public void init() {
        ParameterizedType genericSuperclass = (ParameterizedType) getClass().getGenericSuperclass();
        this.entityClass = (Class<E>) genericSuperclass.getActualTypeArguments()[1];

    public E save(final E entity) {
        return entity;

    public E update(final E entity) {
        return em.merge(entity);

    public void remove(final E entity) {

    public E findById(final K id) {
        return em.find(entityClass, id);

    public List<E> findAll() {
        return em.createNamedQuery(AbstractEntity.FIND_ALL).getResultList();
    public Long getTotalResult() {
        return (Long) em.createNamedQuery(AbstractEntity.TOTAL_RESULT).getSingleResult();

With this class, each subclass just implements its specific method for queries. Perhaps, the most important part is in the method init() where the entity class is created by using reflection through generic values. Due to the idea is to expose the persistence services as EJB, this method is annotated with @PostConstruct that is called each time its subclass is injected. Furthermore, the queries are implemented with the constants declared in the AbstractEntity, the query will be defined in the specific entity.

Implementing an example

Ok, the skeleton for persistence services is ready, just need to use in a real scenario. In this case, to show how easy it is to use this “pattern”, the example is about the Book entity.

    @NamedQuery(name = Book.FIND_ALL, query = "select b from Book b"),
    @NamedQuery(name = Book.TOTAL_RESULT, query = "select count(b) from Book b"),
    @NamedQuery(name = Book.FIND_BY_TITLE, query = "select b from Book b where b.title = :title"),
    @NamedQuery(name = Book.FIND_BY_ISBN, query = "select b from Book b where b.isbn = :isbn")
public class Book extends AbstractEntity {
    public static final String FIND_BY_TITLE = "Book.findByTitle";
    public static final String FIND_BY_ISBN = "Book.findByISBN";
    private String title;
    private String description;
    private String isbn;

    // Getters and Setters

The code is quite basic: declaration of attributes (fields in the table), specific queries and named queries with @NamedQueries.

Finally, the implementation of PersistenceService to manage books is as follow:

public class BookPersistenceService extends AbstractJPAPersistenceService<Long, Book> {

    public List<Book> findByTitle(String title) {
        return em.createNamedQuery(Book.FIND_BY_TITLE).setParameter("title", title).getResultList();
    public List<Book> findByISBN(String isbn) {
        return em.createNamedQuery(Book.FIND_BY_ISBN).setParameter("isbn", isbn).getResultList();

As you can see, the code is very light because the complexity is in AbstractJPAPersistenceService. To use this service, just inject it in your business logic.

Tags: , , , ,

Java EE 7 – Promises and wishes

Posted: March 7th, 2011 | Author: | No Comments »

Oracle has approved the JSR-342 specification where the new features of this platform will be described. This spec will focus on cloud scenarios and therefore, I think that many of its improvements are related with scalability, high performance and massive data treatment.

Some changes that will be included in this spec are:

  • HTML5 support – improve of Servlet by including WebSocket API.
  • Updated some technologies already included – such as CDI, EJB, JPA, JSF, JMS, JAX-RS, JAX-WS, etc.
  • Inclusion of JCache – it was time to have a standard to cache in Java EE.
  • Pruning of some deprecated technology – such as EJB Entity Beans or JAX-RPC 1.1.

And in my wishlist for this specification I propose the next ones:

  • NoSQL support – currently JPA just covers the relational databases and with the increase of this kind of storage (non-relational and distributed systems) I think that JEE7 should play in this league by providing an ORM for systems as Cassandra, MongoDB, CouchDB, etc.
  • Business process – the usage of process modeling with PDL, BPMN or BPEL is well known in the software development and Java EE doesn’t provide any solution to tackle with these laguages. So far, tools like JBPM make easy the integration between process or workflows and enterprise software, JEE7 would have to say something about this.
  • Modular development – WAB support enhancements (allowing OSGi bundles with entities that automatically are mapped to database tables) something like JBoss Modules.
  • Web layer – page flow manager like Seam system, cool uris like PrettyFaces, improvements such as Comet in JSF or HTML5 WebSQL support.

Tags: , , ,