db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: Column: 'id' in where clause is ambiguous
Date Thu, 30 Jan 2003 17:56:30 GMT
hi sander,

what's the query you executed ?

jakob

Sander Hofstee wrote:

> Sorry, put it in the wrong thread.
>
> I downloaded the latest CVS version of ojb and tried to make this work.
> But when I try to load an object with an indirection table  I get an 
> error:
> General error: Column: 'id' in where clause is ambiguous
>
> <collection-descriptor name="brieven"
> element-class-ref="nl.topicus.rvc.object.Brief"
> indirection-table="statusovergang_parameter">
> <fk-pointing-to-this-class column="statusovergang_ID"/>
> <fk-pointing-to-element-class column="brief_ID"/>
> </collection-descriptor>
>
> This is the query that is done according to the debug info:
> SELECT A0.briefnaam,A0.volgnummer,A0.id FROM brief
> A0,statusovergang_parameter WHERE
> (statusovergang_parameter.statusovergang_ID = ? ) AND
> statusovergang_parameter.brief_ID = id
>
> But I think I should be
> SELECT A0.briefnaam,A0.volgnummer,A0.id FROM brief
> A0,statusovergang_parameter WHERE
> (statusovergang_parameter.statusovergang_ID = ? ) AND
> statusovergang_parameter.brief_ID = A0.id
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ojb-dev-help@jakarta.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ojb-dev-help@jakarta.apache.org
>
>


Mime
View raw message