While creating a datasource for DB2 database via JBOSS 6.1.1, I am getting an error JBAS010440.
Following are the configuration details I am using:
Updated Standalone.xml with following details:
<datasource jta="false" jndi-name="java:jboss/datasources/myDataSourcetDS" pool-name="myDataSourcetDS" use-java-context="true" use-ccm="false">
<connection-url>jdbc:db2://localhost:XXXX/DB2</connection-url>
<driver>db2</driver>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>10</max-pool-size>
<prefill>true</prefill>
<use-strict-min>true</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>XXXXXX</user-name>
<password>XXXXX</password>
</security>
<timeout>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</datasource>
<driver name="db2" module="com.db2database.db2">
<xa-datasource-class>com.ibm.db2.jcc.DB2Driver</xa-datasource-class>
</driver>
And module.xml with following details:
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="com.db2database.db2">
<properties>
<property name="jboss.api" value="unsupported"/>
</properties>
<resources>
<resource-root path="db2jcc.jar"/>
<resource-root path="db2jcc_license_cisuz.jar"/>
<resource-root path="db2jcc_license_cu.jar"/>
</resources>
</module>
But still I am getting following error JBAS010440: failed to invoke operation: JBAS010442: failed to match pool.
I was able to find a solution to this problem. Instead of using db2jcc.jar, db2jcc_license_cisuz.jar and db2jcc_license_cu.jar use the latest jar which is db2jcc4.jar