2 Replies Latest reply on Oct 17, 2016 9:32 AM by Pavan Kumar

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

    Pavan Kumar Newbie

      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.