<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
trying to connect to DB2 with JBOSS AS 7.0.2
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/edprairie">Mike Lupo</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/726463#726463">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Having no luck connecting to a DB2 datasource....</p><p><br/>Error received when JBOSS starts up is:</p><p>14:40:29,641 INFO  [org.jboss.as.controller] (Controller Boot Thread) Service status report<br/>  New missing/unsatisfied dependencies:<br/>      service jboss.jdbc-driver.db2jcc (missing)</p><p><br/>Here are my files:</p><p><br/>1.  in standalone.xml</p><p>in datasource section........</p><p><datasource jndi-name="java:jboss/datasources/examplesXADS" pool-name="examplesDB" enabled="true" jta="true" use-java-context="true" use-ccm="true"><br/>                    <connection-url><br/>                        jdbc:db2://blah-blah-blah.com:50000/db2:currentPackageSet=blahblah;<br/>                    </connection-url><br/>                    <driver><br/>                        db2jcc<br/>                    </driver><br/>                  <br/>                    <security><br/>                        <user-name><br/>                            my-userid----------<br/>                        </user-name><br/>                        <password><br/>                            my-password-------<br/>                        </password><br/>                    </security><br/>                    <br/>                    (....... other parms left out.........)<br/>                <br/>  </datasource><br/>  <br/>  in drivers section .........<br/>  <br/>  <driver name="db2jcc" module="com.ibm.db2"><br/>                        <xa-datasource-class><br/>                            com.ibm.db2.jcc.DB2XADataSource<br/>                        </xa-datasource-class><br/>                        <driver-class><br/>                            com.ibm.db2.jcc.DB2Driver<br/>                        </driver-class></p><p>    </driver><br/>  <br/>  <br/>  <br/>  <br/>  2.  in  /jboss-as-final-7.0.2-Final/modules/com/ibm/db2/main  (5 files)<br/>  <br/>  <br/>  A)  db2jcc.jar<br/>  B)  db2jcc.license_cisuz.jar<br/>  C)  module.xml (contents shown)<br/>  <br/>    <?xml version="1.0" encoding="UTF-8"?><br/>  <module xmlns="urn:jboss:module:1.1" name="com.ibm.db2"><br/>      <resources><br/>        <resource-root path="db2jcc.jar"/><br/>        <resource-root path="db2jcc_license_cisuz.jar"/><br/>    </resources><br/>    <dependencies><br/>        <module name="javax.api"/><br/>        <module name="javax.transaction.api"/><br/>    </dependencies><br/>  </module></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  D)  db2jcc.jar.index  (contents shown)<br/>  <br/>  META-INF<br/>  META-INF/services<br/>  com<br/>  com/ibm<br/>  com/ibm/db2<br/>  com/ibm/db2/jcc<br/>  com/ibm/db2/jcc/a<br/>  com/ibm/db2/jcc/b<br/>  com/ibm/db2/jcc/c<br/>  com/ibm/db2/jcc/resources<br/>  com/ibm/db2/jcc/sqlj<br/>  com/ibm/db2/jcc/t2<br/>  com/ibm/db2/jcc/t2zos<br/>  com/ibm/db2/jcc/uw<br/>  com/ibm/db2/jcc/uw/a<br/>  sqlj<br/>  sqlj/runtime<br/>  sqlj/runtime/error<br/>  sqlj/runtime/profile<br/>  sqlj/runtime/profile/ref<br/>  sqlj/runtime/profile/util<br/>  COM<br/>  COM/ibm<br/>  COM/ibm/db2os390<br/>  COM/ibm/db2os390/dsn<br/>  COM/ibm/db2os390/sqlj<br/>  COM/ibm/db2os390/sqlj/jdbc</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>E)  db2jcc_license.cisuz.jar.index  (contents shown)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/>  META-INF<br/>  META-INF/services<br/>  com/ibm/db2/licenses<br/>  <br/>  <br/>Has anyone had any luck with DB2 and AS V7??? </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>-Mike</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/726463#726463">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>