I am new to nhibernate and am wondering if it is possible to not have hibernate overwrite rows when a new object version is saved.

Current behavior...

Object in the DB looks like this to start:
key version column3
12 0 test

change column3 results in:
key version column3
12 1 testing

Can nhibernate make it so that after the change it looks like this?
key version column3
12 0 test
12 1 testing

So that I can keep a history for undo and such.
Thanks.

I am using versioning, and AFAIK you cannot get NH to do what you want "out of the box".

I'm guessing that you would have to set up some sort of version table and control it manually. (I have no idea how, sorry i can't be of more help).

I would love this functionality as well. I tried using views and triggers and the whole thing got real sloppy and NHibernate would often not update b/c the trigger was returning the wrong rowcount back or I would have PK violations.

For now I am writing a custom interceptor and I created readonly versions of the objects I want to audit. When updates go through I create a new history object and save that to the db. It sucks b/c I now have n*2 the number of domain objects to maintain for tracking history.

If anyone has any other ideas I would love to hear them.