This content has been marked as final.
Show 3 replies
-
1. Re: A classic EJB Left Join and Order By clause problem
abuayyub Sep 17, 2006 4:20 AM (in response to app4you)The hibernate dock has this concerning order by
The list returned by a query may be ordered by any property of a returned class or components:
regards abuayyub -
2. Re: A classic EJB Left Join and Order By clause problem
app4you Sep 19, 2006 8:20 AM (in response to app4you)Well I found the solution to my problem by updating to Oracle to 10g since any version below 10g does not support the ORDER BY column that is not a part of the SELECT statement. Also just a thought out loud, it seems that a lot of posts don't have any answer at all. Folks please help out if you know the answer.
Thanks,
John -
3. Re: A classic EJB Left Join and Order By clause problem
fhh Sep 19, 2006 9:42 AM (in response to app4you)
Well I found the solution to my problem by updating to Oracle to 10g since any version below 10g does not support the ORDER BY column that is not a part of the SELECT statement.
I'm not sure what you're error msg said but I don't believe this was the problem. I just triedSELECT columnA FROM tableA order by columnB
and it works flawlessly. Of course, it does!
Regards
fhh