service jboss.jdbc-driver.ibmdb2 (missing) dependents: [service jboss.data-source.java:/testdatabase]

[pkumar7]

Hi,

  I tried to check everywhere in the form for this error, but I mostly see the answers for myqsl, oracle. I tried to replicate the same answers with db2 but I still keep getting errors. Below is my error and configuration, any help is greatly appreciated. thank you.

Using Jboss 7.1.1.final

Error:

[Server:ha-server-2] JBAS014775:    New missing/unsatisfied dependencies:

[Server:ha-server-2]       service jboss.jdbc-driver.ibmdb2 (missing) dependents: [service jboss.data-source.java:/testdatabase]

[Server:ha-server-2]

[Server:ha-server-2] 10:05:19,615 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 15113ms - Started 168 of 294 services (2 services failed or missing dependencies, 123 services are passive or on-demand)

module.xml:

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.1" name="com.ibm.db2" slot="main">

  <resources>

    <resource-root path="db2jcc.jar"/>

  </resources>

  <dependencies>

    <module name="javax.api"/>

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

  </dependencies>

</module>

domain.xml: profile - ha and full-ha

            <subsystem xmlns="urn:jboss:domain:datasources:1.0">

                <datasources>

                    <datasource jta="false" jndi-name="java:/testdatabase" pool-name="testdatabase" enabled="true" use-ccm="false">

                        <connection-url>jdbc:db2://mycompanyservername:portnumber/databasename</connection-url>

                        <driver>ibmdb2</driver>

                        <pool>

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

                            <max-pool-size>50</max-pool-size>

                        </pool>

                        <security>

                            <user-name>test</user-name>

                            <password>test123</password>

                        </security>

                        <validation>

                            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker"/>

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

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

                            <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2StaleConnectionChecker"/>

                            <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ExceptionSorter"/>

                        </validation>

                        <statement>

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

                        </statement>

                    </datasource>

                    <drivers>

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

                            <xa-datasource-class>com.ibm.db2.jdbc.DB2XADataSource</xa-datasource-class>

                        </driver>

                    </drivers>

                </datasources>

            </subsystem>

Folder structure for db2jars:

ls -tl /usr/jboss01/modules/com/ibm/db2/main/

total 2788

-rw-r--r--. 1 root root     295 Oct 14 10:04 module.xml

-rw-r--r--. 1 root root     543 Oct 14 10:02 db2jcc.jar.index

-rw-r--r--. 1 root root      38 Oct  8  2010 DB2JccConfiguration.properties

-r--r--r--. 1 root root    1015 May 12  2009 db2jcc_license_cu.jar

-rw-r--r--. 1 root root    2068 May 12  2009 db2jcc_license_cisuz.jar

-r--r--r--. 1 root root 2833724 May 12  2009 db2jcc.jar

Please let me know where am I doing wrong. Thanks again.

[lafr]

Probably there is more about the db2 driver load in the server.log file, not only the problem message at the end.

Usually all jar files in module main folder should be added to the module.xml as

<resources>

    <resource-root path="db2jcc.jar"/>

    <resource-root path="db2jcc_license_cu.jar"/>

    <resource-root path="db2jcc_license_cisuz.jar"/>

</resources>

Since you're using db2jcc.jar and not db2jcc4.jar and as you're defining a standard (non-XA) datasource, perhaps it helps to spedicfy the driver class too:

    <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

[pkumar7]

Frank,

  Thank you. That fixed the error I had.