Fixes for Chap 4 second GE. moved DS to H2 instead of MySQl

Ravi Srinivasan

2018-09-13 615c1a9a918d5aba6e88aad3ca13795a89ff8149

Fixes for Chap 4 second GE. moved DS to H2 instead of MySQl

 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" />

 labs/create-queries/src/main/resources/import.sql

New file
@@ -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');


 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" />

 solutions/create-queries/src/main/resources/import.sql

New file
@@ -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');