I have sound knowledge in Spring MVC and spring Jdbctemplate. But, I am a beginner in hibernate.
I was trying to develop a shopping cart application and using hibernate template to persist data in mysql. I don't know how to execute this query using hibernate template -

select o.user_id,u.address,u.ph_no,o.product_id,i.product_name,i.product_desc,i.product_price from user_ids u,items_avlbl i,order_details o where u.user_id=o.user_id and i.product_id=o.product_id;

[where SignUpHIB is the pojo name for table user_ids]
[ItemsAvlblHIB is the pojo name for table items_avlbl]
[OrderDetailsHIB is the pojo name for table order_details ]


It's very simple to execute this statement using spring jdbctemplate.queryForObject(......sql query).

But, I have no clue how to execute this in hibernate template.
Any help will be appreciated

hibernatesession.createSQLQuery("select o.user_id,u.address,u.ph_no,o.product_id,i.product_name,i.product_desc,i.product_price from user_ids u,items_avlbl i,order_details o where u.user_id=o.user_id and i.product_id=o.product_id").list();

When I try to subclass the composite subclass like this ( I just show the relevant things):





------------------------------------------------------------------------------------------
Trumpet Wedding Dresses|New Style Wedding Dresses|Wedding Dresses with Sleeves|New Style Flower Girl Dresses