MySQL DataSource for Wildfly10 like Openshift

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 -->
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>

Step 2: add Driver and Datasource in standalone.xml

cd wildfly-10.0.0.Final//standalone/configuration/
edit standalone.xml
find <subsystem xmlns="urn:jboss:domain:datasources:2.0">
add MySQL datasource and driver:

<datasources>
  <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
  ...
  </datasource>
  <!-- add MySQL DataSource here: -->
  <datasource 
    jndi-name="java:jboss/datasources/MySQLDS" 
    pool-name="MySQLDS" 
    enabled="true" 
    use-java-context="true">
    <connection-url>jdbc:mysql://localhost:3306/wildfly?useUnicode=yes&amp;characterEncoding=UTF-8</connection-url>
    <driver>com.mysql</driver>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <pool>
      <min-pool-size>10</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <prefill>true</prefill>
    </pool>
    <security>
       <user-name>wildfly</user-name>
       <password>wildflypwd</password>
    </security>
    <statement>
      <prepared-statement-cache-size>32</prepared-statement-cache-size>
      <share-prepared-statements>true</share-prepared-statements>
    </statement>
 </datasource>
 <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
<!-- add MySQL Driver here: -->
 <drivers>
    <driver name="com.mysql" module="mysql.mysql-connector-java">
      <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
     </driver>
 </drivers></datasources>

change credentials for your needs.
insure the database is encoded UTF-8-bin.



Standort: Berlin, Deutschland

Kommentare

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

Java EE 7 Petclinic

Bild
A Java EE 7 Version of Spring Petclinic. Depending on JSF and EJB and ready to run on JBoss WildFly  and Oracle Glassfish . You find a running Version with WildFly on OpenShift , the RedHat Cloud: http://javaee7petclinic-port80guru.rhcloud.com Source Code ist hosted on Github: https://github.com/phasenraum2010/javaee7-petclinic The Domain Modell  contains all basic Relationships between Entities like OneToMany, ManyToOne and also ManyToMany: Pageflow  is complex enough to be interesting for Functional Tests with Selenium2 Webdriver, Arquillian Drone and Graphene: Use Cases Some Example Screen Shots install JBoss Wildfly install JBoss Wildfly 8.0.0.Final from http://wildfly.org/downloads/ to e.g. /Users/tw/srv/wildfly-8.0.0.Final/ start JBoss by: cd /Users/tw/srv/wildfly-8.0.0.Final/bin ; ./standalone.sh   install Glassfish 4 I installed Netbeans 7.4 with Glassfish 4.0 from https://netbeans.org/downloads/ sta
Mehr anzeigen

Simulated Evolution - Artificial Life and DNA

Bild
Abstract Green food appears in a world with red moving cells. These cells eat the food if it is on their position. Movement of the cells depends on random and their DNA. A fit cell moves around and eats enough to reproduce. Reproduction is done by splitting the cell and randomly changing the DNA of the two new Cells. If a cell doesn't eat enough, it will first stand still and after a while it dies. Run the Application git clone https://github.com/phasenraum2010/simulated-evolution.git cd simulated-evolution mvn clean install exec:java or Download the jar and double click on it to start the Application: http://www.thomas-woehlke.de/a/simulated-evolution/simulated-evolution-1.1-SNAPSHOT.jar Screenshots Early Later Explanation     water     food     cell is young cell is fat enough to reproduce cell is old enough to reproduce cell is hungry and waiting for food or death cell is old and waiting for death * (if cell is fat and old enough for re
Mehr anzeigen

Diffusion-limited aggregation

Bild
Fractals and random walk due to Brownian motion cluster   Abstract Diffusion-limited aggregation (DLA) is the process whereby particles undergoing a random walk due to Brownian motion cluster together to form aggregates of such particles. This theory, proposed by T.A. Witten Jr. (not to be confused with Edward Witten) and L.M. Sander in 1981,[1] is applicable to aggregation in any system where diffusion is the primary means of transport in the system. DLA can be observed in many systems such as electrodeposition, Hele-Shaw flow, mineral deposits, and dielectric breakdown.   Run the Application git clone https://github.com/phasenraum2010/diffusion-limited-aggregation.git cd diffusion-limited-aggregation mvn clean install exec:java or Download the jar and double click on it to start the Application: http://www.thomas-woehlke.de/a/diffusion-limited-aggregation/diffusion-limited-aggregation-1.1-SNAPSHOT.jar   Screenshots Early Later More https://en.
Mehr anzeigen