exception by committing objects

pbolle · **Joined:** Sun Dec 21, 2003 1:59 pm **Posts:** 5

Hi Community,

I tried to insert two objects with nhibernate. All works fine when I insert the objects separately:

Code:

ISession s1 = OpenSession();
ITransaction t1 = s1.BeginTransaction();

s1.Save(createProcessDefinition());
s1.Save(createStartState());
t1.Commit();
s1.Close();

But then I added the Object startState to processDefiniton I got an exception by committing the session.

Code:

ISession s1 = OpenSession();
ITransaction t1 = s1.BeginTransaction();

ProcessDefinitionImpl process = createProcessDefinition();
process.StartState=createStartState();

s1.Save(process);

t1.Commit();
s1.Close();

The exception text:
SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 0). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count.

Could this be a bug?

Regards
Philipp

KPixel · **Posted:** Wed Sep 28, 2005 1:27 pm

It looks like NHibernate issues an Update for your StartState; can you post your mapping? (make sure that you set the "unsaved-value"...)

KPixel · **Posted:** Wed Sep 28, 2005 1:39 pm

You may also read these posts:
- newbie: using one-to-many mapped classes
- Master/Detail error

pbolle · **Joined:** Sun Dec 21, 2003 1:59 pm **Posts:** 5

Thank you for the great support.
Now all works fine.