Frans,
Well can't change the database structure yet. Instead I fixed it this
way by changing my datetime property on my entity to remove
millseconds and seconds from the time.
[DomainSignature]
public virtual System.DateTime DateEntered
{
get
{
//Fix for issue with smalldatetime values and
optimistic locking in nHibernate
_dateEntered =
_dateEntered.AddMilliseconds(_dateEntered.Millisecond * -1);
_dateEntered =
_dateEntered.AddSeconds(_dateEntered.Second * -1);
return _dateEntered;
}
set
{
OnDateEnteredChanging();
_dateEntered = value;
//Fix for issue with smalldatetime values and
optimistic locking in nHibernate
//If we were to send in the seconds and milliseconds
it will look for the version timestamp on our
//object based off of those values but won't find it
since smalldatetime is not stored to that accuratly.
_dateEntered =
_dateEntered.AddMilliseconds(_dateEntered.Millisecond * -1);
_dateEntered =
_dateEntered.AddSeconds(_dateEntered.Second * -1);
OnDateEnteredChanged();
}
}
On Aug 24, 9:36 am, "Frans Bouma" <[email protected]> wrote:
> why not use a 'timestamp' type instead? A date/time field is never going to
> work, as SQLServer stores it with a precision of 300ms, so every action on
> the row within 300ms will look like it's ok, while it's not.
>
> FB
>
>
>
>
>
> > Okay, I figured out what the issue is, but still wondering what to do.
> The
> > table is defined with the SQL datatype of "smalldatetime", and therefore
> > doesn't store the actual SECONDS portion of the time, but nHibernate
> passes
> > that in and therefore can't find the timestamp value.
>
> > What do I do to tell nHibernate this is actually a smalldatetime instead
> of
> > a regular datetime?
>
> > On Aug 24, 9:12 am, MattO <[email protected]> wrote:
> > > 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.Bus
> > > inessObjects.QuickLaunchResponse]
> > > at
> > > NHibernate.Persister.Entity.AbstractEntityPersister.ProcessGeneratedPr
> > > operties(Object id, Object entity, Object[] state,
> > > ISessionImplementor session, SqlString selectionSQL, ValueInclusion[]
> > > includeds)
> > > at
> > > NHibernate.Persister.Entity.AbstractEntityPersister.ProcessInsertGener
> > > atedProperties(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.PerformExecutio
> > > ns(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.- Hide quoted text -
>
> - Show quoted text -
--
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.
