<!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="http://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;">
    Unable to get EJB3 loaded on 5.0.1
</h3>
<span style="margin-bottom: 10px;">
    created by <a href="http://community.jboss.org/people/heyyou">Its Me</a> in <i>JCA</i> - <a href="http://community.jboss.org/message/555480#555480">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">

<div class="jive-rendered-content"><p>Hello,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>I've been working to get EJB3 application deployed to JBoss 5.0.1 server using DB2 as the database.</p><p>This application deployed to 5.0.&#160; This is a new 5.0.1 installation</p><p>The environment is :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>&#160;&#160;&#160;&#160; JBoss:&#160;&#160; JBoss 5.0.1, Sun JDK 1.6.0.19,&#160; DB2 jcc drivers</p><p>&#160;&#160;&#160;&#160; DB2:&#160;&#160;&#160;&#160;&#160; DB2 9.5 fp 5</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; server/jdbc:&#160;&#160;&#160; mydb.myco.com:50000/MyData</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>From the JBoss system, I've installed the DB2 client and can successfully connect to the</p><p>server and database from the JBoss system.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>The console messages are</p><p>------------------------------------------------------------------------------------------------------------------------------------------</p><p><span style="font-size: 8pt;">20:02:28,702 INFO&#160; [JBossASKernel] Created KernelDeployment for: MyAppEJB3.jar<br/></span></p><p><span style="font-size: 8pt;">20:02:28,702 INFO&#160; [JBossASKernel] installing bean: jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3<br/></span></p><p><span style="font-size: 8pt;">20:02:28,702 INFO&#160; [JBossASKernel]&#160;&#160; with dependencies:<br/></span></p><p><span style="font-size: 8pt;">20:02:28,702 INFO&#160; [JBossASKernel]&#160;&#160; and demands:<br/></span></p><p><span style="font-size: 8pt;">20:02:28,702 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; jboss.ejb:service=EJBTimerService<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160; and supplies:<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; jndi:/com/myco/my/app/ejb/MyDataSessionEJB<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; jndi:MyApp/MyDataSessionEJB3/local<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; Class:com.myco.my.app.ejb3.MyDataSessionLocal<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel]&#160;&#160;&#160;&#160; jndi:MyApp/MyDataSessionEJB3/local-com.myco.my.app.ejb3.MyDataSessionLocal<br/></span></p><p><span style="font-size: 8pt;">20:02:28,717 INFO&#160; [JBossASKernel] Added bean(jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3) to KernelDeployment of: MyAppEJB3.jar<br/></span></p><p><span style="font-size: 8pt;">20:02:30,546 WARN&#160; [JAXWSDeployerHookPreJSE] Cannot load servlet class: com.myco.my.app.web.MyDataServlet<br/></span></p><p><span style="font-size: 8pt;">20:02:30,577 WARN&#160; [JAXWSDeployerHookPreJSE] Cannot load servlet class: TestCacheServlet<br/></span></p><p><span style="font-size: 8pt;">20:02:30,577 WARN&#160; [JAXWSDeployerHookPreJSE] Cannot load servlet class: com.myco.my.app.web.Test<br/></span></p><p><span style="font-size: 8pt;">20:02:32,655 INFO&#160; [TomcatDeployment] deploy, ctxPath=/MyDataWeb<br/></span></p><p><span style="font-size: 8pt;">20:02:32,952 INFO&#160; [ProfileServiceBootstrap] Loading profile: ProfileKey@22a7c7[domain=default, server=default, name=all]<br/></span></p><p><span style="font-size: 8pt;">20:02:32,952 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS): </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"><span style="font-size: 8pt;"> </span>&#160;</p><p><span style="font-size: 8pt;"> DEPLOYMENTS MISSING DEPENDENCIES:<br/></span></p><p><span style="font-size: 8pt;">&#160; Deployment "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3" is missing the following dependencies:<br/></span></p><p><span style="font-size: 8pt;">&#160;&#160;&#160; Dependency "&lt;UNKNOWN jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3&gt;" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3' **")<br/></span></p><p><span style="font-size: 8pt;">&#160; Deployment "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3_endpoint" is missing the following dependencies:<br/></span></p><p><span style="font-size: 8pt;">&#160;&#160;&#160; Dependency "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")<br/></span></p><p><span style="font-size: 8pt;">&#160; Deployment "persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3" is missing the following dependencies:<br/></span></p><p><span style="font-size: 8pt;">&#160;&#160;&#160; Dependency "jboss.jca:name=MyDataDataSource,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=MyDataDataSource,service=DataSourceBinding' **") </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"><span style="font-size: 8pt;"> </span>&#160;</p><p><span style="font-size: 8pt;"> DEPLOYMENTS IN ERROR:<br/></span></p><p><span style="font-size: 8pt;">&#160; Deployment "jboss.jca:name=MyDataDataSource,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=MyDataDataSource,service=DataSourceBinding' **<br/></span></p><p><span style="font-size: 8pt;">&#160; Deployment "&lt;UNKNOWN jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3&gt;" is in error due to the following reason(s): ** UNRESOLVED Demands 'persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3' **</span></p><p><br/> ------------------------------------------------------------------------------------------------------------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>The JDBC configuration consists of :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>1. JDBC drivers installed into 'server/all/lib :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; db2jcc.jar<br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; db2jcc_license_cu.jar</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>2.&#160; server/all/deply/db2-ds.xml</p><p><span style="font-size: 8pt;">&lt;datasources&gt;<br/>&#160; &lt;local-tx-datasource&gt;<br/>&#160;&#160;&#160; &lt;jndi-name&gt;jdbc/MyDataDataSource&lt;/jndi-name&gt;<br/>&#160;&#160;&#160;&#160; &lt;connection-url&gt;jdbc:db2://mydb.myco.com:50000/MyData&lt;/connection-url&gt;<br/>&#160;&#160;&#160;&#160; &lt;driver-class&gt;com.ibm.db2.jcc.DB2Driver&lt;/driver-class&gt;<br/>&#160;&#160;&#160; &lt;user-name&gt;myUser&lt;/user-name&gt;<br/>&#160;&#160;&#160; &lt;password&gt;myPassword&lt;/password&gt;<br/>&#160;&#160;&#160; &lt;min-pool-size&gt;20&lt;/min-pool-size&gt;<br/>&#160;&#160;&#160; &lt;max-pool-size&gt;200&lt;/max-pool-size&gt;<br/>&#160;&#160;&#160; &lt;prepared-statement-cache-size&gt;100&lt;/prepared-statement-cache-size&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160;&#160;&#160;&#160; &lt;metadata&gt;<br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;type-mapping&gt;DB2&lt;/type-mapping&gt;<br/>&#160;&#160;&#160;&#160;&#160; &lt;/metadata&gt;<br/>&#160; &lt;/local-tx-datasource&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&lt;/datasources&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>3.&#160; server/all/conf/standardjbosscmp-jdbc.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>&lt;jbosscmp-jdbc&gt;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160; &lt;defaults&gt;<br/>&#160;&#160;&#160;&#160;&#160; &lt;datasource&gt;java:/jdbc/MyDataDataSource&lt;/datasource</span>&gt;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>4.&#160; MyApp.ear/MyAppEJB3.jar/META-INF/persistence.xml</p><p><span style="font-size: 8pt;">&lt;persistence&gt;<br/>&#160;&#160;&#160; &lt;persistence-unit name="MyAppEJB3" transaction-type="JTA"&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160;&#160; &lt;jta-data-source&gt;java:/MyDataDataSource&lt;/jta-data-source&gt;<br/>&#160;&#160;&#160; &lt;class&gt;com.myco.my.data.entities.Acct&lt;/class&gt;<br/>&#160;&#160;&#160; &lt;class&gt;com.myco.my.data.entities.Type&lt;/class&gt;<br/>&#160;&#160;&#160; &lt;class&gt;com.myco.my.data.entities.CustomerName&lt;/class&gt;<br/>&#160;&#160;&#160; &lt;class&gt;com.myco.my.data.entities.CustomerType&lt;/class&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160;&#160; &lt;properties&gt;<br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;property name="hibernate.default_schema" value="MySchema"/&gt;<br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;property name="hibernate.connection.username" value="myUser"/&gt;<br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;property name="hibernate.connection.password" value="myPasswd"/&gt; <br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect"/&gt;&#160; <br/>&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;property name="hibernate.show_sql" value="false" /&gt;<br/>&#160;&#160;&#160; &lt;/properties&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><span style="font-size: 8pt;">&#160;&#160;&#160; &lt;/persistence-unit&gt;<br/>&lt;/persistence&gt;</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>----------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>I'm sure I'm overlooking something simple here, but just can't see to track it down.</p></div>

<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
    <p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/555480#555480">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in JCA at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098">Community</a></p>
</div></td>
                        </tr>
                    </tbody>
                </table>


                </td>
            </tr>
        </tbody>
    </table>

</div>

</body>
</html>