Still looking for some real help with this question.
We're using Hibernate 3.1 and writing java code with Eclipse.

Suppose our application domain has these aspects:

1. Cases contain boxes.
2. Boxes contain items.
3. Sometimes a case or a box is empty.
4. Sometimes a box or item is loose and has no parent container.

We think our database is properly designed. It has three tables: case, box and item. They have these fields

case.id
case.barcode

box.id
box.case_id
box.position_in_case

item.id
item.barcode
item.position_in_box

We need to display a list that has the following in each row:

case.barcode
box.position_in_case
box.barcode
item.position_in_box
item.barcode

How do we write a query to return a list of objects to populate the list?

TIA,
BE

Dear self,
No replies, huh?

Tough luck.

Suck it up.