启动Wildfly时遇到的错误- "jboss.data-source.java:jboss/datasources/SCI_ODS is missing [jboss.jdbc-driv
启动Wildfly时遇到的错误是:
ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "SCI_ODS_sql2")
]) - failure description: {"JBAS014771: Services with missing/unavailable dependencies" => [
"jboss.data-source.java:jboss/datasources/SCI_ODS is missing [jboss.jdbc-driver.JTDS]",
"jboss.driver-demander.java:jboss/datasources/SCI_ODS is missing [jboss.jdbc-driver.JTDS]"
]}
ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "SCI_ODS_sql2")
]) - failure description: {
"JBAS014771: Services with missing/unavailable dependencies" => [
"jboss.data-source.java:jboss/datasources/SCI_ODS is missing [jboss.jdbc-driver.JTDS]",
"jboss.driver-demander.java:jboss/datasources/SCI_ODS is missing [jboss.jdbc-driver.JTDS]"
],
"JBAS014879: One or more services were unable to start due to one or more indirect dependencies not being available." => {
"Services that were unable to start:" => [
"jboss.data-source.reference-factory.SCI_ODS_sql2",
"jboss.naming.context.java.jboss.datasources.SCI_ODS"
],
"Services that may be the cause:" => ["jboss.jdbc-driver.JTDS"]
}
找到wildfly的standlone.xml文件
在上图标记的位置下加上数据源配置
<datasource jta="true" jndi-name="java:/MySqlDS" pool-name="MySqlDS_Pool" enabled="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:mysql://localhost:3306/taskDB</connection-url>
<driver>mysql</driver>
<security>
<user-name>root</user-name>
</security>
<timeout>
<idle-timeout-minutes>0</idle-timeout-minutes>
<query-timeout>600</query-timeout>
</timeout>
</datasource>
在上图标记的drivers下加上下面的代码
<driver name="mysql" module="com.mysql">
<driver-class>com.mysql.jdbc.Driver</driver-class>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
如果上面配置完不好使,找到wildfly的安装文件夹,到wildfly-14.0.1.Final\modules\system\layers\base\com这个目录下,新建一个mysql文件夹
在mysql文件夹里新建一个main文件夹
在main文件夹里包含三个文件----如果用过jboss就可以直接包jboss对应的这部分直接挪过来
下面是module.xml文件的内容
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.mysql" >
<resources>
<resource-root path="mysql-connector-java-5.1.7-bin.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>