Hi all
I try to use a left outer join in my sql.
But I always got this error
net.sf.hibernate.QueryException: outer or full join must be followed by path expression


and that my query
<query name="printdocument.hibernate.decreto">
<![CDATA[
select ud.comp_id.tipoIdUtentegruppo,ug.comp_id.idGruppo from TUtenteGruppo as ug left join TUtentegruppoDecreto as ud on ud.comp_id.idUtentegruppo =ud.comp_id.idUtentegruppo
]]>
</query>

Please help.
Regards

Please read the manual on how the join syntax in HQL is.

I read te manual I found that syntax.
Can u suggest me any examples?

There are several dozen query examples in the documentation.

of course but no one define the element clause of the left outer join.
I'm not sure of using the syntax 'on column1=column2' or another one.
Has I have to specify xml tag in mapping xml?

As stated in the FAQ, there is no explicit join condition (what you call "on") in HQL at the moment. It's on the list.

so I have to define an outer join without element column clause.
But I wonder what sense it has.Colud u explain me please?

I don't understand you. Its probably better if you continue writing your queries in SQL until you have time to learn HQL.

MMM...
I 'm using a query in an xml.
With hibernate I get the query etc etc.
In which way u mean I should use sql instead of HQL.
Can I put SQL in the mapping xml instead of HQL?
That's colud be great.
But hibernate allow just HQL in mapping hbm files.Isn'it?

You can also use SQL. Please, this is all documented for a reason. Read it.

hi dilembo,
just one tip: hibernate in action, read about HQL, and SQLQuery

second tip: don't forget to read all the book ;), you'll learn fast

Sorry for be boring but actually in my hbm files I can use just HQL.
Could u suggest me the specific link where to find SQL embedded in a hbm file?
Actually I've done a boring job converting sql in hql in my hbm file and could be great using directly SQL enbedded in hbm.
What I do not like is enbedding SQL in java code.I prefer to separate that.
Please be more specific if u can help.
Regards

Read the reference documentation, SQL chapter.

I found <sql-query> but know it dows not fetch anything.
any idea? Probably I should configurig something in hibernate.cfg.xml.but what?

well the documentation on join is very sparse. he uses "on", the documentation does not mention it (as far as i know), but a simple clearing statement from any hibernate team member would have been better than just joking about a newbie ;-)