Issues when creating IBM DB2 datasource in EAP

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content