Hi all,
I'm hoping for some help...
I have got three entity beans and one session bean that use CMP and are
deployed successfully.
The entity beans are Product, LineItem and Order.
This is what I get at deploy,

[Container factory] Deploying Product
[Container factory] Deploying Order
[Container factory] Deploying LineItem
[Container factory] Deploying AllProds
[JAWS] Table 'Product' already exists
[JAWS] Table 'LineItem' already exists
[Container factory] Deployed application:
file:/misc/brian_d/jboss/jboss/tmp/deploy/Default/test.jar/
[J2EE Deployer Default] J2EE application:
file:/misc/brian_d/jboss/jboss/deploy/test.jar is deployed.

The table for Order is never being created and the program craps out
when I try to create an Order from a servlet,

[EmbeddedTomcat] got orderHome
[EmbeddedTomcat] javax.ejb.CreateException: Could not create
entity:java.sql.SQLException: Table not found: ORDER in statement
[INSERT INTO Order (id) VALUES ('001')]

If anyone can help I'd really appreciate it...thanks,

Lisa

In case it is a desriptor problem here is my ejb-jar.xml

<?xml version="1.0" encoding="UTF-8"?>

 <ejb-jar>
    <description>Product Viewing Example</description>
    <display-name>Test</display-name>
    <enterprise-beans>

       <session>
          <ejb-name>AllProds</ejb-name>
          <home>AllProductsHome</home>
          <remote>AllProducts</remote>
          <ejb-class>AllProductsBean</ejb-class>
          <session-type>Stateless</session-type>
          <transaction-type>Bean</transaction-type>
          <ejb-ref>
             <ejb-ref-name>ejb/Product</ejb-ref-name>
             <ejb-ref-type>Entity</ejb-ref-type>
             <home>ProductHome</home>
             <remote>Product</remote>
             <ejb-link>Product</ejb-link>
         </ejb-ref>
       </session>

 <entity>
   <ejb-name>Product</ejb-name>
   <home>ProductHome</home>
   <remote>Product</remote>
   <ejb-class>ProductBean</ejb-class>
   <persistence-type>Container</persistence-type>
   <prim-key-class>java.lang.String</prim-key-class>
   <reentrant>False</reentrant>
   <cmp-field><field-name>id</field-name></cmp-field>
   <cmp-field><field-name>name</field-name></cmp-field>
   <cmp-field><field-name>desc</field-name></cmp-field>
   <cmp-field><field-name>unit</field-name></cmp-field>
   <cmp-field><field-name>price</field-name></cmp-field>
   <primkey-field>id</primkey-field>
 </entity>

 <entity>
   <ejb-name>Order</ejb-name>
   <home>OrderHome</home>
   <remote>Order</remote>
   <ejb-class>OrderBean</ejb-class>
   <persistence-type>Container</persistence-type>
   <prim-key-class>java.lang.String</prim-key-class>
   <reentrant>False</reentrant>
   <cmp-field><field-name>id</field-name></cmp-field>
   <primkey-field>id</primkey-field>
   <ejb-ref>
      <ejb-ref-name>ejb/LineItem</ejb-ref-name>
      <ejb-ref-type>Entity</ejb-ref-type>
      <home>LineItemHome</home>
      <remote>LineItem</remote>
      <ejb-link>LineItem</ejb-link>
   </ejb-ref>
 </entity>

<entity>
   <ejb-name>LineItem</ejb-name>
   <home>LineItemHome</home>
   <remote>LineItem</remote>
   <ejb-class>LineItemBean</ejb-class>
   <persistence-type>Container</persistence-type>
   <prim-key-class>java.lang.String</prim-key-class>
   <reentrant>False</reentrant>
   <cmp-field><field-name>id</field-name></cmp-field>
   <cmp-field><field-name>productPK</field-name></cmp-field>
   <cmp-field><field-name>orderPK</field-name></cmp-field>
   <cmp-field><field-name>qty</field-name></cmp-field>
   <primkey-field>id</primkey-field>
   <ejb-ref>
      <ejb-ref-name>ejb/Product</ejb-ref-name>
      <ejb-ref-type>Entity</ejb-ref-type>
      <home>ProductHome</home>
      <remote>Product</remote>
      <ejb-link>Product</ejb-link>
   </ejb-ref>
   <ejb-ref>
     <ejb-ref-name>ejb/Order</ejb-ref-name>
     <ejb-ref-type>Entity</ejb-ref-type>
     <home>OrderHome</home>
     <remote>Order</remote>
     <ejb-link>Order</ejb-link>
   </ejb-ref>
 </entity>
</enterprise-beans>
</ejb-jar>



_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to