Hello!

How to map in one main class (Person) 2 collections of the same ITEM class (PersonTransaction)?

Person
-> NewTransactions
- one1
- two1
-> OldTransactions
- one2
- two2

I need to put in 'item' table two foreign keys? How to do that?

Chris

Try to design your database like below :-

Item :-
itemId(p.k.)
itemName

Person
personId(p.k.)
item1(F.k.)-->Item
item2(F.k.)-->Item

That means your pojos for above Two Tables will be like below:-

public class Item
{

private long itemId;
private String itemName;
// setter getter of all attributes

}

public class Person
{
private long personId;
private Item item1;
private Item item2;
// setter getter of all attributes
}