You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Thomas Fischer <tf...@apache.org> on 2007/04/01 21:13:43 UTC
Re: Criteria.Criterion and Join
Sorry, join conditions other than equal are not implemented yet.
Thomas
On Thu, 29 Mar 2007, Youngho Cho wrote:
> Hello
>
> I would like to use join in the Criterion .
>
> There is no join related method with Criterion
> I use CUSTOM like
>
>
> c1 = crit.getNewCriterion(moduleField,
> (Object) moduleField
> + "=JETTIGER_MODULE.MODULE_ID AND JETTIGER_MODULE.PARENT_ID="
> + item.getParentId(),
> Criteria.CUSTOM);
>
>
> But I got the following SQLException
> java.sql.SQLException: Base table or view not found message from server: "Unknown table 'JETTIGER_MODULE' in where clause".
>
>
> Is there any way using join within Criterion ??
>
>
> Thanks.
>
> Youngho
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org