Denna,
Can you post a SQL log (all queries executed before you got this
exception). This should give a beter idea of what is actually happenning.
Andrus
> Here is what I did,
>
> From "Deal" I have two relations like this,
> (Name,target)
> (Quotes,Quote) using deal_id. And reverse is (Deal,Deal)
> (AcceptedQuote,Quote) using quote_id.And reverse is
> (DealForAcceptedQuote,Deal)
>
> But then when I try to set particular Quote as "AcceptedQuote" it gives
> me error that: $1 referential integrity violation - key referenced from
> deal not found in quote.
>
> Any ideas?
> Thanks,
> Denna
>
> Cris Daniluk <cris.danilu..mail.com> wrote:
> There's absolutely no reason why you can't do this - just create the
> second relationship in the DbEntity, but be sure to select the right
> fields to connect the tables.
>
> On Apr 5, 2005 12:04 PM, Dhruti Ramani wrote:
>> Hello All,
>> I am Denna Ramani. I am getting familiar with Cayenne. I really like
>> this software.
>>
>> We are using postgresql database right now.In one of our project, we
>> need two relations between same two tables. For example, we have
>> "Deal" and "Quote" objects. And relations are, "Deal" can have many
>> "Quotes" but "Deal" has one"AcceptedQuote". "AcceptedQuote" is one of
>> from many
>> Quotes that Deal has. Do you have any idea about how one can do this?
>>
>> Thanks,
>> Denna
>>
>> ________________________________
>> Yahoo! Messenger
>> Show us what our next emoticon should look like. Join the fun.
>>
>>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Better first dates. More second dates. Yahoo! Personals
This archive was generated by hypermail 2.0.0 : Tue Apr 05 2005 - 12:42:32 EDT