Maybe "ORDER" is a reserved word in your DB (like Oracle).
Ciao.
On Sat, 19 May 2001 13:29:49 +1000, Lisa Stuart wrote:
>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
>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>
<body>
<p> </p>
<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
<tr>
<td width="446"><font face="Comic Sans MS"><small><small><br>
<font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/";>Franco
Biaggi</a></font><small><br>
<font color="#3333FF"><a href="http://www.sisa.ch";>SISA Studio Informatica
SA</a></font><small><small><small> <br>
</small></small></small><font color="#3333FF">R&D
Services</font><small><small><small>
<br>
</small></small></small><font color="#3333FF">Via Carvina
1</font><small><small><small> <br>
</small></small></small><font color="#3333FF">CH-6807
Taverne</font><small><small><small> <br>
</small></small></small><font color="#3333FF">Efax +1 801 705
2839</font></small></small></small><br>
</small></small></small><font color="#3333FF">Tel. +41 91 935 75 35 Fax. +41
91 935
75 30</font></small></small></small><br>
</small></small></small><font color="#3333FF">Sorry for my bad
english...</font><small><small><small> <br>
</font></td>
</tr>
</table>
</body>
</html>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
