Hi all,

How can i write this query in Hibernate.

Please help me out it is an urgent requirement for me.


select u.user_det_id,r.reg_no,a.allotment_id,u.first_name,a.no_of_attempt,u.user_Dob,a.site_Dim_Id,a.ews_Id,a.prj_Lay_Id from User_Master u, Bda_Registration r,allotment_information a where u.user_det_id=r.user_det_id and r.reg_no=a.reg_no and a.site_Dim_Id ='04' and a.ews_Id='01' and a.prj_Lay_Id ='01' and a.category_Id ='C08' order by a.no_of_attempt,u.user_Dob desc


Regards
Sreenivasula Reddy A

You know, it's VERY difficult to write a "hibernate query" when you only post a SQL query with zero Hibernate context. Please repost, and include the following:

The Mapping files for each of the tables you have in your SQL query, assuming you actually have those.
Provide some more context around what your are trying to achieve.

You can't get good help, unless you ask detailed questions.

Ryan-

u have to place hbm files and their relation ships also, below is imagination..



[img]select%20u.userDetId,r.regNo,a.allotmentId,u.firstName,a.noOfAttempt,u.userDob,a.site_Dim_Id,a.ews_Id,a.prj_Lay_Id%20from%20UserMaster%20u,%20BdaRegistration%20r,AlotmentInformation%20a%20where%20u.userDetId=r.userDetId%20and%20r.regNo=a.regNo%20and%20a.siteDimId%20='04'%20and%20a.ewsId='01'%20and%20a.prjLayId%20='01'%20and%20a.categoryId%20='C08'%20order%20by%20a.noOfAttempt,u.userDob%20desc%20[/img]

u have to create 3 hbm files and map to table,,,, and use relationships,


Regards
sricharan Reddy A[/quote]