cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felipe Martín Santos (JIRA) <>
Subject [jira] [Created] (CAY-1751) FK pointing to an UNIQUE field. Problems to insert registers
Date Tue, 23 Oct 2012 15:59:12 GMT
Felipe Martín Santos created CAY-1751:

             Summary: FK pointing to an UNIQUE field. Problems to insert registers
                 Key: CAY-1751
             Project: Cayenne
          Issue Type: Improvement
          Components: Core Library, Database integration
    Affects Versions: 3.0.2
         Environment: Eclipse + Java 5 + Junit + Cayenne 3.0.2 + Oracle 10g Database
            Reporter: Felipe Martín Santos
            Priority: Minor
             Fix For: 3.1 (final), 3.0.2

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

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message