Re: Need help with PSQLException

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

  • Next message: Andrus Adamchik: "Re: how to get object id before save?"

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

    > 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
    >
    >
    >
    >

                    
    __________________________________
    Discover Yahoo!
    Find restaurants, movies, travel and more fun for the weekend. Check it out!
    http://discover.yahoo.com/weekend.html





    This archive was generated by hypermail 2.0.0 : Fri Jun 03 2005 - 09:48:04 EDT