No, they are not marked as Primary key. Should it be both marked as PK in join table?
Thanks,
Denna
Andrus Adamchik <andru..bjectstyle.org> wrote:
Hmm... now this is strange - a delete query without a qualifier... I'd
even open a feature request to make sure Cayenne detects such cases and
reports a meanigful error.
The only reason I can think of is that the join table columns that
participate in relationships are not marked as PK. Are they?
Andrus
> Hi,
> Sorry I am asking this question again.
>
> I am using cayenne1.1 and postgresql7 as database.
> I have M to M relation between SystemUser and UserRole objects, join table
> is called UserRole_SystemUser.
>
> Now if I add some SystemUser to UserRole I don't have any problems but
> when I try to delete the user from UserRole and if i say commitChanges()
> it throws following exception,
>
> INFO QUERYLOGGER : DELETE FROM UserRole_SystemUser WHERE
> INFO QUERYLOGGER : *** error.
> java.sql.SQLException: ERROR: parse: parse error at end of input
>
> I really need help with this.
> Thanks,
> Denna
__________________________________________________
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 : Tue Jul 26 2005 - 17:08:20 EDT