Issues when creating IBM DB2 datasource in EAP
Issue
-
Unable to make
DB2 XA Datasource- I receive the following error when I try to add the datasource under the management console and test connection:
"failure-description" => {"JBAS014653: Composite operation failed and was rolled back.Steps that failed:" => {"Operation step-1" => {"JBAS014771: Services with missing/unavailable dependencies"=> ["jboss.driver-demander.java:/jdbc/DB2Ds is missing [jboss.jdbc-driver.db2JDBCDriver]"]}}},
"rolled-back" => true
}
- I added the module in the jboss-cli with the command:
module add --name=com.ibm.db2.jdbc --resources=$EAP_HOME/db2/db2jcc.jar;$EAP_HOME/db2/db2jcc_license_*.jar --dependencies=javax.api,javax.transaction.api
- Then I added the driver subsystem with:
/subsystem=datasources/jdbc-driver=db2JDBCDriver:add(driver-module-name=com.ibm.db2.jdbc,driver-name=db2JDBCDriver,driver-xa-datasource-class-name=com.ibm.db2.jcc.DB2XADataSource)
- When I list the jdbc-driver subystems in the jboss-cli (ls subsystem=datasources/jdbc-driver) I see two:
db2JDBCDriver and h2
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.4.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.