HSQL Outer Join query exception

matt_dowell · **Joined:** Sat Oct 18, 2003 11:53 am **Posts:** 55

We have a user that is getting this error:

net.sf.hibernate.QueryException: outer or full join must be followed by path expression

Here is the output:

Code:

from com.notiva.cbo.buyer.data.partnership.SellerPartnershipImpl as sp  inner join com.notiva.cbo.buyer.data.invoice.InvoiceImpl as invoice  on invoice.partnershipId = sp.id  inner join com.notiva.cbo.buyer.data.match.InvoiceMatch as invoice_match  on invoice_match.invoiceId = invoice.id  inner join com.notiva.cbo.buyer.data.match.MatchImpl as match  on match.id = invoice_match.matchId  where match.id =135

Any ideas? Looks good to me. Thanks

Matt

christian · **Posted:** Mon Nov 17, 2003 2:04 pm

This is not HQL.

gavin · **Posted:** Mon Nov 17, 2003 2:16 pm

(1) There is no ON clause in HQL
(2) It really looks MUCH nicer if you get rid of the package names .... you can use the classnames unqualified unless there are dupes.