Hi Team,

We are doing migration from Jboss4 to Jboss 7.1.1 Final.

I am not able to connect DB2.

Please find my ds.xml file which is currently working in Jboss4.

<datasources>

  <local-tx-datasource>

    <jndi-name>jdbc/exampleDS</jndi-name>

    <connection-url>jdbc:as400://xxxxx;transaction isolation=none</connection-url>

    <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>

    <user-name>xxx</user-name>

    <password>xxx</password>

    <min-pool-size>0</min-pool-size>

  <background-validation>true</background-validation>

  <background-validation-minutes>3</background-validation-minutes>

  <new-connection-sql> SELECT COUNT(*) FROM xxxx </new-connection-sql>

  <check-valid-connection-sql> SELECT COUNT(*) FROM xxxx</check-valid-connection-sql>

    <metadata>

      <type-mapping>DB2/400</type-mapping>

    </metadata>

  </local-tx-datasource>

Accordingly I have configured in standalone.xml  file

<datasource jndi-name="java:jboss/datasources/exampleDS" pool-name="exampleDS" enabled="true" use-ccm="false">

                    <connection-url>>jdbc:as400://xxx;transaction isolation=none</connection-url>

                    <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>

                    <driver>oracle</driver>

                    <new-connection-sql>SELECT COUNT(*) FROM xxx</new-connection-sql>

                    <security>

                        <user-name>xxx</user-name>

                        <password>xxx</password>

                    </security>

                    <validation>

                        <check-valid-connection-sql>SELECT COUNT(*) FROM xxx</check-valid-connection-sql>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>true</background-validation>

                        <background-validation-millis>3</background-validation-millis>

                    </validation>

                    <statement>

                        <share-prepared-statements>false</share-prepared-statements>

                    </statement>

                </datasource>

               <drivers>

                    <driver name="db2" module="com.ibm.as400">

                         <xa-datasource-class>com.ibm.as400.access.AS400JDBCDriver</xa-datasource-class>

                    </driver>

               </drivers>

Module.xml

<module xmlns="urn:jboss:module:1.0" name="com.ibm.as400">
<resources>
<resource-root path="jt400.jar"/>
</resources>

<dependencies>  
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>

Now I am getting the below exception.

JBAS014775: New missing/unsatisfied dependencies: service jboss.jdbc-driver.oracle (missing) dependents:

Could you please advise!

Regards,

Kumar