Hi,
I'm just using Hypersonic cause it's only a school project application that I'm
writing, I'll check that out though,
Thanks
Lisa.
Franco Biaggi wrote:
> 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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
