Welcome to the training!

[oracle@host01 ~]$ gnome-terminal --title "JBoss EAP 6 -- standalone @host01" -e "/opt/jboss-eap-6.4/bin/standalone.sh -Djboss.bind.address.management=host01.example.com -Djboss.bind.address=host01.example.com --server-config=standalone.xml" &

[oracle@host01 ~]$ gnome-terminal --title "JBoss EAP 6 -- domain @host01" -e "/opt/jboss-eap-6.4/bin/domain.sh -Djboss.bind.address.management=host01.example.com -Djboss.bind.address=host01.example.com --host-config=host01.xml" &
							

[oracle@host02 ~]$ gnome-terminal --title "JBoss EAP 6 -- domain @host02" -e "/opt/jboss-eap-6.4/bin/domain.sh -Djboss.bind.address.management=host02.example.com -Djboss.bind.address=host02.example.com --host-config=host02.xml" &
							

[oracle@host01 ~]$ jboss-cli.sh --connect --controller=host01.example.com --command=shutdown

[domain@host01.example.com:9999 /] /host=host01/:shutdown

[domain@host01.example.com:9999 /] /host=host01/server-config=server1/:stop()
{
	"outcome" => "success",
	"result" => "STOPPED"
}
[domain@host01.example.com:9999 /] /host=host01/server-config=server1/:start()
{
	"outcome" => "success",
	"result" => "STARTING"
}

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
	<resources>
		<resource-root path="mysql-connector-java-5.1.49.jar"/>
	</resources>
	<dependencies>
		<module name="javax.api"/>
		<module name="javax.transaction.api"/>
	</dependencies>
</module> 

mysql> create database mylog;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mylog              |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
15 rows in set (0.00 sec)

mysql> use mylog;

Database changed
mysql> CREATE TABLE log_table(
    ->  id INT(11) NOT NULL AUTO_INCREMENT,
    ->  `timestamp` VARCHAR(255) DEFAULT NULL,
    ->  level VARCHAR(255) DEFAULT NULL,
    ->  mdc_ip VARCHAR(255) DEFAULT NULL,
    ->  mdc_user VARCHAR(255) DEFAULT NULL,
    ->  message TEXT DEFAULT NULL,
    ->  hardcoded VARCHAR(255) DEFAULT NULL,
    ->  PRIMARY KEY (id)
    -> ) ENGINE = INNODB AUTO_INCREMENT = 1 ;
Query OK, 0 rows affected, 1 warning (0.02 sec)

CREATE TABLE log_table(
	id INT(11) NOT NULL AUTO_INCREMENT,
	`timestamp` VARCHAR(255) DEFAULT NULL,
	level VARCHAR(255) DEFAULT NULL,
	mdc_ip VARCHAR(255) DEFAULT NULL,
	mdc_user VARCHAR(255) DEFAULT NULL,
	message TEXT DEFAULT NULL,
	hardcoded VARCHAR(255) DEFAULT NULL,
	PRIMARY KEY (id)
) ENGINE = INNODB AUTO_INCREMENT = 1 ; 

module add --name=com.mysql3 --resources=mysql-connector-java-5.1.49.jar --dependencies=javax.api,javax.transaction.api --module-root-dir=../modules/system/layers/base
/subsystem=datasources/jdbc-driver=mysql3:add(driver-module-name=mysql3,driver-name=mysql3,driver-class-name=com.mysql.jdbc.Driver)
/subsystem=datasources/jdbc-driver=mysql3:read-resource
/subsystem=datasources/data-source=movieDS:add(jndi-name="java:jboss/datasources/movieDS",connection-url="jdbc:mysql://localhost:3306/moviedb",driver-name=mysql3,user-name=root,password=Secret_123,max-pool-size=50,min-pool-size=8)
/subsystem=datasources/data-source=movieDS:read-resource
/subsystem=datasources/data-source=movieDS:write-attribute(name=initial-pool-size,value=2)

jboss-cli.bat --connect --command="deploy c:/tmp/MovieWebApplicationUsingJpa.war"