Hello,

I've been working to get EJB3 application deployed to JBoss 5.0.1 server using DB2 as the database.

This application deployed to 5.0.  This is a new 5.0.1 installation

The environment is :

     JBoss:   JBoss 5.0.1, Sun JDK 1.6.0.19,  DB2 jcc drivers

     DB2:      DB2 9.5 fp 5

                  server/jdbc:    mydb.myco.com:50000/MyData

From the JBoss system, I've installed the DB2 client and can successfully connect to the

server and database from the JBoss system.

The console messages are

------------------------------------------------------------------------------------------------------------------------------------------

20:02:28,702 INFO  [JBossASKernel] Created KernelDeployment for: MyAppEJB3.jar

20:02:28,702 INFO  [JBossASKernel] installing bean: jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3

20:02:28,702 INFO  [JBossASKernel]   with dependencies:

20:02:28,702 INFO  [JBossASKernel]   and demands:

20:02:28,702 INFO  [JBossASKernel]     persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3

20:02:28,717 INFO  [JBossASKernel]     jboss.ejb:service=EJBTimerService

20:02:28,717 INFO  [JBossASKernel]   and supplies:

20:02:28,717 INFO  [JBossASKernel]     jndi:/com/myco/my/app/ejb/MyDataSessionEJB

20:02:28,717 INFO  [JBossASKernel]     jndi:MyApp/MyDataSessionEJB3/local

20:02:28,717 INFO  [JBossASKernel]     Class:com.myco.my.app.ejb3.MyDataSessionLocal

20:02:28,717 INFO  [JBossASKernel]     jndi:MyApp/MyDataSessionEJB3/local-com.myco.my.app.ejb3.MyDataSessionLocal

20:02:28,717 INFO  [JBossASKernel] Added bean(jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3) to KernelDeployment of: MyAppEJB3.jar

20:02:30,546 WARN  [JAXWSDeployerHookPreJSE] Cannot load servlet class: com.myco.my.app.web.MyDataServlet

20:02:30,577 WARN  [JAXWSDeployerHookPreJSE] Cannot load servlet class: TestCacheServlet

20:02:30,577 WARN  [JAXWSDeployerHookPreJSE] Cannot load servlet class: com.myco.my.app.web.Test

20:02:32,655 INFO  [TomcatDeployment] deploy, ctxPath=/MyDataWeb

20:02:32,952 INFO  [ProfileServiceBootstrap] Loading profile: ProfileKey@22a7c7[domain=default, server=default, name=all]

20:02:32,952 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS MISSING DEPENDENCIES:

  Deployment "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3" is missing the following dependencies:

    Dependency "<UNKNOWN jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3' **")

  Deployment "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3_endpoint" is missing the following dependencies:

    Dependency "jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")

  Deployment "persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3" is missing the following dependencies:

    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' **")

DEPLOYMENTS IN ERROR:

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

  Deployment "<UNKNOWN jboss.j2ee:ear=MyApp.ear,jar=MyAppEJB3.jar,name=MyDataSessionEJB3,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'persistence.unit:unitName=MyApp.ear/MyAppEJB3.jar#MyAppEJB3' **

------------------------------------------------------------------------------------------------------------------------------------------

The JDBC configuration consists of :

1. JDBC drivers installed into 'server/all/lib :

               db2jcc.jar
               db2jcc_license_cu.jar

2.  server/all/deply/db2-ds.xml

<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/MyDataDataSource</jndi-name>
     <connection-url>jdbc:db2://mydb.myco.com:50000/MyData</connection-url>
     <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
    <user-name>myUser</user-name>
    <password>myPassword</password>
    <min-pool-size>20</min-pool-size>
    <max-pool-size>200</max-pool-size>
    <prepared-statement-cache-size>100</prepared-statement-cache-size>

      <metadata>
         <type-mapping>DB2</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

3.  server/all/conf/standardjbosscmp-jdbc.xml

<jbosscmp-jdbc>

   <defaults>
      <datasource>java:/jdbc/MyDataDataSource</datasource>

4.  MyApp.ear/MyAppEJB3.jar/META-INF/persistence.xml

<persistence>
    <persistence-unit name="MyAppEJB3" transaction-type="JTA">

    <jta-data-source>java:/MyDataDataSource</jta-data-source>
    <class>com.myco.my.data.entities.Acct</class>
    <class>com.myco.my.data.entities.Type</class>
    <class>com.myco.my.data.entities.CustomerName</class>
    <class>com.myco.my.data.entities.CustomerType</class>

    <properties>
         <property name="hibernate.default_schema" value="MySchema"/>
           <property name="hibernate.connection.username" value="myUser"/>
         <property name="hibernate.connection.password" value="myPasswd"/>
         <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect"/> 
        <property name="hibernate.show_sql" value="false" />
    </properties>

    </persistence-unit>
</persistence>

----------------------

I'm sure I'm overlooking something simple here, but just can't see to track it down.