db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Youngho Cho" <youn...@nannet.co.kr>
Subject Criteria.Criterion and Join
Date Thu, 29 Mar 2007 03:14:56 GMT
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message