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