db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Allgaier <allgai...@yahoo.com>
Subject Re: Criteria.Criterion and Join
Date Thu, 29 Mar 2007 15:46:45 GMT
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 <youngho@nannet.co.kr>
To: Apache Torque Users List <torque-user@db.apache.org>
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message