Details
-
Improvement
-
Status: Reopened
-
Minor
-
Resolution: Unresolved
-
3.0.2
-
None
-
Eclipse + Java 5 + Junit + Cayenne 3.0.2 (Generic Persistent Class) + Oracle 10g Database
Description
I need insert a new record and the table where insert have 2 FK not null:
If I relate TABLE_A (FK) with TABLE_B (PK) Cayenne works well but if the relationship is between TABLE_A (FK) with TABLE_C (An UNIQUE field), cayenne can´t extract de value of that UNIQUE value, and the insert sentence generated live that field null and I get next error:
java.sql.SQLIntegrityConstraintViolationException: ORA-01400. Can not perform an insert NULL