Temporal attributes cannot be used with @convert and so changing to CreditCard based upon Antonio's slide deck

arun-gupta · arun-gupta · commit 49a7d9afe2bf · 2013-11-09T17:31:29.000+02:00
diff --git a/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/CreditCard.java b/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/CreditCard.java
@@ -0,0 +1,38 @@
+/*
+ * To change this license header, choose License Headers in Project Properties.
+ * To change this template file, choose Tools | Templates
+ * and open the template in the editor.
+ */
+
+package org.javaee7.jpa.converter;
+
+import java.util.Date;
+
+/**
+ * @author Arun Gupta
+ */
+public class CreditCard {
+    String cardNumber;
+
+    public CreditCard() {
+    }
+
+    public CreditCard(String cardNumber) {
+        this.cardNumber = cardNumber;
+    }
+
+    public String getCardNumber() {
+        return cardNumber;
+    }
+
+    public void setCardNumber(String cardNumber) {
+        this.cardNumber = cardNumber;
+    }
+
+    @Override
+    public String toString() {
+        return cardNumber;
+    }
+
+    
+}
diff --git a/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/CreditCardConverter.java b/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/CreditCardConverter.java
@@ -0,0 +1,28 @@
+/*
+ * To change this license header, choose License Headers in Project Properties.
+ * To change this template file, choose Tools | Templates
+ * and open the template in the editor.
+ */
+
+package org.javaee7.jpa.converter;
+
+import javax.persistence.AttributeConverter;
+import javax.persistence.Converter;
+
+/**
+ * @author Arun Gupta
+ */
+@Converter
+public class CreditCardConverter implements AttributeConverter<CreditCard, String> {
+
+    @Override
+    public String convertToDatabaseColumn(CreditCard attribute) {
+        return attribute.toString();
+    }
+
+    @Override
+    public CreditCard convertToEntityAttribute(String card) {
+        return new CreditCard(card);
+    }
+    
+}
diff --git a/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/Employee.java b/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/Employee.java
@@ -1,6 +1,7 @@
 package org.javaee7.jpa.converter;
 
 import java.io.Serializable;
+import java.util.Date;
 import javax.persistence.Column;
 import javax.persistence.Convert;
 import javax.persistence.Entity;
@@ -25,19 +26,19 @@ public class Employee implements Serializable {
     @Column(length=50)
     private String name;
     
-    @Convert(converter = EmployeeDateConverter.class)
-    private String dob;
+    @Convert(converter = CreditCardConverter.class)
+    private String card;
     
     public Employee() { }
     
     public Employee(String name) {
         this.name = name;
     }
 
-    public Employee(int id, String name, String dob) {
+    public Employee(int id, String name, String card) {
         this.id = id;
         this.name = name;
-        this.dob = dob;
+        this.card = card;
     }
     
     public int getId() {
@@ -56,16 +57,16 @@ public void setName(String name) {
         this.name = name;
     }
 
-    public String getDob() {
-        return dob;
+    public String getCard() {
+        return card;
     }
 
-    public void setDob(String dob) {
-        this.dob = dob;
+    public void setCard(String card) {
+        this.card = card;
     }
-    
+
     @Override
     public String toString() {
-        return name + "(" + dob + ")";
+        return name + "(" + card + ")";
     }
 }
diff --git a/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/EmployeeDateConverter.java b/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/EmployeeDateConverter.java
diff --git a/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/MyDate.java b/jpa/jpa-converter/src/main/java/org/javaee7/jpa/converter/MyDate.java
diff --git a/jpa/jpa-converter/src/main/resources/META-INF/create.sql b/jpa/jpa-converter/src/main/resources/META-INF/create.sql
@@ -1 +1 @@
-CREATE TABLE EMPLOYEE_SCHEMA_CONVERTER ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "DOB" VARCHAR(10) not null)
+CREATE TABLE EMPLOYEE_SCHEMA_CONVERTER ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "CARD" VARCHAR(15) not null)
diff --git a/jpa/jpa-converter/src/main/resources/META-INF/load.sql b/jpa/jpa-converter/src/main/resources/META-INF/load.sql
@@ -1,7 +1,6 @@
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (1, 'Leonard', '12/9/1980')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (2, 'Sheldon', '3/24/1973')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (3, 'Penny', '11/30/1985')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (4, 'Raj', '4/30/1975')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (5, 'Howard', '12/9/1980')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (6, 'Bernadette', '6/23/1980')
-INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "DOB") VALUES (7, 'Amy', '12/12/1975')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (1, 'Leonard', '11-22-33-44')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (2, 'Sheldon', '22-33-44-55')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (3, 'Penny', '33-44-55-66')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (4, 'Raj', '44-55-66-77')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (5, 'Howard', '55-66-77-88')
+INSERT INTO EMPLOYEE_SCHEMA_CONVERTER("ID", "NAME", "CARD") VALUES (6, 'Bernadette', '66-77-88-99')

Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-CREATE TABLE EMPLOYEE_SCHEMA_CONVERTER ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "DOB" VARCHAR(10) not null)`
	`1`	`+CREATE TABLE EMPLOYEE_SCHEMA_CONVERTER ("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "CARD" VARCHAR(15) not null)`