Simple Example

3.1. Project and Entity

Create a Java Project "sawan.modi.jpa.simple". Create a folder "lib" and place the required JPA jars and derby.jar into this folder.

Afterwards create the package "sawan.modi.jpa.simple.model" and create the following classes.

    
package sawan.modi.jpa.simple.model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class Todo {
 @Id
 @GeneratedValue(strategy = GenerationType.IDENTITY)
 private Long id;
 private String summary;
 private String description;

 public String getSummary() {
  return summary;
 }

 public void setSummary(String summary) {
  this.summary = summary;
 }

 public String getDescription() {
  return description;
 }

 public void setDescription(String description) {
  this.description = description;
 }

 @Override
 public String toString() {
  return "Todo [summary=" + summary + ", description=" + description
    + "]";
 }

}

   

3.2. Persistence Unit

Create a directory "META-INF" in your "src" folder and create the file "persistence.xml". This examples uses EclipseLink specific flags for example via the parameter "eclipselink.ddl-generation" you specify that the database scheme will be automatically dropped and created.

    

 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
 version="2.0" xmlns="http://java.sun.com/xml/ns/persistence">
 
  sawan.modi.jpa.simple.model.Todo
  
   
       value="jdbc:derby:/home/vogella/databases/simpleDb;create=true" />
   
   

   
   
       value="database" />
  

 


   

The database specified via "javax.persistence.jdbc.url" will be automatically created by the Derby Driver. You may want to adjust the path, it currently is based on Linux notations and points to my home directory on my Linux system.

To see the SQL generated for the the databases set eclipselink.ddl-generation.output-mode value from "database" to "sql-script" or "both". Two files will get generated 'createDDL.jdbc' and 'dropDDL.jdbc'

3.3. Test your installation

Create the following Main class which will create a new entry every time it it called. After the first call you need to remove the property "eclipselink.ddl-generation" from persistence.xml otherwise you will receive an error as EclipseLink tries to create the database scheme again. Alternative you could set the property to "drop-and-create-tables" but this would drop your database schema at every run.

    
package sawan.modi.jpa.simple.main;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;

import sawan.modi.jpa.simple.model.Todo;

public class Main {
 private static final String PERSISTENCE_UNIT_NAME = "todos";
 private static EntityManagerFactory factory;

 public static void main(String[] args) {
  factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
  EntityManager em = factory.createEntityManager();
  // Read the existing entries and write to console
  Query q = em.createQuery("select t from Todo t");
  List todoList = q.getResultList();
  for (Todo todo : todoList) {
   System.out.println(todo);
  }
  System.out.println("Size: " + todoList.size());

  // Create new todo
  em.getTransaction().begin();
  Todo todo = new Todo();
  todo.setSummary("This is a test");
  todo.setDescription("This is a test");
  em.persist(todo);
  em.getTransaction().commit();

  em.close();
 }
}

   

Run you program several times to see that the database is filled.