Hi,

we have newly migrated from Hibernate2.1 to Hibernate3.0, we are having problems with the old outer join queries we had earlier, for eg., we had an outer join query like below, select a from <table a> a,<table b> b where a.id=b.someId(+) and a.otherId=<value>

when we executed this we got "org.hibernate.hql.ast.QuerySyntaxError: unexpected token: )"
then tried the same query like below
select a from <table a> a left outer join <table b> b on a.id=b.someId where a.otherId=<value>

now we are getting the below exception
"org.hibernate.hql.ast.QuerySyntaxError: unexpected token: on"

Thanks in Advance,
Rajan

[/b]

This has never been officially supported. Arbitrary outer join is not available in HQL yet. You may wat do to a native query for that one