trying to connect to DB2 with JBOSS AS 7.0.2
edprairie Mar 26, 2012 4:59 PMHaving 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