DB2 DB connection - Jboss 7.1.1
eramesh.java Oct 25, 2013 6:49 AMHi 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