Hi,

I have a problem with the below query,

Caused by: org.hibernate.QueryException: , expected in SELECT [SELECT s.id AS id, s.status AS status, s.firstName AS companyName FROM Student AS s ORDER BY s.firstName asc]

What would be the problem with the query ?

The same query works fine when I remove the aliases been given for the properties.

Meaning: SELECT s.id, s.status, s.firstName FROM Student AS s ORDER BY s.firstName asc -- works fine

Thanks,
Senthilkumar Arumugam

hey read this

http://www.roseindia.net/hibernate/hibe ... mple.shtml

I am not able to relate this example with the Exception I am facing.

@niks23
Did you at least read the question before posting your answer?
Your 2 posts are not even related to the subject ... the problem does not come from the order-by clause and he is using HQL not SQL