Thomas Wöhlke - Systems- and Software-Engineering

Running an Web Application with Spring Framework 4.2.x with Spring-Data-JPA and MySQL on OpenShift the RedHat Cloud is good with Wildfly10. But how to configure the MySQL Database for Spring-Data-JPA? Spring-Data-JPA with Wildfly10 and MySQL on Openshift   First Step: edit persistence.xml. Here is an Example: <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.1" 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="mySimpleWorkListPU" transaction-type="JTA"><jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source> <class>org.woehlke.simpleworklist.entities.ActionItem</class> <class>org.woehlke.simpleworklist.entities.Category...

how to configure Wildfly10 to have a DataSource for MySQL like Openshift the RedHat Cloud. I installed Wildfly10 on ~/srv/wildfly-10.0.0.Final Step 1: Add MySQL Driver to modules: Download the mysql-driver mysql-connector-java-5.1.38.jar from any Maven Repository e.g.:  http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.38/ go to WildFly modules Directory: cd wildfly-10.0.0.Final/modules/system/layers/base mkdir -p mysql/mysql-connector-java/main copy  mysql-driver mysql-connector-java-5.1.38.jar here. add a file module.xml with content: <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1"          name="mysql.mysql-connector-java">     <resources>         <resource-root path="mysql-connector-java-5.1.38.jar"/>         <!-- Insert resources here --> ...