From c7b9c849bf5207656f5694132ec63c5194b34fff Mon Sep 17 00:00:00 2001
From: Ravi Srinivasan <rsriniva@redhat.com>
Date: Thu, 13 Sep 2018 14:16:45 +0200
Subject: [PATCH] Migrate to H2 DB from MySQL for Chap 5 final GE
---
labs/entity-relationships/src/main/resources/META-INF/persistence.xml | 12 ++++++------
solutions/entity-relationships/src/main/resources/import.sql | 5 +++++
solutions/entity-relationships/src/main/resources/META-INF/persistence.xml | 12 ++++++------
labs/entity-relationships/src/main/resources/import.sql | 5 +++++
4 files changed, 22 insertions(+), 12 deletions(-)
diff --git a/labs/entity-relationships/src/main/resources/META-INF/persistence.xml b/labs/entity-relationships/src/main/resources/META-INF/persistence.xml
index 4e1266f..41466e2 100644
--- a/labs/entity-relationships/src/main/resources/META-INF/persistence.xml
+++ b/labs/entity-relationships/src/main/resources/META-INF/persistence.xml
@@ -3,13 +3,13 @@
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="People" transaction-type="JTA">
- <jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source>
+ <persistence-unit name="hello" transaction-type="JTA">
+ <jta-data-source>java:jboss/datasources/ExampleDS</jta-data-source>
<properties>
- <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
- <property name="hibernate.hbm2ddl.auto" value="update" />
- <property name="hibernate.show_sql" value="true" />
- <property name="hibernate.format_sql" value="true" />
+ <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
+ <property name="hibernate.hbm2ddl.auto" value="create-drop" />
+ <property name="hibernate.show_sql" value="true" />
+ <property name="hibernate.format_sql" value="true" />
</properties>
</persistence-unit>
</persistence>
diff --git a/labs/entity-relationships/src/main/resources/import.sql b/labs/entity-relationships/src/main/resources/import.sql
new file mode 100644
index 0000000..3966f40
--- /dev/null
+++ b/labs/entity-relationships/src/main/resources/import.sql
@@ -0,0 +1,5 @@
+INSERT INTO Email VALUES (1,'development@example.com'),(2,'admin@example.com'),(3,'sales@example.com'),(4,'research@example.com'),(5,'ceo@example.com'),(6,'problems@example.com'),(7,'help-desk@example.com'),(8,'hr@example.com'),(9,'supplies@example.com');
+
+INSERT INTO UserGroup VALUES (1,'dev'),(2,'qa'),(3,'stage');
+
+INSERT INTO User (id,name,emailID,groupID) VALUES (1,'William',1,1),(2,'Rose',2,1),(3,'Pat',3,1),(4,'Rodney',4,2),(5,'Kim',5,2),(6,'Tom',6,2),(7,'Matt',7,3),(8,'George',8,3),(9,'Jean',9,3);
diff --git a/solutions/entity-relationships/src/main/resources/META-INF/persistence.xml b/solutions/entity-relationships/src/main/resources/META-INF/persistence.xml
index 4e1266f..41466e2 100644
--- a/solutions/entity-relationships/src/main/resources/META-INF/persistence.xml
+++ b/solutions/entity-relationships/src/main/resources/META-INF/persistence.xml
@@ -3,13 +3,13 @@
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="People" transaction-type="JTA">
- <jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source>
+ <persistence-unit name="hello" transaction-type="JTA">
+ <jta-data-source>java:jboss/datasources/ExampleDS</jta-data-source>
<properties>
- <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
- <property name="hibernate.hbm2ddl.auto" value="update" />
- <property name="hibernate.show_sql" value="true" />
- <property name="hibernate.format_sql" value="true" />
+ <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
+ <property name="hibernate.hbm2ddl.auto" value="create-drop" />
+ <property name="hibernate.show_sql" value="true" />
+ <property name="hibernate.format_sql" value="true" />
</properties>
</persistence-unit>
</persistence>
diff --git a/solutions/entity-relationships/src/main/resources/import.sql b/solutions/entity-relationships/src/main/resources/import.sql
new file mode 100644
index 0000000..3966f40
--- /dev/null
+++ b/solutions/entity-relationships/src/main/resources/import.sql
@@ -0,0 +1,5 @@
+INSERT INTO Email VALUES (1,'development@example.com'),(2,'admin@example.com'),(3,'sales@example.com'),(4,'research@example.com'),(5,'ceo@example.com'),(6,'problems@example.com'),(7,'help-desk@example.com'),(8,'hr@example.com'),(9,'supplies@example.com');
+
+INSERT INTO UserGroup VALUES (1,'dev'),(2,'qa'),(3,'stage');
+
+INSERT INTO User (id,name,emailID,groupID) VALUES (1,'William',1,1),(2,'Rose',2,1),(3,'Pat',3,1),(4,'Rodney',4,2),(5,'Kim',5,2),(6,'Tom',6,2),(7,'Matt',7,3),(8,'George',8,3),(9,'Jean',9,3);
--
Gitblit v1.9.3