Re: Need help with PSQLException

From: Dhruti Ramani (dhrutiraman..ahoo.com)
Date: Fri Jun 03 2005 - 09:26:06 EDT

  • Next message: Andrus Adamchik: "Re: Need help with PSQLException"

    Hi,

    Attached file is cayenne.xml. The objects I am talking
    about are Deal and PrimaryDocumentationReviewResult.

    Now I can not click on "to dep pk" check box. Should I
    delete the relationship and do it again? Which "to dep
    pk" I should check, Deal or
    PrimaryDocumentationReviewResult.

    Thanks,
    Denna

    --- Andrus Adamchik <andru..bjectstyle.org> wrote:

    > > Hi,
    > >
    > > I have two objects Review(booelan isCompleted,
    > boolean isThordParty) and
    > > Deal and one to one relation between them.
    > Initially I am assigning
    > > Review to Deal with all fields of Review to be
    > false. Now if I change
    > > some fields of Deal and commit it throws this
    > Exception.
    > >
    > > "Cannot insert a duplicate key into unique
    > review_deal_id_key"
    > >
    > > What am I doing wrong here?
    > > Thanks,
    > > Denna
    >
    > My guess is that you overlooked "to dep pk" checkbox
    > on the deal -> review
    > relationship (you have to check it). But if this
    > doesn't help (meaning I
    > made a wrong assumption about your mapping), please
    > send an extract from
    > the DataMap XML file showing how these two tables
    > and relationship between
    > thm are mapped, and also SQL logs prior to the error
    > that you mention.
    >
    > Andrus
    >
    >
    >

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com




    This archive was generated by hypermail 2.0.0 : Fri Jun 03 2005 - 09:26:07 EDT