Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Date: Tue, 23 Oct 2012 15:59:12 +0000 (UTC)
From: =?utf-8?Q?Felipe_Mart=C3=ADn_Santos_=28JIRA=29?= <jira@apache.org>
To: commits@cayenne.apache.org
Message-ID: <1612833753.16472.1351007952721.JavaMail.jiratomcat@arcas>
Subject: [jira] [Created] (CAY-1751) FK pointing to an UNIQUE field.
 Problems to insert registers
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Felipe Mart=C3=ADn Santos created CAY-1751:
-----------------------------------------

             Summary: FK pointing to an UNIQUE field. Problems to insert re=
gisters
                 Key: CAY-1751
                 URL: https://issues.apache.org/jira/browse/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=C3=ADn 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 r=
elationship is between TABLE_A (FK)  with TABLE_C (An UNIQUE field), cayenn=
e can=C2=B4t 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 perfo=
rm an insert NULL

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs
For more information on JIRA, see: http://www.atlassian.com/software/jira