MySQL Setup on Local WildFly
Table of Contents
Overview ................................................................................................................1
Download the MySQL .JAR File .........................................................................2
Install MySQL Driver as a Core Module (Local) ..................................................2
Add a Datasource via the WildFly Admin Page ....................................................6
Overview
In the sections below, we will deploy the MySQL Connector/J driver as a core
module of our local WildFly server. The deployment will enable the MySQL
driver to be detected by the WildFly server. Also, a JDBC datasource will be
created which will enable us to access the MySQL database without supplying
credentials from within our code. This technique is an example of Context
Dependency Injection (CDI). The JDBC datasource is maintained by the WildFly
server and “injected” into our application when we specify the JNDI name in our
Java class files.
We do not need to perform these steps on the remote server since that setup has
already been accomplished. In the steps below, we configure the driver as a core
module on the client using the [Link] tool and add a datasource using the
WildFly Admin page.
Note: version numbers will likely be different. Use the “latest stable” versions.
The steps in this tutorial should be performed after the following:
Local Installations/Configurations:
1. JDK
2. WildFly Local
3. NetBeans
4. Your local database
a. database name: inew233800x00x
b. database user: inew233800x00x
c. password: from Web Credentials
Page 1 of 12
MySQL Setup on Local WildFly
Remote:
5. Uploaded .war file(s) to your [Link] student website and
successfully tested your site.
Download the MySQL .JAR File
Download the latest stable mysql…jar (known as Connector/J) from the MySQL
site:
[Link]
Be sure to select “Platform Independent” to get just the .jar file and not the
installation package for Windows.
Install MySQL Driver as a Core Module (Local)
We have a choice to install the driver as a deployment or a core module. We elect
the core module approach since it is more suitable for enterprise applications. By
the way, using the jboss-cli (cmd line interface) is required to install the module in
the server locally. And, recall from above that MySQL module installation is not
required on the server since the module and JDBC datasource have already been
configured by your professor.
Go to WILDFLY_HOME\modules\system\layers\base\com and create the
folder mysql and then create the folder main inside of mysql (i.e. mysql\main).
Page 2 of 12
MySQL Setup on Local WildFly
Place the mysql…jar file you downloaded in the mysql\main folder.
Create the file [Link] (see content) and place it in the mysql\main folder.
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="[Link]">
<resources>
<resource-root path="[Link]"/>
</resources>
<dependencies>
<module name="[Link]"/>
<module name="[Link]"/>
</dependencies>
</module>
In [Link], change the name of the resource-root to reflect the appropriate
version of the .jar file you downloaded:
<resource-root path="[Link]"/>
The “main” folder should now contain the [Link] and mysql…jar files.
Navigate to the [Link]\bin directory in the command window.
From the command line run: [Link] –connect (that is 2 dashes prior to
connect).
I received the error “The system cannot find the path specified.” when running the
[Link] command.
Page 3 of 12
MySQL Setup on Local WildFly
I then double-clicked “[Link]” in bin to run the WildFly server. After
WildFly started, I double-clicked “[Link]”, entered “connect” and
successfully received the command prompt. By the way, the instructions at the
[Link] link do specify to start WildFly prior to running the jboss-cli tools.
[standalone@localhost:9990 /] is the jboss-cli command prompt.
Now need to enter the string below at the jboss-cli prompt:
/subsystem=datasources/jdbc-driver=mysql:add(driver-name=mys
ql,driver-module-name=[Link],driver-class-name=[Link].
[Link])
After the string is at the prompt, press enter. I received “outcome” => “success”.
However, I have attempted the module addition before without success. When that
happened, I stopped the server, closed the command window, restarted the server,
restarted [Link]. The command was then successful.
Page 4 of 12
MySQL Setup on Local WildFly
Now that the driver has been installed as a core module, we need to add a
datasource for the connection to WildFly using the Admin page.
Page 5 of 12
MySQL Setup on Local WildFly
Add a Datasource via the WildFly Admin Page
Start the WildFly local server if it is not running. Recall that you can start Wildfly
from within NetBeans. In the browser, navigate to [Link] which
opens the WildFly Admin page. Enter your ManagementRealm credentials to
login. Select Start in window below.
Select Subsystems | Datasources | Non-XA | Add.
Page 6 of 12
MySQL Setup on Local WildFly
Choose MySQL for the type.
Complete Step 1/3:
Page 7 of 12
MySQL Setup on Local WildFly
Complete Step 2/3: (MySQL should already be detected and populated as a result
of the steps above to install the MySQL driver using the [Link] tool.)
Complete Step 3/3:
Page 8 of 12
MySQL Setup on Local WildFly
Summary.
Page 9 of 12
MySQL Setup on Local WildFly
You can test your connection at anytime by navigating to Runtime | Standalone
Server | Subsystems | Datasources | View | Select the datasource | Test Connection
Page 10 of 12
MySQL Setup on Local WildFly
After the datasource has been created, select Enable | Pool | Edit and then add the
following pool values.
The JDBC resource is maintained by the WildFly server and “injected” into our
application when we specify the JNDI name in our Java class files.
Reminders:
• Be sure to use the correct information for the following since those are the
settings for your [Link] database:
o database
o datasource
o username
o password.
• No need to deploy the MySQL core module remotely. The module
configuration has been performed by your professor.
• No need to configure a datasource remotely. Your datasource has been
added by your professor. However, you must use the correcct configuration
(more in the chapter covering the mysql-in-wildfly-setup-remote):
o JNDI name: java:jboss/datasources/inew233800x00x (used in your
Java class files for Programs 11 and 12)
Page 11 of 12
MySQL Setup on Local WildFly
The image below is from WildFly Admin Runtime | Standalone Server |
Subsystems | Datasources | View which shows the JNDI (Java Naming and
Directory Interface) name that should be used in your Java class files (Programs 11
and 12).
Page 12 of 12
