Hi,
I am implementing mapping of parent-child.
i am trying to insert a parent and one child.
For some reason the Sql that is generated is trying to update the Row for the child instead of inserting one.
here is the code,mapping,usage and db declaration.
db:
Parent table:
CREATE TABLE [dbo].[PID_SnapshotLocation](
[SnapShotID] [int] IDENTITY(1,1) NOT NULL,
[LocationID] [int] NOT NULL,[SnapShotDate] [datetime] NOT NULL,
CONSTRAINT [PK_PID_SnapshotLocation] PRIMARY KEY CLUSTERED
([SnapShotID] ASC)) ON [PRIMARY]
child table:
CREATE TABLE [dbo].[PID_SnapshotItems](
[SnapShotID] [int] NOT NULL,[ItemID] [int] NOT NULL,
[Quantity] [real] NOT NULL
CONSTRAINT [PK_PID_SnapshotItems] PRIMARY KEY CLUSTERED
([ItemID] ASC)) ON [PRIMARY]
ALTER TABLE [dbo].[PID_SnapshotItems] WITH CHECK ADD CONSTRAINT [FK_PID_SnapshotItems_PID_SnapshotLocation] FOREIGN KEY([SnapShotID])
REFERENCES [dbo].[PID_SnapshotLocation] ([SnapShotID])
ALTER TABLE [dbo].[PID_SnapshotItems] CHECK CONSTRAINT [FK_PID_SnapshotItems_PID_SnapshotLocation]
mapping:
parent:
<class name="SnapShotLocation" table="PID_SnapshotLocation">
<id name="SnapShotID">
<generator class="native" />
</id>
<property name="LocationID"/>
<property name="SnapShotDate" type="DateTime"/>
<bag name="Items" inverse="true" cascade="all" optimistic-lock="false">
<key>
<column name="SnapShotID"/>
</key>
<one-to-many class="SnapShotItem"/>
</bag>
</class>
child:
<class name="SnapShotItem" table="PID_SnapshotItems">
<id name="ItemID">
<generator class="assigned" />
</id>
<many-to-one name="SnapShotID" class="SnapShotLocation" column="SnapShotID" cascade="all"/>
<property name="ItemQuantity" column="Quantity" type="double"/>
<property name="CountDate" column="InvCountDate" type="DateTime"/>
<property name="CountAmount" column="InvCountQuantity" type="Double"/>
<property name="ItemCost" type="Double"/>
</class>
code:
parent:
private int m_iLocationID;
private int m_iSnapShotID;
private DateTime m_dtSnapShotDate;
private IList<SnapShotItem> m_sItems = new List<SnapShotItem>();
public SnapShotLocation() { }
public SnapShotLocation(int LocationID, DateTime SnapShotDate)
{
m_iLocationID = LocationID;
m_dtSnapShotDate = SnapShotDate;
}
public virtual void AddItem(SnapShotItem ssi)
{
m_sItems.Add(ssi);
}
public virtual IList<SnapShotItem> Items { get { return m_sItems; } set { m_sItems = value; } }
public virtual int LocationID { get { return m_iLocationID; } set { m_iLocationID = value; } }
public virtual int SnapShotID { get { return m_iSnapShotID; } set { m_iSnapShotID = value; } }
public virtual DateTime SnapShotDate { get { return m_dtSnapShotDate; } set { m_dtSnapShotDate = value; } }
child:
private SnapShotLocation m_sSnapShotLocation;
private int m_iItemID;
private double m_iItemQuantity;
private DateTime m_dtInvCountDate;
private double m_dInvCountQuantity;
private double m_dItemCost;
public SnapShotItem() { }
public SnapShotItem(int ItemID,double ItemQ,DateTime InvCountD,double InvCountAmount,double ItemCost)
{
m_iItemID = ItemID;
m_iItemQuantity= ItemQ;
m_dtInvCountDate = InvCountD;
m_dInvCountQuantity = InvCountAmount;
m_dItemCost = ItemCost;
}
public virtual double ItemQuantity { get { return m_iItemQuantity; } set { m_iItemQuantity = value; } }
public virtual DateTime CountDate { get { return m_dtInvCountDate; } set { m_dtInvCountDate = value; } }
public virtual double CountAmount { get { return m_dInvCountQuantity; } set { m_dInvCountQuantity = value; } }
public virtual int ItemID { get { return m_iItemID; } set { m_iItemID = value; } }
public virtual SnapShotLocation SnapShotID { get { return m_sSnapShotLocation; } set { m_sSnapShotLocation = value; } }
public virtual double ItemCost { get { return m_dItemCost; } set { m_dItemCost = value; } }
usage:
using (ISession session = NHibernateHelper.GetCurrentSession(context))
{
using (ITransaction tx = session.BeginTransaction())
{
SnapShotLocation ssl = new SnapShotLocation(1, DateTime.Now);
SnapShotItem ssi = new SnapShotItem(1, 1, DateTime.Now, 1, 1);
ssi.SnapShotID = ssl;
ssl.AddItem(ssi);
session.SaveOrUpdate(ssl);
tx.Commit();
}}
The commit failes, i pasted the following from the log:
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushEverything line(0):flushing session
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades Cascade line(0):processing cascades for: Retalix.Dax.Applications.PInv.SnapShotLocation
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades CascadeCollection line(0):cascading to collection: Retalix.Dax.Applications.PInv.SnapShotLocation.Items
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades+CascadingAction+ActionSaveUpdateClass Cascade line(0):cascading to SaveOrUpdate()
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl SaveOrUpdate line(0):SaveOrUpdate() persistent instance
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades Cascade line(0):done processing cascades for: Retalix.Dax.Applications.PInv.SnapShotLocation
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades Cascade line(0):processing cascades for: Retalix.Dax.Applications.PInv.SnapShotItem
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades+CascadingAction+ActionSaveUpdateClass Cascade line(0):cascading to SaveOrUpdate()
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl SaveOrUpdate line(0):SaveOrUpdate() persistent instance
[2007-11-29 16:38:16](DEBUG): NHibernate.Engine.Cascades Cascade line(0):done processing cascades for: Retalix.Dax.Applications.PInv.SnapShotItem
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushEntities line(0):Flushing entities and processing referenced collections
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.FlushVisitor ProcessCollection line(0):Processing collection for role Retalix.Dax.Applications.PInv.SnapShotLocation.Items
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl UpdateReachableCollection line(0):Collection found: [Retalix.Dax.Applications.PInv.SnapShotLocation.Items#15], was: [<unreferenced>]
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushEntity line(0):Updating entity: [Retalix.Dax.Applications.PInv.SnapShotItem#1]
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushCollections line(0):Processing unreferenced collections
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushCollections line(0):scheduling collection removes/(re)creates/updates
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushEverything line(0):Flushed: 0 insertions, 1 updates, 0 deletions to 2 objects
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl FlushEverything line(0):Flushed: 1 (re)creations, 0 updates, 0 removals to 1 collections
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.Printer ToString line(0):listing entities:
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.Printer ToString line(0):Retalix.Dax.Applications.PInv.SnapShotItem{ItemQuantity=1, ItemID=1, ItemCost=1, CountDate=11/29/2007, CountAmount=1, SnapShotID=SnapShotLocation#15}
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.Printer ToString line(0):Retalix.Dax.Applications.PInv.SnapShotLocation{LocationID=1, Items=[SnapShotItem#1], SnapShotDate=11/29/2007, SnapShotID=15}
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.SessionImpl Execute line(0):executing flush
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.ConnectionManager FlushBeginning line(0):registering flush begin
[2007-11-29 16:38:16](DEBUG): NHibernate.Persister.Entity.AbstractEntityPersister Update line(0):Updating entity: [Retalix.Dax.Applications.PInv.SnapShotItem#1]
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.BatcherImpl LogOpenPreparedCommand line(0):Opened new IDbCommand, open IDbCommands: 1
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.BatcherImpl Generate line(0):Building an IDbCommand object for the SqlString: UPDATE PID_SnapshotItems SET SnapShotID = ?, Quantity = ?, InvCountDate = ?, InvCountQuantity = ?, ItemCost = ? WHERE ItemID = ?
[2007-11-29 16:38:16](DEBUG): NHibernate.Persister.Entity.AbstractEntityPersister Dehydrate line(0):Dehydrating entity: [Retalix.Dax.Applications.PInv.SnapShotItem#1]
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '15' to parameter: 0
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '1' to parameter: 1
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '11/29/2007' to parameter: 2
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '1' to parameter: 3
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '1' to parameter: 4
[2007-11-29 16:38:16](DEBUG): NHibernate.Type.NullableType NullSafeSet line(0):binding '1' to parameter: 5
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.BatcherImpl LogCommand line(0):UPDATE PID_SnapshotItems SET SnapShotID = @p0, Quantity = @p1, InvCountDate = @p2, InvCountQuantity = @p3, ItemCost = @p4 WHERE ItemID = @p5; @p0 = '15', @p1 = '1', @p2 = '11/29/2007 4:38:13 PM', @p3 = '1', @p4 = '1', @p5 = '1'
[2007-11-29 16:38:16](DEBUG): NHibernate.Impl.BatcherImpl LogClosePreparedCommand line(0):Closed IDbCommand, open IDbCommands: 0
[2007-11-29 16:38:16](ERROR): NHibernate.Impl.SessionImpl Execute line(0):could not synchronize database state with session
NHibernate.StaleStateException: Unexpected row count: 0; expected: 1
at NHibernate.AdoNet.Expectations.BasicExpectation.VerifyOutcomeNonBatched(Int32 rowCount, IDbCommand statement)
at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation)
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session)
at NHibernate.Impl.ScheduledUpdate.Execute()
at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
at NHibernate.Impl.SessionImpl.Execute()
THX alot
Login
FAQ
Search
