one object multiple tables

[Aahil Khan]

Problem: Two tables One class
can anyone help me map Order with hibernate ??

I have One pojo Orders with following properties
userId comes from object User
and Map includes Item name and quantity of Item in basket

Order

private int userId
private int orderId
private Map<Item, Integer> basket

Item

private int itemId
private String name
private int quantity

User

private int userId
private String userName
private String password
private String firstName
private String lastName

my tables summary is below
Order ID is primary key in UserOrder and foreign key in Orders
in orders Order ID and and Item ID are composite Primary key

Tables

UserOrder
---------
USERID NUMBER ORDERID NUMBER PRIMARY KEY

ORDERS
-------
ORDERID NUMBER ITEMID NUMBER QUANTITY NUMBER

[Wouter Oet]

Hi and welcome to the JavaRanch!

Why do you have 2 identifiers instead of references in the Order class?

[Aahil Khan]

itemId is a reference to itemId of the Object Item
which identifiers you are talking about ?

Wouter Oet wrote:Hi and welcome to the JavaRanch!

Why do you have 2 identifiers instead of references in the Order class?

[Wouter Oet]

Sorry I was mistaken. Only one identifier. I mean why this:

private int orderId;
private int userId;

And not this:

private int orderId;
private User user;