I suspect that this is just a case where Hibernate can't help, but I have a set of relationships that I'm trying to initialize in one select statement.

One of those relationships uses a discriminator-based subclass (with two values, 'IN' and 'CM'), and as a result, the following clause appears in my SELECT:



It appears that HSQLDB doesn't like an "in" statement to appear in a left outer join, and I get an exception when the statement is executed. Can anyone suggest a tweak that might help me bypass the problem?

Hibernate version: 3.0.5

Full stack trace of any exception that occurs:

org.hibernate.util.JDBCExceptionReporter - not allowed in OUTER JOIN condition in statement

Name and version of the database you are using:

HSQLDB 1.8.0

The generated SQL (show_sql=true):

left outer join CL01_CLAIMPARTY claimparti4_
on claim2_.COMPANY=claimparti4_.COMPANY
and claim2_.CLAIMNO=claimparti4_.CLAIMNO
and claimparti4_.REFASSOC in ('IN', 'CM')

hi
I think u must change the hql to this

left outer join CL01_CLAIMPARTY claimparti4_
on claim2_.COMPANY=claimparti4_.COMPANY
and claim2_.CLAIMNO=claimparti4_.CLAIMNO
where
claimparti4_.REFASSOC in ('IN', 'CM')


hope this help

or maybe this help u :

left outer join CL01_CLAIMPARTY claimparti4_
on claim2_.COMPANY=claimparti4_.COMPANY
and claim2_.CLAIMNO=claimparti4_.CLAIMNO as joinAlias
with joinAlias.REFASSOC in ('IN', 'CM')


I am not sure that as joinAlias where should be placed maybe

left outer join CL01_CLAIMPARTY claimparti4_ as joinAlias
on claim2_.COMPANY=claimparti4_.COMPANY
and claim2_.CLAIMNO=claimparti4_.CLAIMNO
with joinAlias.REFASSOC in ('IN', 'CM')