0014914: Error related to views in DAL: cannot modify a column which maps to a non key-preserved table

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #14914		[ All Revisions ] [ Back to Issue ]
Summary	0014914: Error related to views in DAL: cannot modify a column which maps to a non key-preserved table

Revision	2010-10-26 16:42 by mirurita
Description	When trying to process a Payment Proposal that has been paid partially it shows the following error Oracle: ORA-01779: cannot modify a column which maps to a non key-preserved table Caused by: java.sql.BatchUpdateException: ORA-01779: cannot modify a column which maps to a non key-preserved table at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) PostgreSQL: cannot insert into a view 0 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into FIN_Payment_Prop_Detail_V (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, FIN_Payment_Scheduledetail_ID, FIN_Payment_Proposal_ID, Invoiceno, Duedate, Invoicedamt, Expected, Paidamt, C_Bpartner_ID, Writeoffamt, FIN_Payment_Prop_Detail_V_ID) values (1000000, 1000000, Y, 2010-10-26 16:33:27.907000 +0200, 100, 2010-10-26 16:33:28.574000 +0200, 100, FF8080812BE8F4B1012BE8F540FD001B, FF8080812BE8F4B1012BE8F53DF40017, 200015, 2010-10-26 00:00:00.000000 +0200, 182.00, 182.00, 100, 1000008, 0, FF8080812BE8F4B1012BE8F540FE001C) was aborted. Call getNextException to see the cause. It was working successfully before the support to views was included in core.

Revision	2010-10-26 16:40 by mirurita
Description	When trying to process a Payment Proposal that has been paid partially it shows the following error Oracle: ORA-01779: cannot modify a column which maps to a non key-preserved table PostgreSQL: cannot insert into a view It was working successfully before the support to views was included in core.