配置WildFly的JDBC驅(qū)動(dòng)一般有兩種方式
(1) 以module的形式安裝;
(2) 以deploy應(yīng)用程序包的形式安裝欲险;
不過對(duì)于WildFly以domain模式運(yùn)行而言捌朴,最好采用第一種module的方式倡鲸,因?yàn)橐詰?yīng)用程序包的形式安裝的話等龙,需要當(dāng)前的WildFly服務(wù)器有server存在甸箱,而domain的模式闽坡,可以沒有server存在(如作為domain controller存在)栽惶,因此建議domain形式的服務(wù)器以module的形式安裝愁溜。
1. 配置驅(qū)動(dòng)
環(huán)境及軟件包信息:
版本 | 環(huán)境 |
---|---|
wildfly-10.1.0.Final | CentOS7 64bit |
mysql-connector-java-5.1.35.jar | CentOS7 64bit |
(1) module形式安裝
1、下載好mysql的JDBC驅(qū)動(dòng)外厂,比如版本mysql-connector-java-5.1.35.jar
冕象;
2、進(jìn)入$WILDFLY_HOME/modules/system/layers/base/com
目錄汁蝶,創(chuàng)建目錄mysql/main
渐扮;
3、將mysql-connector-java-5.1.35.jar
拷貝至$WILDFLY_HOME/modules/system/layers/base/com/mysql/main
目錄下掖棉;
4墓律、在$WILDFLY_HOME/modules/system/layers/base/com/mysql/main
目錄下新增文件module.xml
內(nèi)容如下:
<module xmlns="urn:jboss:module:1.3" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-5.1.35.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
請(qǐng)注意module:1.3的版本號(hào),不同版本的WildFly可能需要的版本號(hào)不一樣幔亥,這里WildFly10的版本號(hào)是1.3耻讽,如果不知道當(dāng)前的WildFly該配置什么版本號(hào),可以在
$WILDFLY_HOME/modules/system/layers/base/com
目錄下隨便找一個(gè)現(xiàn)有的module.xml
文件帕棉,看一下xmlns="urn:jboss:module:x.x"
就知道了齐饮,然后新增的MySql的module也按x.x
版本號(hào)即可;
請(qǐng)保證resource-root
這個(gè)值path
的值跟你拷貝的驅(qū)動(dòng)的文件名一致;
啟動(dòng)或重啟WildFly,在在$WILDFLY_HOME/bin
目錄下笤昨,運(yùn)行
[root@localhost bin]# ./jboss-cli.sh
You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands.
[disconnected /] connect
[domain@localhost:9990 /]
運(yùn)行下面的命令:
[domain@localhost:9990 /] /profile=full/subsystem=datasources/jdbc-driver=mysql:add(\
driver-name=mysql,\
driver-module-name=com.mysql,\
driver-class-name=com.mysql.jdbc.Driver,\
driver-xa-datasource-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource\
)
成功的話一般會(huì)提示:
{
"outcome" => "success",
"result" => undefined,
"server-groups" => {
"kie-server-group" => {"host" => {"master" => {"server-two" => {"response" => {"outcome" => "success"}}}}},
"main-server-group" => {"host" => {"master" => {"server-one" => {"response" => {"outcome" => "success"}}}}}
}
}
這里的
/profile=full
表示祖驱,你需要在domain
模式下,在profile=full
的配置里添加該datasources瞒窒,同樣捺僻,domain默認(rèn)的profile一共四種:default,ha,full,full-ha
,通過該參數(shù)/profile=其中之一
指定即可
對(duì)于standalone模式崇裁,命令為:
[standalone@localhost:9990 /] /subsystem=datasources/jdbc-driver=mysql:add(\
driver-name=mysql,\
driver-module-name=com.mysql,\
driver-class-name=com.mysql.jdbc.Driver,\
driver-xa-datasource-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource\
)
(2) 以deploy應(yīng)用程序包的形式安裝
將 mysql-connector-java-5.1.23-bin.jar
按正常的jar部署到WildFly匕坯,deploy
之后enable
即可,mysql驅(qū)動(dòng)會(huì)被自動(dòng)檢測(cè)注冊(cè)拔稳,這個(gè)時(shí)候不需要CLI的命令額外配置葛峻。
注意,此操作建議在standalone模式下做
2. 配置DataSource
驅(qū)動(dòng)安裝完成之后巴比,可以添加對(duì)應(yīng)的MySql的DataSource术奖,也有2種形式,一種是通過web界面形式即http-interface
添加轻绞,進(jìn)入http://ip:9990
(使用WildFly的management用戶登錄)采记,另一種是登錄服務(wù)器使用native-interface CLI
形式添加。
Configuration->選定Profile->Datasources政勃,點(diǎn)擊Add然后進(jìn)入向?qū)Ы缑媾渲?XA)datasource唧龄。
(1) web配置
具體如下:
(選擇好在上述配置好Mysql的驅(qū)動(dòng))
配置好對(duì)應(yīng)的數(shù)據(jù)庫實(shí)例和IP
數(shù)據(jù)庫用戶名和密碼
配置完成之后,可以測(cè)試連接
顯示連接成功奸远,標(biāo)明數(shù)據(jù)庫配置正確完成
如果測(cè)試連接失敗既棺,除了檢查基于web向?qū)У呐渲眯畔?zhǔn)確之外讽挟,也檢查一下Mysql是否支持遠(yuǎn)程連接,具體如下:
> mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.0.96-community-nt MySQL Community Edition (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Database changed
mysql> select user,password,host from user;
+-------+-------------------------------------------+----------------+
| user | password | host |
+-------+-------------------------------------------+----------------+
| root | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 | localhost |
| sbe | *4BC2133EA3FF7134B2ECC0DC1D3C1A69B4C3746E | localhost |
+-------+-------------------------------------------+----------------+
2 rows in set (0.07 sec)
host
列都是localhost
丸冕,說明不支持遠(yuǎn)程連接耽梅,修改一下mysql的連接配置:
mysql> grant all privileges on *.* to root@"192.168.56.103" identified by "password";
Query OK, 0 rows affected (0.09 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.10 sec)
mysql> select user,password,host from user;
+-------+-------------------------------------------+----------------+
| user | password | host |
+-------+-------------------------------------------+----------------+
| root | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 | localhost |
| sbe | *4BC2133EA3FF7134B2ECC0DC1D3C1A69B4C3746E | localhost |
| root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | 192.168.56.103 |
+-------+-------------------------------------------+----------------+
3 rows in set (0.00 sec)
mysql>
可以看到剛剛新增需要遠(yuǎn)程連接的192.168.56.103 WildFly服務(wù)器了,表明配置成功晨仑,回到WildFly的web界面褐墅,重新測(cè)試連接。
(2) CLI配置
domain模式下命令:
[domain@localhost:9990 /] /profile=full/subsystem=datasources/data-source=MySqlDS:add(\
jndi-name=java:/MySqlDS,\
driver-name=mysql,\
connection-url=jdbc:mysql://192.168.56.1:3306/brms,\
user-name=root,\
password=password\
)
standalone模式下命令:(實(shí)際上去掉/profile=full
即可)
[standalone@localhost:9990 /] /subsystem=datasources/data-source=MySqlDS:add(\
jndi-name=java:/MySqlDS,\
driver-name=mysql,\
connection-url=jdbc:mysql://192.168.56.1:3306/brms,\
user-name=root,\
password=password\
)
3. DataSource使用
一般可以通過使用JNDI name的方式:
如配置persistence
<persistence-unit name="my-app" transaction-type="JTA">
<jta-data-source>java:/MySqlDS</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties/>
</persistence-unit>
注解的形式injection
public class MyClass {
@Resource(name = "java:/MySqlDS")
private javax.sql.DataSource dataSource;
}