Removing load.sql as data needs to be persisted using EntityManager.persist instead of INSERT INTO. This allows the version column to be updated for optimistic locking to work. EclipseLink was lenient about it but Hibernate caught it.

arun-gupta · arun-gupta · commit 460d922e5167 · 2013-10-30T06:06:43.000-07:00
diff --git a/jpa/locking-optimistic/src/main/java/org/javaee7/jpa/locking/optimistic/MovieBean.java b/jpa/locking-optimistic/src/main/java/org/javaee7/jpa/locking/optimistic/MovieBean.java
@@ -53,6 +53,17 @@ public class MovieBean {
 
     @PersistenceContext
     EntityManager em;
+    
+    public void addMovies() {
+        Movie[] movies = new Movie[4];
+        movies[0] = new Movie(1, "The Matrix", "Keanu Reeves, Laurence Fishburne, Carrie-Ann Moss");
+        movies[1] = new Movie(2, "The Lord of The Rings", "Elijah Wood, Ian Mckellen, Viggo Mortensen");
+        movies[2] = new Movie(3, "Inception", "Leonardo DiCaprio");
+        movies[3] = new Movie(4, "The Shining", "Jack Nicholson, Shelley Duvall");
+        for (Movie m : movies) {
+            em.persist(m);
+        }
+    }
 
     public List<Movie> listMovies() {
         return em.createNamedQuery("Movie.findAll", Movie.class).getResultList();
diff --git a/jpa/locking-optimistic/src/main/java/org/javaee7/jpa/locking/optimistic/TestServlet.java b/jpa/locking-optimistic/src/main/java/org/javaee7/jpa/locking/optimistic/TestServlet.java
@@ -78,6 +78,7 @@ protected void processRequest(HttpServletRequest request, HttpServletResponse re
             out.println("<body>");
             out.println("<h1>Servlet TestServlet at " + request.getContextPath() + "</h1>");
 
+            bean.addMovies();
             out.println("Listing movies<br>");
             for (Movie m : bean.listMovies()) {
                 out.println(m.getName() + "<br>");
diff --git a/jpa/locking-optimistic/src/main/resources/META-INF/load.sql b/jpa/locking-optimistic/src/main/resources/META-INF/load.sql
diff --git a/jpa/locking-optimistic/src/main/resources/META-INF/persistence.xml b/jpa/locking-optimistic/src/main/resources/META-INF/persistence.xml
@@ -8,7 +8,6 @@
         <properties>
             <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
             <property name="javax.persistence.schema-generation.create-source" value="metadata"/>
-            <property name="javax.persistence.sql-load-script-source" value="META-INF/load.sql"/>
         </properties>
     </persistence-unit>
 </persistence>
