Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
Many to Many relationship Query in hibernate
posted 8 years ago
Hi Good People,
I am stuck in many-to-many relationship problem in Hibernate. I have the following scenario:
Table: cutomers (custid, custname) Table: Product (prodid, prodname) Table: Billing (billingid, custid, prodid)
As you can see third table implementing M:M relationship.
Now i want to display in the UI like :
List of products along with total number of customers in each product.
I have made database query for this problem like :
SELECT prodid, (select count(*) custid from billing where billing.prodid=prod.prodid) as NO_of_customers,DESCRIPTION FROM prod
after that i am unable to understand how
i map this query to any object class ?
Please suggest me if any one has any idea?
Thanks and Regards,
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
Boost this thread!
how to query this in Spring and Hibernate
Inner join in Hibernate
Data type mismatch need to convert string to a number
Help required with DB pagination