Did you try this (replacing the column names with the Torque column names):
c1 = crit.getNewCriterion(moduleField,
(Object) moduleField
+ "="+JettigerModule.MODULE_ID+" AND
"+JettigerModule.PARENT_ID+"="
+ item.getParentId(),
Criteria.CUSTOM);
Adam
----- Original Message ----
From: Youngho Cho <[EMAIL PROTECTED]>
To: Apache Torque Users List <[email protected]>
Sent: Wednesday, March 28, 2007 10:14:56 PM
Subject: Criteria.Criterion and Join
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
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
