Hibernate version: NHibernate1.2.0Beta

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

The generated SQL (show_sql=true): none

I have a payment table in my database that I am able to persist to fine most of the time. When I'm adding the payment right after I add the associated order it works fine. When I try to add a payment to an existing order I don't get an error, and I get an ID generated by nHibernate for the new payment, but the row never gets created in the database.

I debugged into the nhibernate dlls and saw that it was calling something called ScheduledInsertion. Does this mean it wants to do the insertion asynchronously? I don't want it to work that way if that is what it is trying to do.

In both situations the same block of code is being called to persist the payment object. The only difference in the case when it doesn't work is, the block of code that saves the payment isn't nested in other methods that save other object types to the db. It is being called stand alone.

I get no error messages and I get no SQL in my logs other than some SELECT statements that are superfluous to my problem.

Please help!

and

Thanks

You are not calling Flush(), are you?

I am not calling flush

I just psuedo fixed the problem. Wrapping it in a transaction somehow forced it to insert to the database. I don't want it in a transaction since it's just a single insert. Can anyone help shed some light?

Thanks

Your objects are not persisted untill you call flush. When you commit a transaction the session is automatically flushed.

thanks, that was the problem