Do you have jaws.xml file and if so could you paste it into a message so we
could see your code.
Ivan
----- Original Message -----
From: "Lisa Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 8:29 PM
Subject: [JBoss-user] CMP table for entity bean never being created
> 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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
