I have a legacy mapping problem. I have two tables:

Table A:
- a_id (PK)

Table B:
- a_id (composite PK part 1)
- index (composite PK part 2)
- type (composite PK part 3) (can be 'I' or 'O')

horrible, and I can't change it. Anyway, in java I want

EntityA
- List<EntityB> iList;
- List<EntityB> oList;

where the members of iList have type 'I' and the members of oList have type 'O', and that's the only difference between them. And the collections are ordered on the index column in table B

Is there some way of mapping this?

Thanks for any tips.[/img]

Hi,

you could create two subclasses of EntityB and use discriminators to distinguish the Entities.

see http://www.hibernate.org/hib_docs/refer ... tance.html

Good Luck,
Frank