3 Replies Latest reply on Mar 27, 2012 1:39 PM by wdfink

    trying to connect to DB2 with JBOSS AS 7.0.2

    edprairie

      Having no luck connecting to a DB2 datasource....


      Error received when JBOSS starts up is:

      14:40:29,641 INFO  [org.jboss.as.controller] (Controller Boot Thread) Service status report
        New missing/unsatisfied dependencies:
            service jboss.jdbc-driver.db2jcc (missing)


      Here are my files:


      1.  in standalone.xml

      in datasource section........

      <datasource jndi-name="java:jboss/datasources/examplesXADS" pool-name="examplesDB" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                          <connection-url>
                              jdbc:db2://blah-blah-blah.com:50000/db2:currentPackageSet=blahblah;
                          </connection-url>
                          <driver>
                              db2jcc
                          </driver>
                       
                          <security>
                              <user-name>
                                  my-userid----------
                              </user-name>
                              <password>
                                  my-password-------
                              </password>
                          </security>
                         
                          (....... other parms left out.........)
                     
        </datasource>
       
        in drivers section .........
       
        <driver name="db2jcc" module="com.ibm.db2">
                              <xa-datasource-class>
                                  com.ibm.db2.jcc.DB2XADataSource
                              </xa-datasource-class>
                              <driver-class>
                                  com.ibm.db2.jcc.DB2Driver
                              </driver-class>

          </driver>
       
       
       
       
        2.  in  /jboss-as-final-7.0.2-Final/modules/com/ibm/db2/main  (5 files)
       
       
        A)  db2jcc.jar
        B)  db2jcc.license_cisuz.jar
        C)  module.xml (contents shown)
       
          <?xml version="1.0" encoding="UTF-8"?>
        <module xmlns="urn:jboss:module:1.1" name="com.ibm.db2">
            <resources>
              <resource-root path="db2jcc.jar"/>
              <resource-root path="db2jcc_license_cisuz.jar"/>
          </resources>
          <dependencies>
              <module name="javax.api"/>
              <module name="javax.transaction.api"/>
          </dependencies>
        </module>

       

        D)  db2jcc.jar.index  (contents shown)
       
        META-INF
        META-INF/services
        com
        com/ibm
        com/ibm/db2
        com/ibm/db2/jcc
        com/ibm/db2/jcc/a
        com/ibm/db2/jcc/b
        com/ibm/db2/jcc/c
        com/ibm/db2/jcc/resources
        com/ibm/db2/jcc/sqlj
        com/ibm/db2/jcc/t2
        com/ibm/db2/jcc/t2zos
        com/ibm/db2/jcc/uw
        com/ibm/db2/jcc/uw/a
        sqlj
        sqlj/runtime
        sqlj/runtime/error
        sqlj/runtime/profile
        sqlj/runtime/profile/ref
        sqlj/runtime/profile/util
        COM
        COM/ibm
        COM/ibm/db2os390
        COM/ibm/db2os390/dsn
        COM/ibm/db2os390/sqlj
        COM/ibm/db2os390/sqlj/jdbc

       

      E)  db2jcc_license.cisuz.jar.index  (contents shown)

       


        META-INF
        META-INF/services
        com/ibm/db2/licenses
       
       
      Has anyone had any luck with DB2 and AS V7???

       

      -Mike