3 Replies Latest reply: Mar 27, 2012 1:39 PM by Wolf-Dieter Fink RSS

trying to connect to DB2 with JBOSS AS 7.0.2

Mike Lupo Newbie

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