Hibernate version:
Hibernate3
Mapping documents:
None
Code between sessionFactory.openSession() and session.close():
None
Name and version of the database you are using:
Postgres 8.2

create table reference.hose (
id SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
man varchar(255) NOT NULL,
unique(name,man)
);

Given the fictious table above, I have tried <composite-elements> <composite-id>
and a few others :). What would the mapping look like for something like this. I have been trying to use hbm.xml first and then generating the schema and pojo's from that. The issue was that when I couldn't figure it out, I tried middle gen. Middlegen 2.1 currently only supports hibernate 2.X mappings, so it could be an issue with middlegen.

Any ideas, would be appreciated

Thomas

Don't know if this work with nhibernate but with hibernate you can use unique-key to create a multi column unique constraint. Something like :