We're trying to save the nhibernate session in the httpsessionstate to resolve some previous issues with persistable objects being stored in httpsessionstate and no longer being associated with a session.

At random times we will begin getting the above error and a message like "sql insert, update, or delete failed, etc" (sorry I don't have the specific wording with me).

I've tried searching google and forums for this error but am not finding much information. Does anyone have any experience with this error?

And a related question: How do most people using nHibernate pass persistable objects about between httprequests (whether it be between different pages or not)? Are you holding the objects in httpsessionstate? Passing the ids in form elements or querystrings and reloading each time? Some other method?