Fixing javaee-samples#32

arun-gupta · arun-gupta · commit 198804887f04 · 2013-11-11T12:18:42.000+01:00
diff --git a/batch/chunk-csv-database/src/main/java/org/javaee7/batch/chunk/csv/database/Person.java b/batch/chunk-csv-database/src/main/java/org/javaee7/batch/chunk/csv/database/Person.java
@@ -43,6 +43,8 @@
 import javax.persistence.Basic;
 import javax.persistence.Column;
 import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
 import javax.persistence.Id;
 import javax.persistence.NamedQueries;
 import javax.persistence.NamedQuery;
@@ -62,14 +64,18 @@
     @NamedQuery(name = "Person.findByName", query = "SELECT c FROM Person c WHERE c.name = :name"),
     @NamedQuery(name = "Person.findByHiredate", query = "SELECT c FROM Person c WHERE c.hiredate = :hiredate")})
 public class Person implements Serializable {
-    private static final long serialVersionUID = 1L;
+
     @Id
+    @GeneratedValue(strategy = GenerationType.AUTO)
+    private int id;
+
+    private static final long serialVersionUID = 1L;
     @Basic(optional = false)
     @NotNull
     @Size(min = 1, max = 50)
     @Column(name = "NAME")
     private String name;
-    
+
     @Basic(optional = false)
     @NotNull
     @Size(min = 1, max = 50)
@@ -88,6 +94,14 @@ public Person(String name, String hiredate) {
         this.hiredate = hiredate;
     }
 
+    public int getId() {
+        return id;
+    }
+
+    public void setId(int id) {
+        this.id = id;
+    }
+
     public String getName() {
         return name;
     }
@@ -128,5 +142,5 @@ public boolean equals(Object object) {
     public String toString() {
         return name;
     }
-    
+
 }
diff --git a/batch/chunk-csv-database/src/main/resources/META-INF/create.sql b/batch/chunk-csv-database/src/main/resources/META-INF/create.sql
@@ -1 +1 @@
-CREATE TABLE CHUNK_CSV_DATABASE ("NAME" VARCHAR(50) not null primary key, "HIREDATE" VARCHAR(50) not null)
+CREATE TABLE CHUNK_CSV_DATABASE ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null primary key, "HIREDATE" VARCHAR(50) not null)

Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-CREATE TABLE CHUNK_CSV_DATABASE ("NAME" VARCHAR(50) not null primary key, "HIREDATE" VARCHAR(50) not null)`
	`1`	`+CREATE TABLE CHUNK_CSV_DATABASE ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null primary key, "HIREDATE" VARCHAR(50) not null)`