(I have already posted this in the NHibernate forum, since that's what I'm using, but since I have received no answers after several days, and it's not really specifically an NHibernate issue, I thought I would try posting it here as well. Sorry for the cross-post!)

I have an unusual DB schema, which however I would rather not change.

Most of my tables have a composite key. For instance, the Donor table's key is donornum plus year. Each year, I copy all Donors to the new year, retaining their donornum and incrementing the year.

However, donornum is a generated column, so that when I add a new Donor (not a copy from the previous year), it gets a generated new donornum that no other donor has. (In Firebird, it will be done by a Generator.)

Can that be modelled successfully in Hibernate?

Thanks.

This might be what you're looking for: http://www.hibernate.org/117.html#A36