1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Anuncie Aqui
    Anuncie aqui você Também: fdantas@4each.com.br

Configure jt400 xa-datasource in JBoss EAP 7 standalone.xml

Discussão em 'StackOverflow' iniciado por Stack, Janeiro 21, 2021.

  1. Stack

    Stack Membro Participativo

    I have as400 driver file (jt400.jar) in c:\jboss-EAP7\modules\com\ibm\main\ with the corresponding module.xml

    <?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.1" name="com.ibm">
    <resources>
    <resource-root path="jt400.jar"/>
    </resources>
    <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
    <module name="javax.servlet.api" optional="true"/>
    </dependencies>
    </module>


    Here is the datasource configuration in my standalone.xml:

    <subsystem xmlns="urn:jboss:domain:datasources:4.0">
    <datasources>
    <xa-datasource jndi-name="java:/ds/DB2DataSource" pool-name="ds/DB2DataSource" enabled="true" use-java-context="true" use-ccm="true">
    <xa-datasource-property name="ServerName">
    xxx.xx.xxx.x
    </xa-datasource-property>
    <driver>as400</driver>
    <xa-pool>
    <is-same-rm-override>false</is-same-rm-override>
    <no-tx-separate-pools>true</no-tx-separate-pools>
    <interleaving>false</interleaving>
    <pad-xid>false</pad-xid>
    <wrap-xa-resource>false</wrap-xa-resource>
    </xa-pool>
    <security>
    <user-name>user</user-name>
    <password>pass</password>
    </security>
    <validation>
    <validate-on-match>false</validate-on-match>
    <background-validation>false</background-validation>
    </validation>
    <statement>
    <share-prepared-statements>false</share-prepared-statements>
    </statement>
    </xa-datasource>
    <drivers>
    <driver name="as400" module="com.ibm">
    <xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
    </driver>
    </drivers>
    </datasources>
    </subsystem>


    I have the following problem in the datasource binding:

    15:44:00,482 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("xa-data-source" => "ds/DB2DataSource")
    ]) - failure description: {"WFLYCTL0180: Services with missing/unavailable dependencies" => [
    "jboss.driver-demander.java:/ds/DB2DataSource is missing [jboss.jdbc-driver.as400]",
    "org.wildfly.data-source.ds/DB2DataSource is missing [jboss.jdbc-driver.as400]"
    ]}
    15:44:00,485 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("xa-data-source" => "ds/DB2DataSource")
    ]) - failure description: {"WFLYCTL0180: Services with missing/unavailable dependencies" => [
    "jboss.driver-demander.java:/ds/DB2DataSource is missing [jboss.jdbc-driver.as400]",
    "org.wildfly.data-source.ds/DB2DataSource is missing [jboss.jdbc-driver.as400]",
    "org.wildfly.data-source.ds/DB2DataSource is missing [jboss.jdbc-driver.as400]"
    ]}


    What am I doing wrong? Please note that the connection is successful with the same parameters when using a SQLClient (e.g. DBeaver).

    Thanks

    Continue reading...

Compartilhe esta Página