002>WildFly14 增加mysql 8.0.11 資料源

1、下載下傳Mysql8.0驅動jar包

mysql-connector-java-8.0.11.jar

具體下載下傳方法，網上搜尋一下。

2、增加mysql能動module

a>在/usr/local/wildfly14/modules/system/layers/base/com目錄并拷貝mysql驅動

$mkdir -p mysql/main
$cd mysql/main
$cp ~/mysql-connector-java-8.0.11.jar ./
$vim module.xml
           

b>增加module.xml内容如下

<?xml version="1.0" encoding="UTF-8"?>

<module name="com.mysql" xmlns="urn:jboss:module:1.5">

    <resources>
        <resource-root path="mysql-connector-java-8.0.11.jar"/>
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>
           

至此mysql驅動子產品增加完成。

3、在配置檔案中增加資料源

a>進入/usr/local/wildfly14/standalone/configuration目錄

b>打開standalone.xml配置檔案

c>找到drivers标簽，并且增加如下driver

<drivers>
    <driver name="h2" module="com.h2database.h2">
        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
    </driver>
    <!-- 增加下面mysql驅動 -->
    <driver name="mysql" module="com.mysql">
        <xa-datasource-class>com.mysql.cj.jdbc.MysqlXADataSource</xa-datasource-class>
    </driver>
</drivers>
           

d>找到datasources标簽，并且增加如下datasource

<datasource jndi-name="java:jboss/datasources/LotteryDS" pool-name="LotteryDS" enabled="true" use-java-context="true">
     <connection-url>jdbc:mysql://localhost:3306/資料庫名?useSSL=false&amp;connectionCollation=utf8_general_ci&amp;characterSetResults=utf8&amp;characterEncoding=utf8</connection-url>
    <driver>mysql</driver>
    <security>
        <user-name>資料庫使用者名</user-name>
        <password>密碼</password>
    </security>

    <validation>
        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
        <background-validation>true</background-validation>
        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
    </validation>
</datasource>
           

特别注意：

1> 如果connection-url沒有增加useSSL=false的話，啟動wildfly應該會報一個錯誤

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

至此就增加好了mysql資料源，在web管理界面就可以看到多了一個jdbc驅動和一下資料源，如下圖