From 615c1a9a918d5aba6e88aad3ca13795a89ff8149 Mon Sep 17 00:00:00 2001 From: Ravi Srinivasan <rsriniva@redhat.com> Date: Thu, 13 Sep 2018 07:46:40 +0200 Subject: [PATCH] Fixes for Chap 4 second GE. moved DS to H2 instead of MySQl --- labs/create-queries/src/main/resources/import.sql | 11 +++++++++++ solutions/create-queries/src/main/resources/import.sql | 11 +++++++++++ labs/create-queries/src/main/resources/META-INF/persistence.xml | 2 +- solutions/create-queries/src/main/resources/META-INF/persistence.xml | 2 +- 4 files changed, 24 insertions(+), 2 deletions(-) diff --git a/labs/create-queries/src/main/resources/META-INF/persistence.xml b/labs/create-queries/src/main/resources/META-INF/persistence.xml index 0c3c54f..41466e2 100644 --- a/labs/create-queries/src/main/resources/META-INF/persistence.xml +++ b/labs/create-queries/src/main/resources/META-INF/persistence.xml @@ -4,7 +4,7 @@ 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="hello" transaction-type="JTA"> - <jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source> + <jta-data-source>java:jboss/datasources/ExampleDS</jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" /> <property name="hibernate.hbm2ddl.auto" value="create-drop" /> diff --git a/labs/create-queries/src/main/resources/import.sql b/labs/create-queries/src/main/resources/import.sql new file mode 100644 index 0000000..46e4d31 --- /dev/null +++ b/labs/create-queries/src/main/resources/import.sql @@ -0,0 +1,11 @@ +INSERT INTO Person (id,name) VALUES (1,'John'); +INSERT INTO Person (id,name) VALUES (2,'Steve'); +INSERT INTO Person (id,name) VALUES (3,'Mark'); +INSERT INTO Person (id,name) VALUES (4,'Nick'); +INSERT INTO Person (id,name) VALUES (5,'Nita'); +INSERT INTO Person (id,name) VALUES (6,'John'); +INSERT INTO Person (id,name) VALUES (7,'Julia'); +INSERT INTO Person (id,name) VALUES (8,'Joe'); +INSERT INTO Person (id,name) VALUES (9,'Nita'); +INSERT INTO Person (id,name) VALUES (10,'Branden'); + diff --git a/solutions/create-queries/src/main/resources/META-INF/persistence.xml b/solutions/create-queries/src/main/resources/META-INF/persistence.xml index 0c3c54f..41466e2 100644 --- a/solutions/create-queries/src/main/resources/META-INF/persistence.xml +++ b/solutions/create-queries/src/main/resources/META-INF/persistence.xml @@ -4,7 +4,7 @@ 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="hello" transaction-type="JTA"> - <jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source> + <jta-data-source>java:jboss/datasources/ExampleDS</jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" /> <property name="hibernate.hbm2ddl.auto" value="create-drop" /> diff --git a/solutions/create-queries/src/main/resources/import.sql b/solutions/create-queries/src/main/resources/import.sql new file mode 100644 index 0000000..46e4d31 --- /dev/null +++ b/solutions/create-queries/src/main/resources/import.sql @@ -0,0 +1,11 @@ +INSERT INTO Person (id,name) VALUES (1,'John'); +INSERT INTO Person (id,name) VALUES (2,'Steve'); +INSERT INTO Person (id,name) VALUES (3,'Mark'); +INSERT INTO Person (id,name) VALUES (4,'Nick'); +INSERT INTO Person (id,name) VALUES (5,'Nita'); +INSERT INTO Person (id,name) VALUES (6,'John'); +INSERT INTO Person (id,name) VALUES (7,'Julia'); +INSERT INTO Person (id,name) VALUES (8,'Joe'); +INSERT INTO Person (id,name) VALUES (9,'Nita'); +INSERT INTO Person (id,name) VALUES (10,'Branden'); + -- Gitblit v1.9.3