db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc Lustig" <m...@marclustig.com>
Subject AW: torque-performance using cross-references
Date Tue, 21 Jan 2003 09:20:31 GMT
Thanks, but problem is I'm using Torque 3.0.
I couldn't find the doSelectJoinXXX method that I needed.
And according to Issue Id :    TRQS122
the doSelectJoinXXX methods are no longer generated due to a bug.

Once this is fixed updating torque.jar might solve this.

Marc

> -----Urspr√ľngliche Nachricht-----
> Von: Andras Balogh [mailto:andras@reea.net]
> Gesendet: Dienstag, 21. Januar 2003 08:52
> An: Turbine Torque Users List
> Betreff: Re: torque-performance using cross-references
>
>
>
> ----- Original Message -----
> From: "Marc Lustig" <mail@marclustig.com>
> To: "Turbine Torque Users List" <turbine-torque-user@jakarta.apache.org>
> Sent: Monday, January 20, 2003 22:39
> Subject: AW: torque-performance using cross-references
>
>
> > Thank you, that helped. So does this code
> >
> >     Criteria c = new Criteria();
> >     c.addJoin(UserItemPeer.ITEM_ID,ItemPeer.ITEM_ID);
> >     c.add(UserItemPeer.USER_ID,user);
> >     doSelect...
> >
> > result in that sql:
> >
> > "SELECT item.* FROM item,user_item WHERE user_item.user_id=x AND
> > user_item.item_id=item.item_id"
> >
>
> Hi,
>
> You should check your generated BaseUserItemPeer, there should be a
> protected method something like doSelectJoinItems(Criteria), make
> it public
> in your UserItemPeer
> and use that. This is the most efficent method becuase it will fill up the
> Item objects
> for each UserItem.
>
> BW,
>
> Andras.
>
> P.S.  I hope a undestood correctly your schema, anyway i think you got the
> idea.
>
>
>
>
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:turbine-torque-user-help@jakarta.apache.org>


Mime
View raw message