Hibernate Community • View topic - 4 object heirarchy with where criteria on 4th object

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

4 object heirarchy with where criteria on 4th object - HQL?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

gaffonso

Post subject: 4 object heirarchy with where criteria on 4th object - HQL?

Posted: Tue Apr 12, 2005 3:21 am

Newbie

Joined: Fri Jan 14, 2005 8:30 pm
Posts: 11

We have an object heirarchy that looks like this:

Order
- contains a set of...

OrderItems
- each OrderItem contains (has an association with) a...

Unit
- each Unit contains (has an association with) a...

Product
- Products have a property called...

SKU

The applicable sql tables/colums for this are:

orders.OrderID

orderitems.OrderID (fk to orders.OrderID)
orderitems.Unit ID (fk to units.UnitID)

units.UnitID
units.ProductID (fk to ProductID)

products.ProductID
products.SKU (<-- our desired selection criteria)

----

We need to write a query that retrieves all orders that have products with particular SKUs.

I can do it in SQL but I'm unsure how to express this "join" in objectified notation.

Can anybody help?

Thanks!

- Gary

Hibernate version:
2.1

Name and version of the database you are using:

MySQL 4.1.8

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum