Hi!

I have to decide wheter to use Hibernate or an other Mappingtool.
For those decision I neet an answert to the following question:

Does Hibernate support composed primary keys, for instance something like that:

create table master (
master_id int,
version int,
primary key pk_master (master_id, version)
);

create table detail(
detail_id int,
master_id int,
version int,
primary key pk_detail(detail_id)
);

alter table detail
add constraint fk_d_m foreign key (master_id, version) references master;

Best Regards
Manfred

yes, Hibernate supports composite ids. Refer to http://www.hibernate.org/hib_docs/reference/html/or-mapping.html#or-mapping-s1-4b