How to configure Wildfly 10 to use MySQL

Follow these steps to configure MySQL in Wildfly 10

 Step 1: Download MySQL connector jar from mysql downloads page.

Step 2: Go to modules\system\layers\base\com of your Wildfly home

Step 3: Create folder like mysql\main and go to mysql\main

Step 4: Place the downloaded connector jar in the main folder 

Step 5: Create a file named module.xml in the main folder and put the following content in it. Set the path variable so that it matches the name of the jar file.

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

 Step 6: Go to standalone\configuration directory of Wildfly home and open standalone.xml file

Step 7: Add a driver definition for MySQL by putting the following code inside datasources->drivers xml block

<driver name="mysql" module="com.mysql">
    <driver-class>com.mysql.jdbc.Driver</driver-class>
 </driver>

Step 8: Add a datasource definition inside datasources with the following code:

<datasource jndi-name="java:jboss/datasources/SchoolAppDS" pool-name="SchoolAppDS" enabled="true" use-java-context="true">
    <connection-url>jdbc:mysql://localhost/schooldbv3</connection-url>
    <driver>mysql</driver>
    <pool>
        <min-pool-size>2</min-pool-size>
        <max-pool-size>5</max-pool-size>
    </pool>
    <security>
        <user-name>root</user-name>
        <password>123456</password>
    </security>
</datasource>

Replace localhost, schooldbv3, SchoolAppDS with your DB server's host name or IP, name of your database and your desired name for defining datasource and connection pool. Also set min-pool-size and max-pool-size to values suitable for your need.

Comments

  1. brunomori23July 19, 2017 at 4:46 PM

    this works, thank you!!

    ReplyDelete
  2. UnknownAugust 17, 2017 at 1:28 AM

    Thats brilliant I love.Good job keep it up

    ReplyDelete
    Replies
    1. Rafiqunnabi NayanOctober 30, 2017 at 11:28 PM

      Thanks a lot for your comment. Feeling happy knowing that my small effort helped someone.

      Delete
  3. AnonymousOctober 30, 2017 at 10:20 PM

    Very useful

    ReplyDelete
  4. AnonymousNovember 12, 2017 at 8:43 AM

    Thank's
    Good explication

    ReplyDelete
  5. Marcos RobertoApril 10, 2018 at 11:36 AM

    It is possible install mysql module from WEB Console?

    ReplyDelete
  6. UnknownOctober 31, 2018 at 1:30 AM

    Hi!
    I am getting followong error while running wildfly

    ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "Ontobrowser")
    ]) - failure description: {
    "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.com_mysql"],
    "WFLYCTL0180: Services with missing/unavailable dependencies" => [
    "jboss.driver-demander.java:jboss/datasources/Ontobrowser is missing [jboss.jdbc-driver.com_mysql]",
    "org.wildfly.data-source.Ontobrowser is missing [jboss.jdbc-driver.com_mysql]"

    ReplyDelete
    Replies
    1. UnknownDecember 4, 2018 at 7:00 AM

      Verify module.xml in main folder. Driver name and version should be correct.

      Delete

Post a Comment

Popular posts from this blog

Run tasks in background in Spring

Why background task? There are tons of examples where we often need to run a task in background e.g. sending an email, sms or notification, writing some log in file etc. If a task is not required to maintain atomicity and can be executed after some delay, it's a good candidate to run in background.   How to run tasks in background in Java? In Java, the easiest way to run a task in background is to create a new thread and execute it. It's quite simple. Here is how to do this: new Thread(new Runnable(){ @Override public void run(){ // your background task } }).start(); It's easy! But there are some maintenance problem with the above code. The major problem is - there is no way to control how many background tasks we want to run simultaneously. For example, if 1000 users registers in your application at a time and you create 1000 background threads to send them a confirmation email, maybe you'll be in trouble. So you ne...
Read more

Conditional field inclusion in Jackson and Spring Boot

When we write JSON API with spring boot, we often need to customize which fields should be included in our response JSON and which should not. For example, suppose we've a Model like the following: public class User {     private Long id;     private String name;     private String password;     private List<String> children;     // getters and setters here } Now we've the following controller: @RestController @RequestMapping("/api/users") public class UserController {     @GetMapping     public List<User> userList(){         User user = new User();         user.setId(10L);         user.setName("Rafiqunnabi Nayan");         user.setPassword("abcd");         user.setChildren(Arrays.asList("Child 1", "Child 2"));         return Arrays.asList(user);     ...
Read more