I'm getting the following error when running the flush command after
trying to persist an object to the database. I've ran a SQL profiler
trace and I see what is wrong, but I don't know how to fix it.
Basically nHibernate is inserting the record to the database properly,
but when it goes to retrieve the timestamp column it is unable to find
the record that was inserted due to the seconds part of the time being
chopped off and therefore can not retrieve the time part of the
timestamp.
NHibernate: INSERT INTO [dbo].[ott_QuickLaunchResponses]
([ReviewType], [FullKey], [UserAnswer], [AnsweredCorrectly],
[InitialPPlus], [TotalPPlus], [FinalPPlus], [Accept], [Replace],
[Revise], [Delete], [Reject], [Comment], [FormID], [RecordID],
[DateEntered], [Initials]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6,
@p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16);@p0 = 85, @p1
= 'Test ', @p2 = 'Test T', @p3 = True, @p4 = 61, @p5 = 12, @p6 = 77,
@p7 = 0, @p8 = 0, @p9 = 0, @p10 = 0, @p11 = 0, @p12 = 'Test Test ',
@p13 = 38, @p14 = 4, @p15 = 8/24/2010 8:51:13 AM, @p16 = 'Test Test'
We can see the record was inserted properly. nHibernate will now
refresh the timestamp property since optimistic locking is set to
"version" in the mapping file. This is where the error is. Notice
the select statement to retrieve the timestamp (TS column). What
happens at the database level when it is wrapped in an sp_executesql
statement the seconds portion of the datetime variable will get
chopped off and will therefore not find the timestamp value, and thus
the error "Unable to locate row for retrieval of generated properties"
error.
NHibernate: SELECT quicklaunc_.TS as TS17_ FROM [dbo].
[ott_QuickLaunchResponses] quicklaunc_ WHERE quicklaunc_.[formi...@p0
and quicklaunc_.[recordi...@p1 and quicklaunc_.[dateentere...@p2 and
quicklaunc_.[initial...@p3;@p0 = 38, @p1 = 4, @p2 = 8/24/2010 8:51:13
AM, @p3 = 'Test Test'
Test 'ItemBankCoreNH.UnitTests.QuickLaunchResponseTests.Create'
failed: NHibernate.HibernateException : Unable to locate row for
retrieval of generated properties:
[ItemBankCoreNH.BusinessObjects.QuickLaunchResponse#ItemBankCoreNH.BusinessObjects.QuickLaunchResponse]
at
NHibernate.Persister.Entity.AbstractEntityPersister.ProcessGeneratedProperties(Object
id, Object entity, Object[] state, ISessionImplementor session,
SqlString selectionSQL, ValueInclusion[] includeds)
at
NHibernate.Persister.Entity.AbstractEntityPersister.ProcessInsertGeneratedProperties(Object
id, Object entity, Object[] state, ISessionImplementor session)
at NHibernate.Action.EntityInsertAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
at NHibernate.Engine.ActionQueue.ExecuteActions()
at
NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource
session)
at
NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent
event)
at NHibernate.Impl.SessionImpl.Flush()
Base\ManagerBase.cs(209,0): at
ItemBankCoreNH.Base.ManagerBase`2.Flush()
UnitTests\QuickLaunchResponseTests.cs(69,0): at
ItemBankCoreNH.UnitTests.QuickLaunchResponseTests.Create()
Heres a snippet of the HBM file:
<class name="ItemBankCoreNH.BusinessObjects.QuickLaunchResponse,
ItemBankCoreNH" table="[dbo].[ott_QuickLaunchResponses]"
optimistic-lock="version" dynamic-update="true"
lazy="true">
<composite-id>
<key-property name="FormID" column="[FormID]" />
<key-property name="RecordID" column="[RecordID]" />
<key-property name="DateEntered" column="[DateEntered]" />
<key-property name="Initials" column="[Initials]" />
</composite-id>
<version name="TS" generated="always" unsaved-value="null"
type="BinaryBlob">
<!-- Generated="always" is to have database handle
generation of timestamp -->
<column name="TS" not-null="false" sql-type="timestamp"/>
</version>
<property name="ReviewType" column="[ReviewType]" />
<property name="FullKey" column="[FullKey]" />
I have no idea how to fix this.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
