Re: Need help with PSQLException

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Jun 03 2005 - 09:46:03 EDT

  • Next message: Dhruti Ramani: "Re: Need help with PSQLException"

    Denna,

    cayenne.xml is just a project index file, mapping is stored in
    UntitledDomainMap.map.xml. Could you send that file too?

    Andrus

    > 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:46:05 EDT