converting sql into HQL

Question

I am using http://www.mkyong.com/struts2/struts-2-hibernate-integration-with-full-hibernate-plugin/ as my refernce for struts+hibernate.I need to replace "return session.createQuery("from Customer").list();" in CustomerDAOIMPL.java with the following query

select u.Loginid,c.CID,CNAME,CTICKER,STOCKVALUE,VARIATE,VARIATE_PERCENT,PREVIOUS_DAY_STOCK,MARKET
from company_details c,users_details u,user_company uc where uc.loginpk=u.loginpk AND uc.CID=c.CID AND uc.loginpk IN (select LOGINPK from users_details where LOGINID="check")

how to do write such a query in HQL[Hibernate Query Language] I tried reading my tutorials for google but nothing go into my mind.Please help me,if possible give the link of tutorial for creating HQL from SQL involving Joining tables which is very simple to understand

If you are (completely)new to hibernate, I would recommend, start with converting simple sql to hql and then go for complex one. You'll definitely find those tutorial helpful. Besides for this sql, show your beans & mappings. — RAS
– RAS, Commented Oct 9, 2012 at 7:15

Paolo · Accepted Answer · 2019-12-10 12:15:13Z

3

If you are beginner, go through these simple example's link:

For more reference : http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html

edited Dec 10, 2019 at 12:15

Paolo

21.4k21 gold badges78 silver badges124 bronze badges

answered Oct 9, 2012 at 7:18

Naresh J

2,1475 gold badges26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

converting sql into HQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related