Hi,

I am very new to hibernate world. I am facing problem with hql queries.

Could you send me an equal query to the following sql query.

"Select RL_ID from REP_LOG where USER_ID = 1234"

Thanks,
Varaprasad.

Map your REP_LOG table to a class called REP_LOG. Make sure the class has properties called RL_ID and USER_ID and map them to this columns.
This way your HQL looks exactly like the SQL.

The big difference is, that the SQL (called via JDBC) gets you a resultset, everything else you have to do yourself (read it, take some actions, create new SQLs and so on).
With Hibernate and HQL you get Java objects. You can change them, create new ones (Sessin.save) delete them (Session.delete) and Hibernate does the rest (all the JDBC stuff) for you.

HTH
Ernst