Also, the database schema and mapping in jbosscmp-jdbc.xml are congruent. I've
included both the sql for the database schema and
the jbosscmp-jdbc.xml.
Louis Leung wrote:
> I'm trying to run PurchaseOrder with 2 Local Enitities PurchaseOrder & LineItems,
> with a 1:N relationship between them. LineItem
> Entity has a CMP field (masterOrder_orderId) which is part of primary key and is
> also maps the masterOrder relationship with
> PurchaseOrder.
>
> Alexey Loubyansky wrote:
>
> > Hello Louis,
> >
> > you mean foreign key field mapped to primary key? yes, it is
> > supported. Make sure the database schema and mapping in
> > jbosscmp-jdbc.xml are congruent.
> >
> > alex
> >
> > Wednesday, June 25, 2003, 8:48:42 PM, Louis Leung wrote:
> >
> > LL> Thanks Alex for your help. The tables are not created by JBossCMP. The
> > strange thing is this exception only occurs when
> > LL> the primary key is composed of a foreign key. Would you know if this is
> > supported in JBoss ?
> >
> > LL> Alexey Loubyansky wrote:
> >
> > >> Hello Louis,
> > >>
> > >> the exception is thrown from create method. It is the result of
> > >> checking whether the instance already exists. It selects primary key
> > >> columns. Not foreign key.
> > >> Does JBossCMP create tables in the db? Check the primary key
> > >> configuration.
> > >>
> > >> alex
> > >>
> > >> Wednesday, June 25, 2003, 2:26:32 AM, Louis Leung wrote:
> > >>
> > >> LL> Hi all,
> > >>
> > >> LL> My application has a 1 to many CMR (i.e. one being a purchase order ,
> > >> LL> and many being line items). I don't think i've specified the column
> > >> LL> mapping for this relationship wrong. JBoss should be firing "Select
> > >> LL> MASTERORDER ..." sql when retreiving info about this relation. But
> > >> LL> instead, it fired "Select MASTERORDER_ORDERID ...". I have no idea why
> > >> LL> did it appended the _ORDERID at the end. Here is a snippet of the
> > >> LL> relation mapping xml in jbosscmp-jdbc.xml:
> > >>
> > >> LL> <!-- Relationships -->
> > >> LL> <relationships>
> > >> LL> <ejb-relation>
> > >>
> > >> LL>
> > >> <ejb-relation-name>PurchaseOrderBean-lineItems-masterOrder-LineItemBean</ejb-relation-name>
> > >>
> > >> LL> <foreign-key-mapping/>
> > >> LL> <ejb-relationship-role>
> > >>
> > >> LL>
> > >> <ejb-relationship-role-name>PurchaseOrderBean-lineItems-LineItemBean</ejb-relationship-role-name>
> > >>
> > >> LL> <key-fields>
> > >> LL> <key-field>
> > >> LL> <field-name>orderId</field-name>
> > >> LL> <column-name>MASTERORDER</column-name>
> > >> LL> </key-field>
> > >> LL> </key-fields>
> > >> LL> </ejb-relationship-role>
> > >> LL> <ejb-relationship-role>
> > >>
> > >> LL>
> > >> <ejb-relationship-role-name>LineItemBean-masterOrder-PurchaseOrderBean</ejb-relationship-role-name>
> > >>
> > >> LL> </ejb-relationship-role>
> > >> LL> </ejb-relation>
> > >> LL> </relationships>
> > >>
> > >> LL> Anyone has any idea ? I've included the exception that JBoss throws as
> > >> LL> well. Thanks.
> > >>
> > >> LL> Louis
> > >>
> > >> LL> 16:15:48,645 ERROR [LineItemBean] Error checking if entity exists
> > >> LL> java.sql.SQLException: Column "MASTERORDER_ORDERID" not found in table
> > >> LL> at position 36.
> > >> LL> at
> > >> LL> com.pointbase.net.netJDBCPrimitives.handleResponse(DashOB3242)
> > >> LL> at
> > >> LL> com.pointbase.net.netJDBCPrimitives.handleJDBCObjectResponse(DashOB3242)
> > >>
> > >> LL> at
> > >> LL> com.pointbase.net.netJDBCConnection.prepareStatement(DashOB3242)
> > >> LL> at
> > >> LL>
> > >> org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:221)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.entityExists(JDBCCreateEntityCommand.java:230)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:204)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
> > >>
> > >> LL> at
> > >> LL> org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:571)
> > >> LL> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >> LL> at
> > >> LL>
> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > >>
> > >> LL> at
> > >> LL>
> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > >>
> > >> LL> at java.lang.reflect.Method.invoke(Method.java:324)
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
> > >>
> > >> LL> at
> > >> LL> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
> > >>
> > >> LL> at
> > >> LL> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
> > >>
> > >> LL> at
> > >> LL> org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
> > >>
> > >> LL> at org.jboss.ejb.Container.invoke(Container.java:694)
> > >> LL> at
> > >> LL>
> > >> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
> > >>
> > >> LL> at
> > >> LL> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
> > >>
> > >> LL> at $Proxy34.create(Unknown Source)
> > >> LL> at
> > >> LL>
> > >> com.sun.purchaseorder.entity.LineItemFactory.create(LineItemFactory.java:248)
> > >>
> > >> LL> at
> > >> LL>
> > >> com.sun.purchaseorder.struts.EditPOAction.makeTransitionAddLineItem(EditPOAction.java:155)
> > >>
> > >> LL> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >> LL> at
> > >> LL>
> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > >>
> > >> LL> at
> > >> LL>
> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > >>
> > >> LL> at java.lang.reflect.Method.invoke(Method.java:324)
> > >> LL> at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceAbstractAction.execute(AceAbstractAction.java:47)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> > >>
> > >> LL> at
> > >> LL> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> > >>
> > >> LL> at
> > >> LL> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
> > >> LL> at
> > >> LL> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
> > >> LL> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > >> LL> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceGenericFilter.doFilter(AceGenericFilter.java:49)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> at
> > >> LL> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> at
> > >> LL> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> > >> LL> at
> > >> LL> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
> > >>
> > >> LL> at
> > >> LL> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> > >>
> > >> LL> at
> > >> LL>
> > >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
> > >>
> > >> LL> at java.lang.Thread.run(Thread.java:536)
> > >> LL> 16:15:49,917 ERROR [STDERR] javax.ejb.CreateException: Error checking if
> > >> LL> entity exists:java.sql.SQLException: Column "MASTERORDER_ORDERID" not
> > >> LL> found i
> > >> LL> n table at position 36.
> > >> LL> 16:15:49,947 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.entityExists(JDBCCreateEntityCommand.java:248)
> > >>
> > >> LL> 16:15:49,967 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:204)
> > >>
> > >> LL> 16:15:49,977 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569)
> > >>
> > >> LL> 16:15:49,997 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225)
> > >>
> > >> LL> 16:15:50,017 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
> > >>
> > >> LL> 16:15:50,057 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:571)
> > >> LL> 16:15:50,067 ERROR [STDERR] at
> > >> LL> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >> LL> 16:15:50,087 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > >>
> > >> LL> 16:15:50,107 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > >>
> > >> LL> 16:15:50,127 ERROR [STDERR] at
> > >> LL> java.lang.reflect.Method.invoke(Method.java:324)
> > >> LL> 16:15:50,147 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998)
> > >>
> > >> LL> 16:15:50,167 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
> > >>
> > >> LL> 16:15:50,187 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188)
> > >>
> > >> LL> 16:15:50,197 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
> > >>
> > >> LL> 16:15:50,217 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
> > >>
> > >> LL> 16:15:50,247 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
> > >>
> > >> LL> 16:15:50,267 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
> > >>
> > >> LL> 16:15:50,277 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
> > >>
> > >> LL> 16:15:50,297 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
> > >>
> > >> LL> 16:15:50,317 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
> > >>
> > >> LL> 16:15:50,337 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
> > >>
> > >> LL> 16:15:50,357 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
> > >>
> > >> LL> 16:15:50,377 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
> > >>
> > >> LL> 16:15:50,387 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
> > >>
> > >> LL> 16:15:50,407 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
> > >>
> > >> LL> 16:15:50,427 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.Container.invoke(Container.java:694)
> > >> LL> 16:15:50,437 ERROR [STDERR] at
> > >> LL>
> > >> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
> > >>
> > >> LL> 16:15:50,457 ERROR [STDERR] at
> > >> LL> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
> > >>
> > >> LL> 16:15:50,477 ERROR [STDERR] at $Proxy34.create(Unknown Source)
> > >> LL> 16:15:50,497 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.purchaseorder.entity.LineItemFactory.create(LineItemFactory.java:248)
> > >>
> > >> LL> 16:15:50,517 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.purchaseorder.struts.EditPOAction.makeTransitionAddLineItem(EditPOAction.java:155)
> > >>
> > >> LL> 16:15:50,527 ERROR [STDERR] at
> > >> LL> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >> LL> 16:15:50,558 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > >>
> > >> LL> 16:15:50,568 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > >>
> > >> LL> 16:15:50,588 ERROR [STDERR] at
> > >> LL> java.lang.reflect.Method.invoke(Method.java:324)
> > >> LL> 16:15:50,608 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceAbstractAction.execute(AceAbstractAction.java:47)
> > >>
> > >> LL> 16:15:50,628 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> > >>
> > >> LL> 16:15:50,638 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> > >>
> > >> LL> 16:15:50,658 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
> > >> LL> 16:15:50,678 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
> > >> LL> 16:15:50,688 ERROR [STDERR] at
> > >> LL> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > >> LL> 16:15:50,708 ERROR [STDERR] at
> > >> LL> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > >> LL> 16:15:50,728 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> > >>
> > >> LL> 16:15:50,748 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> 16:15:50,768 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceGenericFilter.doFilter(AceGenericFilter.java:49)
> > >>
> > >> LL> 16:15:50,788 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
> > >>
> > >> LL> 16:15:50,808 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> 16:15:50,818 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
> > >>
> > >> LL> 16:15:50,838 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:50,858 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:50,878 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:50,888 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> > >>
> > >> LL> 16:15:50,908 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:50,928 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> > >>
> > >> LL> 16:15:50,958 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:50,978 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:50,998 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:51,018 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> > >>
> > >> LL> 16:15:51,028 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> > >>
> > >> LL> 16:15:51,048 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:51,068 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
> > >>
> > >> LL> 16:15:51,088 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:51,098 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
> > >>
> > >> LL> 16:15:51,118 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:51,138 ERROR [STDERR] at
> > >> LL> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
> > >>
> > >> LL> 16:15:51,158 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:51,178 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:51,198 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:51,218 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> > >>
> > >> LL> 16:15:51,238 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:51,249 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:51,269 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:51,289 ERROR [STDERR] at
> > >> LL> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> > >> LL> 16:15:51,309 ERROR [STDERR] at
> > >> LL> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> > >>
> > >> LL> 16:15:51,329 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
> > >>
> > >> LL> 16:15:51,349 ERROR [STDERR] at
> > >> LL> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> > >>
> > >> LL> 16:15:51,369 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
> > >>
> > >> LL> 16:15:51,389 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
> > >>
> > >> LL> 16:15:51,419 ERROR [STDERR] javax.ejb.CreateException:
> > >> LL> LineItemFactory.create(pk) failed: Error checking if entity
> > >> LL> exists:java.sql.SQLException: Colum
> > >> LL> n "MASTERORDER_ORDERID" not found in table at position 36.
> > >> LL> 16:15:51,449 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.purchaseorder.entity.LineItemFactory.create(LineItemFactory.java:253)
> > >>
> > >> LL> 16:15:51,459 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.purchaseorder.struts.EditPOAction.makeTransitionAddLineItem(EditPOAction.java:155)
> > >>
> > >> LL> 16:15:51,479 ERROR [STDERR] at
> > >> LL> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >> LL> 16:15:51,499 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > >>
> > >> LL> 16:15:51,519 ERROR [STDERR] at
> > >> LL>
> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > >>
> > >> LL> 16:15:51,529 ERROR [STDERR] at
> > >> LL> java.lang.reflect.Method.invoke(Method.java:324)
> > >> LL> 16:15:51,549 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceAbstractAction.execute(AceAbstractAction.java:47)
> > >>
> > >> LL> 16:15:51,569 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> > >>
> > >> LL> 16:15:51,589 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> > >>
> > >> LL> 16:15:51,599 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
> > >> LL> 16:15:51,629 ERROR [STDERR] at
> > >> LL> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
> > >> LL> 16:15:51,649 ERROR [STDERR] at
> > >> LL> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > >> LL> 16:15:51,679 ERROR [STDERR] at
> > >> LL> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > >> LL> 16:15:51,689 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> > >>
> > >> LL> 16:15:51,709 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> 16:15:51,729 ERROR [STDERR] at
> > >> LL>
> > >> com.sun.ace.runtime.client.jspbean.AceGenericFilter.doFilter(AceGenericFilter.java:49)
> > >>
> > >> LL> 16:15:51,739 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
> > >>
> > >> LL> 16:15:51,769 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > >>
> > >> LL> 16:15:51,789 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
> > >>
> > >> LL> 16:15:51,809 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:51,829 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:51,849 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:51,859 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> > >>
> > >> LL> 16:15:51,879 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:51,899 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> > >>
> > >> LL> 16:15:51,919 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:51,940 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:51,950 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:51,970 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> > >>
> > >> LL> 16:15:51,990 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> > >>
> > >> LL> 16:15:52,010 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:52,030 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
> > >>
> > >> LL> 16:15:52,050 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:52,070 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
> > >>
> > >> LL> 16:15:52,090 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:52,110 ERROR [STDERR] at
> > >> LL> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
> > >>
> > >> LL> 16:15:52,120 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> > >>
> > >> LL> 16:15:52,140 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:52,160 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:52,180 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> > >>
> > >> LL> 16:15:52,200 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
> > >>
> > >> LL> 16:15:52,230 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> > >>
> > >> LL> 16:15:52,240 ERROR [STDERR] at
> > >> LL> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > >> LL> 16:15:52,270 ERROR [STDERR] at
> > >> LL> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> > >> LL> 16:15:52,290 ERROR [STDERR] at
> > >> LL> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> > >>
> > >> LL> 16:15:52,310 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
> > >>
> > >> LL> 16:15:52,330 ERROR [STDERR] at
> > >> LL> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> > >>
> > >> LL> 16:15:52,340 ERROR [STDERR] at
> > >> LL>
> > >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
> > >>
> > >> LL> 16:15:52,360 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
> > >>
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: INetU
> > Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> > Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> > INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd";>
<jbosscmp-jdbc>
<defaults>
<datasource>java:/jdbc/PurchaseOrder</datasource>
<datasource-mapping>PointBase</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<pk-constraint>true</pk-constraint>
<fk-constraint>true</fk-constraint>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
</defaults>
<enterprise-beans>
<entity>
<ejb-name>PurchaseOrderBean</ejb-name>
<table-name>PurchaseOrder</table-name>
<cmp-field>
<field-name>orderId</field-name>
<column-name>ORDERID</column-name>
</cmp-field>
<cmp-field>
<field-name>orderDate</field-name>
<column-name>ORDERDATE</column-name>
</cmp-field>
<cmp-field>
<field-name>orderDate1</field-name>
<column-name>ORDERDATE1</column-name>
</cmp-field>
<cmp-field>
<field-name>cost</field-name>
<column-name>COST</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToName</field-name>
<column-name>SHIPTONAME</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToPhone</field-name>
<column-name>SHIPTOPHONE</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToAddress1</field-name>
<column-name>SHIPTOADDRESS1</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToAddress2</field-name>
<column-name>SHIPTOADDRESS2</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToCity</field-name>
<column-name>SHIPTOCITY</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToState</field-name>
<column-name>SHIPTOSTATE</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToZip</field-name>
<column-name>SHIPTOZIP</column-name>
</cmp-field>
<cmp-field>
<field-name>shipToCountry</field-name>
<column-name>SHIPTOCOUNTRY</column-name>
</cmp-field>
<cmp-field>
<field-name>billToName</field-name>
<column-name>BILLTONAME</column-name>
</cmp-field>
<cmp-field>
<field-name>billToPhone</field-name>
<column-name>BILLTOPHONE</column-name>
</cmp-field>
<cmp-field>
<field-name>billToAddress1</field-name>
<column-name>BILLTOADDRESS1</column-name>
</cmp-field>
<cmp-field>
<field-name>billToAddress2</field-name>
<column-name>BILLTOADDRESS2</column-name>
</cmp-field>
<cmp-field>
<field-name>billToCity</field-name>
<column-name>BILLTOCITY</column-name>
</cmp-field>
<cmp-field>
<field-name>billToState</field-name>
<column-name>BILLTOSTATE</column-name>
</cmp-field>
<cmp-field>
<field-name>billToZip</field-name>
<column-name>BILLTOZIP</column-name>
</cmp-field>
<cmp-field>
<field-name>billToCountry</field-name>
<column-name>BILLTOCOUNTRY</column-name>
</cmp-field>
</entity>
<entity>
<ejb-name>LineItemBean</ejb-name>
<table-name>LineItem</table-name>
<cmp-field>
<field-name>orderLine</field-name>
<column-name>ORDERLINE</column-name>
</cmp-field>
<cmp-field>
<field-name>productId</field-name>
<column-name>PRODUCTID</column-name>
</cmp-field>
<cmp-field>
<field-name>orderDate</field-name>
<column-name>ORDERDATE</column-name>
</cmp-field>
<cmp-field>
<field-name>orderDate1</field-name>
<column-name>ORDERDATE1</column-name>
</cmp-field>
<cmp-field>
<field-name>productName</field-name>
<column-name>PRODUCTNAME</column-name>
</cmp-field>
<cmp-field>
<field-name>productDescription</field-name>
<column-name>PRODUCTDESCRIPTION</column-name>
</cmp-field>
<cmp-field>
<field-name>unitPrice</field-name>
<column-name>UNITPRICE</column-name>
</cmp-field>
<cmp-field>
<field-name>quantity</field-name>
<column-name>QUANTITY</column-name>
</cmp-field>
</entity>
</enterprise-beans>
<!-- Relationships -->
<relationships>
<ejb-relation>
<ejb-relation-name>PurchaseOrderBean-lineItems-masterOrder-LineItemBean</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>PurchaseOrderBean-lineItems-LineItemBean</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>orderId</field-name>
<column-name>MASTERORDER</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>LineItemBean-masterOrder-PurchaseOrderBean</ejb-relationship-role-name>
</ejb-relationship-role>
</ejb-relation>
</relationships>
</jbosscmp-jdbc>
-- ACE-GENERATED FILE: REMOVE THIS LINE TO KEEP YOUR CHANGES
-- if EXISTS(PurchaseOrder)
DROP TABLE PurchaseOrder CASCADE;
-- if EXISTS(LineItem)
DROP TABLE LineItem CASCADE;
CREATE TABLE PurchaseOrder(
orderId DECIMAL(10,0),
orderDate DATE,
orderDate1 DATE,
cost DECIMAL,
shipToName VARCHAR(255),
shipToPhone VARCHAR(255),
shipToAddress1 VARCHAR(255),
shipToAddress2 VARCHAR(255),
shipToCity VARCHAR(255),
shipToState VARCHAR(255),
shipToZip VARCHAR(255),
shipToCountry VARCHAR(255),
billToName VARCHAR(255),
billToPhone VARCHAR(255),
billToAddress1 VARCHAR(255),
billToAddress2 VARCHAR(255),
billToCity VARCHAR(255),
billToState VARCHAR(255),
billToZip VARCHAR(255),
billToCountry VARCHAR(255),
PRIMARY KEY ( orderId )
);
-- if EXISTS(PurchaseOrder_PRIMARY_KEY)
-- DROP INDEX PurchaseOrder.PurchaseOrder_PRIMARY_KEY;
CREATE UNIQUE INDEX PurchaseOrder_PRIMARY_KEY ON PurchaseOrder(orderId);
COMMIT;
CREATE TABLE LineItem(
orderLine DECIMAL(10,0),
productId VARCHAR(255),
orderDate DATE,
orderDate1 DATE,
productName VARCHAR(255),
productDescription VARCHAR(255),
unitPrice DECIMAL,
quantity DECIMAL(10,0),
masterOrder DECIMAL(10,0),
PRIMARY KEY ( masterOrder,orderLine )
);
-- if EXISTS(LineItem_PRIMARY_KEY)
-- DROP INDEX LineItem.LineItem_PRIMARY_KEY;
CREATE UNIQUE INDEX LineItem_PRIMARY_KEY ON LineItem(masterOrder,orderLine);
COMMIT;
ALTER TABLE LineItem ADD CONSTRAINT LineItem_masterOrder FOREIGN KEY (masterOrder)
REFERENCES PurchaseOrder(orderId);
