I need help with that.

I try to update a base object in db with his child object and appear this exception:

NHibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) .


Mapping:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="IrmTerminal" table="IRM_TERMINALS"
dynamic-update="true">

<id name="Id" column="IDTERMINAL" unsaved-value="-1">
<generator class="native" />
</id>

<property name="Guid" column="GUID" length="50" not-null="true" />
<property name="Name" column="NAME" length="50" not-null="true" />
<property name="Alias" column="ALIAS" length="50" not-null="false" />
<property name="IsAdTerminal" column="ISADTERMINAL" not-null="false" />
<property name="Active" column="ACTIVE" not-null="false" />
<property name="InsertDate" column="INSERTDATE" not-null="false" />
<property name="LastWsCall" column="LASTWSCALL" not-null="false" />
...
...
<many-to-one name="RollbackCommand" column="IDROLLBACKCOMMAND"/>
<property name="DeviceType" column="DEVICE_TYPE" not-null="false" />
<one-to-one name="TerminalConfig" class="IrmTerminalConfig"/>

<one-to-one name="TerminalInfo" class="IrmTerminalInfo"/>
<one-to-one name="SelectedSnapShot" class="IrmSnapShot"/>
<!--Here I'm going to define first specifyc type of terminal(V-Pro)-->
<joined-subclass name="IrmTerminalVpro"
table="IRM_TERMINALS_VPRO">
<key column = "IdTerminal"/>
<property name="HostName" column="HostName"
length="128" not-null="true" />
<property name="PowerState" column="PowerState" not-null="true" />
<property name="ProvisioningMode" column="ProvisioningMode" not-null="true" />
<property name="ProvisioningState" column="ProvisioningState" not-null="true" />
<property name="AmtUser" column="AMTUser" length="64" not-null="true" />
<property name="AmtPassword" column="AMTPassword" length="64" not-null="true" />
<property name="Ip" column="IP" length="10" not-null="true" />
<property name="IpCustom" column="IPCustom" length="15" not-null="false" />
<property name="Port" column="Port" not-null="true" />
<property name="RedirectPort" column="RedirectPort" not-null="false" />
<property name="Inserted" column="Inserted" length="8" not-null="true" />
<property name="Modified" column="Modified" length="8" not-null="false" />

<bag name="Operations" table="IRM_VPRO_OPERATIONS">
<key column="IdTerminal" />
<one-to-many class="IrmVproOperation" />
</bag>
</joined-subclass>
</class>
</hibernate-mapping>

Is your unsaved value correct?

Generally with Identity columns you'd have a zero for unsaved value (which is the default)

Can you verify that the class you're trying to save has a valid id?

I`m doing a copy of base type object in child type.
unsaved-value is 0 now, and ploblem continues.
I try to save this copy:

if (oTerminal is IrmTerminalVpro)
{
//vPro terminal already exist
oTerminalVpro = (IrmTerminalVpro)oTerminal;
}
else
{
//To Create new vPro terminal object
oTerminalVpro = new IrmTerminalVpro(oTerminal);
}

...
...
...

using (ITransaction oTrans = oSession.Session.Transaction)
{
oTrans.Begin();
oSession.Session.Evict(oTerminal);
oSession.Session.SaveOrUpdate(oTerminalVpro);
oTrans.Commit();
}
oSession.Session.Flush();

When I try to save or update is where exception appear.
I don't know what is the problem.

If the ID is zero, then NHibernate thinks it is an existing record, and tries to update.

The update will affect zero rows, and thus you'll get that error.

Either change the default value of the pk property to -1 or remove the unsaved-value attribute.