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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.