Created
November 5, 2013 04:34
-
-
Save smithh032772/7313936 to your computer and use it in GitHub Desktop.
2013-11-04 exception caused by ha-jdbc during multi-table update
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Nov 04, 2013 11:19:23 PM net.sf.hajdbc.logging.slf4j.SLF4JLogger log | |
SEVERE: A result [java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back.] of an operation on database db2 in cluster net.sf.hajdbc.sql.DatabaseClusterImpl@b464829 did not match the expected result [1] | |
Nov 04, 2013 11:19:23 PM org.apache.openejb.core.transaction.EjbTransactionUtil handleSystemException | |
SEVERE: EjbTransactionUtil.handleSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:786) | |
at org.apache.openejb.persistence.JtaEntityManager.flush(JtaEntityManager.java:195) | |
at jpa.session.AbstractFacade.create(AbstractFacade.java:26) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:180) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:99) | |
at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:80) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:212) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:181) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:268) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:263) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:86) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:303) | |
at jpa.session.OrdersFacade$$LocalBeanProxy.create(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.createAs(pf_OrdersController.java:12071) | |
at jsf.orders.pf_OrdersController.createUsingOrder(pf_OrdersController.java:11893) | |
at jsf.orders.pf_OrdersController$$OwbNormalScopeProxy0.createUsingOrder(jsf/orders/pf_OrdersController.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at javax.el.BeanELResolver.invoke(BeanELResolver.java:450) | |
at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225) | |
at de.odysseus.el.tree.impl.ast.AstMethod.eval(AstMethod.java:91) | |
at de.odysseus.el.tree.impl.ast.AstMethod.invoke(AstMethod.java:104) | |
at de.odysseus.el.tree.impl.ast.AstEval.invoke(AstEval.java:71) | |
at de.odysseus.el.TreeMethodExpression.invoke(TreeMethodExpression.java:132) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) | |
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:83) | |
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:51) | |
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:420) | |
at javax.faces.component.UICommand.broadcast(UICommand.java:103) | |
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1041) | |
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:289) | |
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1415) | |
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:765) | |
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:98) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:149) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:241) | |
[EL Warning]: 2013-11-04 23:19:23.197--UnitOfWork(1137487762)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1721) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1679) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) | |
at java.lang.Thread.run(Thread.java:744) | |
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:840) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717) | |
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342) | |
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162) | |
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177) | |
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472) | |
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) | |
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) | |
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287) | |
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) | |
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844) | |
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743) | |
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) | |
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449) | |
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224) | |
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415) | |
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561) | |
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447) | |
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780) | |
... 80 more | |
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor237.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at net.sf.hajdbc.util.reflect.Methods.invoke(Methods.java:49) | |
at net.sf.hajdbc.invocation.SimpleInvoker.invoke(SimpleInvoker.java:53) | |
at net.sf.hajdbc.invocation.AllResultsCollector$Invocation.call(AllResultsCollector.java:142) | |
at java.util.concurrent.FutureTask.run(FutureTask.java:262) | |
... 3 more | |
Caused by: java.sql.SQLException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 19 more | |
Caused by: ERROR 23503: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) | |
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) | |
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) | |
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) | |
... 13 more | |
Nov 04, 2013 11:19:23 PM jsf.orders.pf_OrdersController createAs | |
SEVERE: caught exception: | |
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: | |
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:403) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:307) | |
at jpa.session.OrdersFacade$$LocalBeanProxy.create(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.createAs(pf_OrdersController.java:12071) | |
at jsf.orders.pf_OrdersController.createUsingOrder(pf_OrdersController.java:11893) | |
at jsf.orders.pf_OrdersController$$OwbNormalScopeProxy0.createUsingOrder(jsf/orders/pf_OrdersController.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at javax.el.BeanELResolver.invoke(BeanELResolver.java:450) | |
at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225) | |
at de.odysseus.el.tree.impl.ast.AstMethod.eval(AstMethod.java:91) | |
at de.odysseus.el.tree.impl.ast.AstMethod.invoke(AstMethod.java:104) | |
at de.odysseus.el.tree.impl.ast.AstEval.invoke(AstEval.java:71) | |
at de.odysseus.el.TreeMethodExpression.invoke(TreeMethodExpression.java:132) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) | |
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:83) | |
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:51) | |
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:420) | |
at javax.faces.component.UICommand.broadcast(UICommand.java:103) | |
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1041) | |
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:289) | |
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1415) | |
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:765) | |
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:98) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:149) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1721) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1679) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) | |
at java.lang.Thread.run(Thread.java:744) | |
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:786) | |
at org.apache.openejb.persistence.JtaEntityManager.flush(JtaEntityManager.java:195) | |
at jpa.session.AbstractFacade.create(AbstractFacade.java:26) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:180) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:99) | |
at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:80) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:212) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:181) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:268) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:263) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:86) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:303) | |
... 58 more | |
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException | |
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
Error Code: 20000 | |
Call: INSERT INTO ORDERS (BALANCE, CANCELLED, CANCELLED_DATE, CHANGED_DT, CONFIRMED, CONFIRMED_DATE, CONTRACT_SENT, CONTRACT_SENT_DATE, CREATED_BY, CREATED_DT, DEPOSIT, DEPOSIT_PAID, DEPOSIT_PAID_DATE, DISCOUNT, DISCOUNT_RATE, GROUP_NAME, INTRASTATE, INVOICE_SENT, INVOICE_SENT_DATE, PAID_IN_FULL, PAID_IN_FULL_DATE, PASSENGERS, QUOTE_SENT, QUOTE_SENT_DATE, REPORT_DATE_TIME, RETURN_DATE_TIME, ROUND_TRIP, TOTAL_COST, TRIP_DATE_TIME, BANK_FOR_BALANCE_ID, BANK_FOR_DEPOSIT_ID, CUSTOMER_ID, DETAILS_ID, METHOD_OF_PAYMENT_FOR_BALANCE_ID, METHOD_OF_PAYMENT_FOR_DEPOSIT_ID, NOTES_ID, ROUTES_ID, TEMPLATE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
bind => [38 parameters bound] | |
Query: InsertObjectQuery(jpa.entities.Orders[ orderId=1 ]) | |
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:840) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592) | |
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717) | |
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) | |
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342) | |
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162) | |
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177) | |
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472) | |
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) | |
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) | |
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287) | |
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) | |
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844) | |
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743) | |
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) | |
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449) | |
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224) | |
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123) | |
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415) | |
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636) | |
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561) | |
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447) | |
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780) | |
... 80 more | |
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor237.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
at net.sf.hajdbc.util.reflect.Methods.invoke(Methods.java:49) | |
at net.sf.hajdbc.invocation.SimpleInvoker.invoke(SimpleInvoker.java:53) | |
at net.sf.hajdbc.invocation.AllResultsCollector$Invocation.call(AllResultsCollector.java:142) | |
at java.util.concurrent.FutureTask.run(FutureTask.java:262) | |
... 3 more | |
Caused by: java.sql.SQLException: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 19 more | |
Caused by: ERROR 23503: INSERT on table 'ORDERS' caused a violation of foreign key constraint 'ORDERS_FK_ORDER_DETAILS' for key (6818). The statement has been rolled back. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) | |
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) | |
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) | |
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) | |
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) | |
... 13 more | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment