simple joined-subclass example tries to update the identity column of the base table

Question

Hi,

I must be missing something very important in the concept to get this error so any help appreciated.

I get ----> System.Data.SqlClient.SqlException : Cannot update identity column 'ProductID'.

when i run this

 var tblEvent = session.Load<TblEvent>(17);
           tblEvent.Code+= " - test update";
           using (var tran = session.BeginTransaction())
           {
               session.SaveOrUpdate(tblEvent);
               tran.Commit();
           }

The load works correctly and i can inspect all the properties but the update fails.

Heres the mapping file

<hibernate-mapping namespace="Booking.BLL" assembly="Booking.BLL" xmlns="urn:nhibernate-mapping-2.2" >
 <class name="TblProduct" table="tblProduct" schema="dbo">
   <id name="_productID" access="field" column="ProductID"    type="Int32" >
     <generator class="native"  />
   </id>
   <property name="Active" type="Boolean" not-null="true" />
   <property name="AllowBackOrder" type="Boolean" not-null="true" />
   <property name="BuyY" type="Int32" precision="10" />
   <property name="BuyYQty" type="Int32" precision="10" />
   <property name="CategoryID" type="Int32" precision="10" />
   <property name="Code" type="String" length="50" />
   <property name="ColourID" type="Int32" precision="10" />
   <property name="ColourNameOverride" type="String" length="250" />
   <property name="Cost" type="Decimal" precision="10" not-null="true" />
   <property name="CreatedBy" type="Int32" precision="10" />
   <property name="CreatedDate" type="DateTime" />
   <property name="CustomSort1" type="Int32" precision="10" />
   <property name="CustomSort2" type="Int32" precision="10" />
   <property name="CustomSort3" type="Int32" precision="10" />
   <property name="DefaultImageID" type="Int32" precision="10" />
   <property name="Depth" type="Decimal" precision="10" not-null="true" />
   <property name="DispatchCategoryID" type="Int32" precision="10" />
   <property name="DisplayIfNoStock" type="Boolean" not-null="true" />
   <property name="GetXFree" type="Int32" precision="10" />
   <property name="GetXPercentDiscount" type="Decimal" precision="6" />
   <property name="Height" type="Decimal" precision="10" not-null="true" />
   <property name="IsFavourite" type="Boolean" not-null="true" />
   <property name="IsFeatured" type="Boolean" not-null="true" />
   <property name="IsInSite" type="Int32" precision="10" />
   <property name="IsSpecial" type="Boolean" not-null="true" />
   <property name="Keywords" type="String" length="250" />
   <property name="LongDescription" length="2147483647" />
   <property name="LongDescription2" length="2147483647" />
   <property name="LongDescription3" length="2147483647" />
   <property name="ManufacturerID" type="Int32" precision="10" />
   <property name="Name" type="String" length="250" not-null="true" />
   <property name="NoStockMessage" type="String" length="250" />
   <property name="OrderRanking" type="Int32" precision="10" />
   <property name="ParentID" type="Int32" precision="10" />
   <property name="Price" type="Decimal" precision="10" not-null="true" />
   <property name="PriceMember" type="Decimal" precision="10" />
   <property name="PriceRRP" type="Decimal" precision="10" />
   <property name="PriceSpecial" type="Decimal" precision="10" />
   <property name="PromotionID" type="Int32" precision="10" />
   <property name="RefExt" type="String" length="250" />
   <property name="SellBundledOnly" type="Boolean" />
   <property name="Sex" type="Int32" precision="10" />
   <property name="ShortDescription" type="String" length="500" not-null="true" />
   <property name="Size" type="String" length="50" />
   <property name="SizeID" type="Int32" precision="10" />
   <property name="SizeNameOverride" type="String" length="250" />
   <property name="SizeUnit" type="String" length="10" />
   <property name="SpecialEnd" type="DateTime" />
   <property name="SpecialStart" type="DateTime" />
   <property name="Status" type="Boolean" not-null="true" />
   <property name="Stock" type="Int32" precision="10" not-null="true" />
   <property name="SupplierID" type="Int32" precision="10" />
   <property name="TaxExempt" type="Boolean" not-null="true" />
   <property name="UpdateBy" type="Int32" precision="10" />
   <property name="UpdateDate" type="DateTime" />
   <property name="WeightKG" type="Decimal" precision="10" not-null="true" />
   <property name="Width" type="Decimal" precision="10" not-null="true" />
   <many-to-one name="Parent" class="TblProduct" column="ProductID" not-null="true" />
   <bag name="TblProducts" table="tblProduct" inverse="true">
     <key column="ProductID" />
     <one-to-many class="TblProduct" />
   </bag>
       <joined-subclass name="TblEvent" table="tblEvent">
       <key column="EventID" />
               <property name="AttachmentFileURL" type="String" length="200" />
               <property name="GLAccountNo" type="String" length="20" />
               <property name="MultiDayEvent" type="Boolean" not-null="true" />
               <property name="PromotionActive" type="Boolean" not-null="true" />
               <property name="RequiresLogin" type="Boolean" not-null="true" />
               <property name="TopLevelCategoryID" type="Int32" precision="10" not-null="true" />
               <property name="TotalAllocation" type="Int32" precision="10" not-null="true" />
               <bag name="TblSessionTemplates" table="tblSessionTemplate" inverse="true">
                 <key column="EventID" />
                 <one-to-many class="TblSessionTemplate" />
               </bag>
               <bag name="TblSessions" table="tblSession" inverse="true">
                 <key column="EventID" />
                 <one-to-many class="TblSession" />
               </bag>
       </joined-subclass>    
 </class>
</hibernate-mapping>

Answer 1

Ok turns out it was the many-to-one relationship pointing to ProductID instead of parentID. db2hbm seems to have not been able to handle self referencing foreign keys