我需要在JBOSS EAP 7.0服务器中创建一个oracle数据源
我使用下面的命令从JBOSS管理CLI(命令行界面)部署了 ojdbc6.jar
deploy <PATH_TO_ORACLE_DRIVER_JAR>
部署驱动程序后,我可以看到服务器日志如下所示
01:25:53,338 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0018: Started Driver service with driver-name = ojdbc6.jar
01:25:53,747 INFO [org.jboss.as.server] (management-handler-thread - 6) WFLYSRV0010: Deployed "ojdbc6.jar" (runtime-name : "ojdbc6.jar")
但是当我尝试从Jboss管理控制台创建oracle数据源(oracle.jdbc.driver.OracleDriver作为驱动程序类)时,我得到以下错误
01:31:35,084 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 66) WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "OracleDS")
]) - failure description: {"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.driver-demander.java:/OracleDS is missing [jboss.jdbc-driver.oracle]",
"org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]"
]}
01:31:35,092 INFO [org.jboss.as.controller] (ServerService Thread Pool -- 66) WFLYCTL0183: Service status report
WFLYCTL0184: New missing/unsatisfied dependencies:
service jboss.data-source.reference-factory.OracleDS (missing) dependents: [service jboss.naming.context.java.OracleDS]
service jboss.data-source-config.OracleDS (missing) dependents: [service org.wildfly.data-source.OracleDS]
service jboss.jdbc-driver.oracle (missing) dependents: [service jboss.driver-demander.java:/OracleDS, service org.wildfly.data-source.OracleDS]
1)我可以知道造成这个问题的原因是什么吗?缺少什么依赖?
2)是否正在安装JDBC驱动程序作为JAR部署,以便为数据源创建正确的方法?
1 回答
将JDBC驱动程序安装为核心模块
在$ JBOSS_HOME / modules下创建一个目录 . 在此示例中:“$ JBOSS_HOME / modules / com / oracle / jdbc / main” .
将JDBC驱动程序jar(ojdbc6.jar)放在此目录中 .
创建模块配置文件module.xml:
示例Oracle JDBC驱动程序module.xml文件
Oracle数据源配置示例
示例管理CLI命令
可以使用以下管理CLI命令来实现此示例配置 .
1#添加Oracle JDBC驱动程序作为核心模块 .
module add --name = com.oracle --resources = / path / to / misc / jdbc_drivers / oracle / ojdbc7.jar --dependencies = javax.api,javax.transaction.api
2#注册Oracle JDBC驱动程序 .
/subsystem=datasources/jdbc-driver=oracle:add(driver-name=oracle,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)
3#添加Oracle数据源 .
data-source add --name = OracleDS --jndi-name = java:jboss / OracleDS --driver-name = oracle --connection-url = jdbc:oracle:thin:@localhost:1521:XE --user-name = admin --password = admin --validate-on-match = true --background-validation = false - valid-connection-checker-class-name = org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker --exception-sorter-class-name = org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter --stale-connection-checker-class-name = org.jboss.jca.adapters.jdbc.extensions.oracle .OracleStaleConnectionChecker
请参阅链接https://access.redhat.com/documentation/en/red-hat-jboss-enterprise-application-platform/version-7.0/configuration-guide/#datasource_management