[jboss-user] [Datasource Configuration] - trying to connect to DB2 with JBOSS AS 7.0.2

[Mike Lupo]

Mike Lupo [https://community.jboss.org/people/edprairie] created the discussion

"trying to connect to DB2 with JBOSS AS 7.0.2"

To view the discussion, visit: https://community.jboss.org/message/726463#726463

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/726463#726463]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120326/b7830daf/attachment.html