I'm tried to use a where parameter in a set tag with an exists clause and I've an error. My mapping is similar to:
<set name="persons" lazy="true"
where="not exists ( from myapp.Person as other where other.id = id)">
.....and the generated SQL is like
select plan_tip0_.USER_ID as TIPO_CAM1___,
..................
from PLAN_USERS plan_tip0_
where plan_tip0_.USER_ID=? and
not plan_tip0_.exists ( plan_tip0_.from plan_tip0_.myapp.Person plan_tip0_.as plan_tip0_.other plan_tip0_.where plan_tip0_.otro.id=plan_tip0_.id)
the synonymous for the table (named plan_tipo0_) is uppend at begining of the reserved word (like exists) making the SQL code erroneous.
Is possible that I can used an exists in this form?
Also, Can I use arbitrary SQL code inside the HQL code (to make this query works)?
Thanks!
Germán
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
