3 Replies Latest reply on Nov 28, 2017 8:01 AM by Carlos Oliva

    Datasource to DB2 with jt400

    Carlos Oliva Novice

      How can I define a DB2 datasource in Wildfly 10?  I have added the jt400.jar to a module, as described in jdbc-driver.jt400_jar (missing) dependents.  I defined the driver in the datasources element.   Nevertheless, when I try to configure a data source via the administrator console, I get an error that seems to indicate that the driver is missing:

      Unexpected HTTP response: 500

       

      Request

      {

        "name" => "tfilesds",

        "jta" => true,

        "enabled" => true,

        "user-name" => "carlos",

        "password" => "working",

        "jndi-name" => "java:/tfilesDS",

        "use-ccm" => true,

        "pool-name" => "tfilesds_Pool",

        "connection-url" => "jdbc:as400://192.168.200.1",

        "driver-class" => "com.ibm.as400.access.AS400JDBCDriver",

        "driver-name" => "jt400",

        "operation" => "add",

        "address" => [

        ("subsystem" => "datasources"),

        ("data-source" => "tfilesds")

        ]

      }

       

      Response

       

      Internal Server Error

      {

        "outcome" => "failed",

        "failure-description" => {

        "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.jt400"],

        "WFLYCTL0180: Services with missing/unavailable dependencies" => [

        "org.wildfly.data-source.tfilesds is missing [jboss.jdbc-driver.jt400]",

        "jboss.driver-demander.java:/tfilesDS is missing [jboss.jdbc-driver.jt400]"

        ]

        },

        "rolled-back" => true

      }