Christofer, let's discuss this in jboss-user list.
Is it true that all the foreign key fields are mapped to primary key fields? Is orderId a part of OrderLineEnt primary key? alex Wednesday, March 19, 2003, 4:24:25 PM, Christofer Dutz wrote: CD> Hi, CD> after having some problems with jboss ignoring my default-datasource settings. I CD> got the deployment working again. When trying to add new orders I get an error CD> at the same place where I had the double coulmn names error. I added the CD> relevant parts of my deployment descriptors. Here the part of the log file : CD> 2003-03-19 15:18:06,310 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderEnt] Executing SQL: CD> SELECT COUNT(*) FROM O_ORDERS WHERE o_id=? CD> 2003-03-19 15:18:06,313 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderEnt] Executing SQL: CD> INSERT INTO O_ORDERS (o_id, o_status, o_ship_date, o_entry_date, o_total, CD> o_discount, o_ol_cnt, o_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?) CD> 2003-03-19 15:18:06,322 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderEnt] Rows affected = 1 CD> 2003-03-19 15:18:06,341 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.OrderEnt] Executing SQL: CD> UPDATE O_ORDERS SET o_status=?, o_entry_date=?, o_ol_cnt=?, o_c_id=? WHERE o_id=? CD> 2003-03-19 15:18:06,343 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.OrderEnt] Rows affected = 1 CD> 2003-03-19 15:18:06,344 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ItemEnt.findByPrimaryKey] CD> Executing SQL: SELECT i_id FROM O_ITEM WHERE i_id=? CD> 2003-03-19 15:18:06,364 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemEnt] Executing SQL: CD> SELECT i_id,i_discount, i_desc, i_name, i_price FROM O_ITEM WHERE (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR CD> (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) OR (i_id=?) CD> OR (i_id=?) CD> 2003-03-19 15:18:06,395 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderLineEnt] Create: CD> [EMAIL PROTECTED] CD> 2003-03-19 15:18:06,395 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderLineEnt] Executing CD> SQL: SELECT COUNT(*) FROM O_ORDERLINE WHERE ol_o_id=? AND ol_id=? CD> 2003-03-19 15:18:06,400 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderLineEnt] Executing CD> SQL: INSERT INTO O_ORDERLINE (ol_o_id, ol_id, ol_ship_date, ol_Qty, ol_i_id) CD> VALUES (?, ?, ?, ?, ?) CD> 2003-03-19 15:18:06,402 DEBUG CD> [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OrderLineEnt] Rows CD> affected = 1 CD> 2003-03-19 15:18:06,413 ERROR [org.jboss.ejb.plugins.LogInterceptor] CD> TransactionRolledbackLocalException, causedBy: CD> java.lang.IllegalStateException: Can't modify relationship: CMR field CD> OrderLineEnt.OrderEnt_ordLines has _ALL_ foreign key fields mapped to the CD> primary key columns. Primary key may only be set once in ejbCreate [EJB 2.0 CD> Spec. 10.3.5]. CD> at org.jboss.ejb.plugins.cmp.jdbc.bridge.RelationSet.add(RelationSet.java:80) CD> at CD> org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPostCreate(OrderCmp20EJB.java:169) CD> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) CD> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) CD> at CD> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) CD> at java.lang.reflect.Method.invoke(Method.java:324) CD> at CD> org.jboss.ejb.plugins.CMPPersistenceManager.postCreateEntity(CMPPersistenceManager.java:260) CD> at CD> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.postCreateEntity(CachedConnectionInterceptor.java:278) CD> at org.jboss.ejb.EntityContainer.postCreateLocalHome(EntityContainer.java:585) CD> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) CD> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) CD> at CD> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) CD> at java.lang.reflect.Method.invoke(Method.java:324) CD> at CD> org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke(EntityContainer.java:1032) CD> at CD> org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.invoke(JDBCRelationInterceptor.java:95) CD> at CD> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:295) CD> at CD> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) CD> at CD> org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:82) CD> at CD> org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:174) CD> at CD> org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89) CD> at CD> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:43) CD> at CD> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) CD> at CD> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) CD> at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) CD> at CD> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) CD> at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:123) CD> at CD> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) CD> at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) CD> at org.jboss.ejb.Container.invoke(Container.java:698) CD> at CD> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) CD> at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) CD> at $Proxy44.create(Unknown Source) CD> at CD> org.spec.jappserver.orders.orderses.ejb.OrderSesEJB.newOrder(OrderSesEJB.java:105) CD> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) CD> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) CD> at CD> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) CD> at java.lang.reflect.Method.invoke(Method.java:324) CD> at CD> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629) CD> at CD> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) CD> at CD> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) CD> at CD> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) CD> at CD> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) CD> at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104) CD> at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117) CD> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:198) CD> at CD> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) CD> at CD> org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322) CD> at org.jboss.ejb.Container.invoke(Container.java:678) CD> at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source) CD> at CD> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) CD> at java.lang.reflect.Method.invoke(Method.java:324) CD> at CD> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) CD> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) CD> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) CD> at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88) CD> at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77) CD> at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80) CD> at CD> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109) CD> at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82) CD> at $Proxy100.newOrder(Unknown Source) CD> at org.spec.jappserver.webbeans.OrderSesBean.newOrder(OrderSesBean.java:190) CD> at org.apache.jsp.submit_order_jsp._jspService(submit_order_jsp.java:191) CD> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) CD> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) CD> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) CD> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) CD> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) CD> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) CD> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) CD> at CD> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:278) CD> at org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:192) CD> at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:129) CD> at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430) CD> at org.apache.jsp.new_order_jsp._jspService(new_order_jsp.java:188) CD> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) CD> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) CD> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) CD> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) CD> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) CD> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) CD> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) CD> at CD> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:278) CD> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) CD> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) CD> at CD> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:548) CD> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) CD> at org.mortbay.http.HttpServer.service(HttpServer.java:863) CD> at org.jboss.jetty.Jetty.service(Jetty.java:460) CD> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) CD> at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) CD> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) CD> at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) CD> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) CD> at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455) ------------------------------------------------------- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
