1 Reply Latest reply on Mar 3, 2015 11:47 AM by rajatsudan

    Datasource issue while connecting to DB2

    rajatsudan

      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.