Hibernate version: NHibernate1.2.0Beta

Name and version of the database you are using: SQL Server 2000

The generated SQL (show_sql=true): n/a

I have a table that I'm using an increment generator on for the primary key. Every once in a while two rows get the same key and one gets a primary key exception thrown. When this happens I want to try again with the next available id. When I call Save again nhibernate just reuses the old key which is of course still in use. If I zero out the id nhibernate throws an error saying the id changed. How do I tell nhibernate to grab a new id from the db so I can retry the save?

Don't do this, increment generator was not designed to be used in production. Use identity or guid.

I really wish I could use either of those others but I can't. It is part of the DBA's requirement, and in their defense they didn't set it up this way. This is how we all have to live with it for now.

no ideas? How can I just reset the nHibernate's metadata so it doesn't know that I changed the id to 0?

anyone have any ideas on this?