javaee-samples · johnament · Oct 5, 2014 · Jul 25, 2014 · Oct 4, 2014 · Oct 4, 2014
diff --git a/jpa/ordercolumn/pom.xml b/jpa/ordercolumn/pom.xml
@@ -0,0 +1,14 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+    <parent>
+        <groupId>org.javaee7.jpa</groupId>
+        <artifactId>jpa-samples</artifactId>
+        <version>1.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+
+    <artifactId>ordercolumn</artifactId>
+    <packaging>war</packaging>
+
+</project>
diff --git a/...ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionaljoin/Child.java b/...ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionaljoin/Child.java
@@ -0,0 +1,38 @@
+package org.javaee7.jpa.ordercolumn.entity.bidirectionaljoin;
+
+import static javax.persistence.GenerationType.IDENTITY;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+
+@Entity
+public class Child {
+
+	@Id
+	@GeneratedValue(strategy = IDENTITY)
+	private Long id;
+
+	@ManyToOne
+	@JoinColumn(name = "parent_id", insertable = false, updatable = false)
+	private Parent parent;
+
+	public Long getId() {
+		return id;
+	}
+
+	public void setId(Long id) {
+		this.id = id;
+	}
+
+	public Parent getParent() {
+		return parent;
+	}
+
+	public void setParent(Parent parent) {
+		this.parent = parent;
+	}
+
+}
diff --git a/...rdercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionaljoin/Parent.java b/...rdercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionaljoin/Parent.java
@@ -0,0 +1,45 @@
+package org.javaee7.jpa.ordercolumn.entity.bidirectionaljoin;
+
+import static javax.persistence.CascadeType.ALL;
+import static javax.persistence.FetchType.EAGER;
+import static javax.persistence.GenerationType.IDENTITY;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.OneToMany;
+import javax.persistence.OrderColumn;
+
+@Entity
+public class Parent {
+
+    @Id
+    @GeneratedValue(strategy = IDENTITY)
+    private Long id;
+
+    @OneToMany(cascade = ALL, fetch = EAGER)
+    @OrderColumn
+    @JoinColumn(name = "parent_id")
+    private List<Child> children = new ArrayList<>();
+
+    public Long getId() {
+        return id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+    }
+
+    public List<Child> getChildren() {
+        return children;
+    }
+
+    public void setChildren(List<Child> children) {
+        this.children = children;
+    }
+
+}
diff --git a/...rcolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionalmappedby/Child.java b/...rcolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionalmappedby/Child.java
@@ -0,0 +1,36 @@
+package org.javaee7.jpa.ordercolumn.entity.bidirectionalmappedby;
+
+import static javax.persistence.GenerationType.IDENTITY;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.ManyToOne;
+
+@Entity
+public class Child {
+
+    @Id
+    @GeneratedValue(strategy = IDENTITY)
+    private Long id;
+
+    @ManyToOne
+    private Parent parent;
+
+    public Long getId() {
+        return id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+    }
+
+    public Parent getParent() {
+        return parent;
+    }
+
+    public void setParent(Parent parent) {
+        this.parent = parent;
+    }
+
+}
diff --git a/...column/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionalmappedby/Parent.java b/...column/src/main/java/org/javaee7/jpa/ordercolumn/entity/bidirectionalmappedby/Parent.java
@@ -0,0 +1,43 @@
+package org.javaee7.jpa.ordercolumn.entity.bidirectionalmappedby;
+
+import static javax.persistence.CascadeType.ALL;
+import static javax.persistence.FetchType.EAGER;
+import static javax.persistence.GenerationType.IDENTITY;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.OneToMany;
+import javax.persistence.OrderColumn;
+
+@Entity
+public class Parent {
+
+	@Id
+	@GeneratedValue(strategy = IDENTITY)
+	private Long id;
+
+	@OneToMany(cascade = ALL, fetch = EAGER, mappedBy = "parent")
+	@OrderColumn
+	private List<Child> children = new ArrayList<>();
+
+	public Long getId() {
+		return id;
+	}
+
+	public void setId(Long id) {
+		this.id = id;
+	}
+
+	public List<Child> getChildren() {
+		return children;
+	}
+
+	public void setChildren(List<Child> children) {
+		this.children = children;
+	}
+
+}
diff --git a/jpa/ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/unidirectional/Child.java b/jpa/ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/unidirectional/Child.java
@@ -0,0 +1,24 @@
+package org.javaee7.jpa.ordercolumn.entity.unidirectional;
+
+import static javax.persistence.GenerationType.IDENTITY;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+
+@Entity
+public class Child {
+
+    @Id
+    @GeneratedValue(strategy = IDENTITY)
+    private Long id;
+
+    public Long getId() {
+        return id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+    }
+
+}
diff --git a/jpa/ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/unidirectional/Parent.java b/jpa/ordercolumn/src/main/java/org/javaee7/jpa/ordercolumn/entity/unidirectional/Parent.java
@@ -0,0 +1,45 @@
+package org.javaee7.jpa.ordercolumn.entity.unidirectional;
+
+import static javax.persistence.CascadeType.ALL;
+import static javax.persistence.FetchType.EAGER;
+import static javax.persistence.GenerationType.IDENTITY;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.OneToMany;
+import javax.persistence.OrderColumn;
+
+@Entity
+public class Parent {
+
+    @Id
+    @GeneratedValue(strategy = IDENTITY)
+    private Long id;
+
+    @OneToMany(cascade = ALL, fetch = EAGER)
+    @OrderColumn
+    @JoinColumn
+    private List<Child> children = new ArrayList<>();
+
+    public Long getId() {
+        return id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+    }
+
+    public List<Child> getChildren() {
+        return children;
+    }
+
+    public void setChildren(List<Child> children) {
+        this.children = children;
+    }
+
+}
diff --git a/.../java/org/javaee7/jpa/ordercolumn/service/bidirectionaljoin/OrderColumnTesterService.java b/.../java/org/javaee7/jpa/ordercolumn/service/bidirectionaljoin/OrderColumnTesterService.java
@@ -0,0 +1,23 @@
+package org.javaee7.jpa.ordercolumn.service.bidirectionaljoin;
+
+import javax.ejb.Stateless;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import org.javaee7.jpa.ordercolumn.entity.bidirectionaljoin.Parent;
+
+@Stateless
+public class OrderColumnTesterService {
+
+    @PersistenceContext
+    EntityManager entityManager;
+
+    public Parent save(Parent parent) {
+        return entityManager.merge(parent);
+    }
+
+    public Parent getParentById(Long id) {
+        return entityManager.find(Parent.class, id);
+    }
+
+}
diff --git a/...a/org/javaee7/jpa/ordercolumn/service/bidirectionalmappedby/OrderColumnTesterService.java b/...a/org/javaee7/jpa/ordercolumn/service/bidirectionalmappedby/OrderColumnTesterService.java
@@ -0,0 +1,23 @@
+package org.javaee7.jpa.ordercolumn.service.bidirectionalmappedby;
+
+import javax.ejb.Stateless;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import org.javaee7.jpa.ordercolumn.entity.bidirectionalmappedby.Parent;
+
+@Stateless
+public class OrderColumnTesterService {
+
+    @PersistenceContext
+    EntityManager entityManager;
+
+    public Parent save(Parent parent) {
+        return entityManager.merge(parent);
+    }
+
+    public Parent getParentById(Long id) {
+        return entityManager.find(Parent.class, id);
+    }
+
+}
diff --git a/...ain/java/org/javaee7/jpa/ordercolumn/service/unidirectional/OrderColumnTesterService.java b/...ain/java/org/javaee7/jpa/ordercolumn/service/unidirectional/OrderColumnTesterService.java
@@ -0,0 +1,23 @@
+package org.javaee7.jpa.ordercolumn.service.unidirectional;
+
+import javax.ejb.Stateless;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import org.javaee7.jpa.ordercolumn.entity.unidirectional.Parent;
+
+@Stateless
+public class OrderColumnTesterService {
+
+    @PersistenceContext
+    EntityManager entityManager;
+
+    public Parent save(Parent parent) {
+        return entityManager.merge(parent);
+    }
+
+    public Parent getParentById(Long id) {
+        return entityManager.find(Parent.class, id);
+    }
+
+}
diff --git a/jpa/ordercolumn/src/main/resources/META-INF/persistence.xml b/jpa/ordercolumn/src/main/resources/META-INF/persistence.xml
@@ -0,0 +1,10 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
+
+    <persistence-unit name="testPU">
+        <properties>
+            <property name="javax.persistence.schema-generation.database.action" value="drop-and-create" />
+        </properties>
+    </persistence-unit>
+</persistence>