We've realized today that when saving new instances of some of our mapped classes that are mapped with identity columns are inserted immediately before calling flush on the session. Is this behavior considered correct as the docs seem to indicate that nothing goes to the DB until you flush and especially if your FlushMode is Never.

We want to use long running sessions as discussed in HIA but this issue could be a problem as we're working with a legacy DB and it might be difficult to change the tables to not use an identity column.

Is there a workaround that will keep the inserts from happening until flush is called for identity columns? I can't find anything about it in the ML archives or forum archives.

Thanks...

benster

Yes it is correct, NHibernate has to return an identifier for the object when Save is called and for identity generated id's there is no other way but to go ahead and insert the object immediately. There is no workaround that I know of.

http://www.hibernate.org/hib_docs/reference/en/html/manipulatingdata.html#manipulatingdata-flushing

Thanks for the reply, Sergey - I assume this won't be helped by moving to a H3.X codebase.

Yech.

benster