2 Replies Latest reply on Oct 19, 2017 4:07 AM by tarak.paruchuru

    db2 JDBC driver issue

    tarak.paruchuru

      Server log

       

      04:05:22,654 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "TaxPortal.war" (runtime-name : "TaxPortal.war")

      04:05:22,655 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "GCRT.war" (runtime-name : "GCRT.war")

      04:05:22,657 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.db2 (missing) dependents: [service jboss.data-source.java:/jdbc/taxportalDBDS, service jboss.driver-demander.java:/jdbc/taxportalDBDS]

      JBAS014777:   Services which failed to start:      service jboss.web.deployment.default-host./TaxPortal: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./TaxPortal: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context

       

      04:05:22,678 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://0.0.0.0:10290/management

      04:05:22,678 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://0.0.0.0:10290

      04:05:22,679 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.2.0.Final "Janus" started (with errors) in 45791ms - Started 743 of 810 services (5 services failed or missing dependencies, 59 services are passive or on-demand)

       

      Caused by: javax.naming.NameNotFoundException: Error looking up jdbc/taxportalDBDS, service service jboss.naming.context.java.jdbc.taxportalDBDS is not started

              at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:132)

              at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:80)

              at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:197)

              at org.jboss.as.naming.InitialContext.lookup(InitialContext.java:120)

              at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:183)

              at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:179)

              at javax.naming.InitialContext.lookup(InitialContext.java:411) [rt.jar:1.7.0_45]

              at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:155) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:179) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:106) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:231) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:217) [spring-context-4.3.0.RELEASE.jar:4.3.0.RELEASE]

              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) [spring-beans-4.

      3.0.RELEASE.jar:4.3.0.RELEASE]

       

      04:04:39,581 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 25) JBAS014613: Operation ("add") failed - address: ([

          ("subsystem" => "datasources"),

          ("jdbc-driver" => "db2")

      ]) - failure description: "JBAS01

      ]) - failure description: "JBAS010441: Failed to load module for driver [com.ibm.db2]"

       

       

       

      have updated the JDBC versions

      In standalaonne.xml

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

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

      </driver>

      </drivers>

       

      placed drivers under

       

      /usr/local/jboss7.2/modules/system/layers/base/com/ibm/db2/main

       

      Content of module.xml

      <module xmlns="urn:jboss:module:1.0" name="com.ibm.db2.jcc">

      <resources>

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

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

      </resources>

      <dependencies>

      <module name="javax.api"/>

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

      <module name="javax.servlet.api" optional="true"/>

      </dependencies>

      </module>

        • 1. Re: db2 JDBC driver issue
          paramjindal

          It is failing because your DB2 driver not loaded properly.

          Since your JDBC driver is placed under /usr/local/jboss7.2/modules/system/layers/base/com/ibm/db2/main you need to have the following path in your module.xml file :

           

          <module xmlns="urn:jboss:module:1.0" name="com.ibm.db2">

           

          instead of :

          <module xmlns="urn:jboss:module:1.0" name="com.ibm.db2.jcc">

           

          -Param

          1 of 1 people found this helpful
          • 2. Re: db2 JDBC driver issue
            tarak.paruchuru

            Changes were made to path in module.xml file and issue got resolved.