Hi,
I am using native query (createSQLQuery) and i have 3 joins in this query, the problem is it is giving problems
Now, if i run the code as it is without addEntity... (all three tables) then the code gives an error saying the column(written in the select part of query) dont exist.
If i write the addEntity on them then it complains of non existing columns in the select statement.

I am a newbie to hibernate and struggling to meet deadline for my project, can anyone here help with my doubt, maybe point to a tutorial or so.
Pl. advice.

thanks
abhishek

Try to use HQL.

the problem with HQL is i have to use class name and not column name in the query.
some of the column name come from the property file in my code,
Also if there is no alternative , is there a HQL editor available somewhere, the one in myeclipse (one i am using) is not good.
pl. advice

thanks
abhishek