Featured post
NHibernate <timestamp> mapping for Oracle database causes StaleStateException -
we have nhibernate app migrating sql server oracle. our optimistic concurrency implemented via <timestamp name="version">
mapping element.
the data type of corresponding version
column in oracle date
. after save object, in-memory c# object left timestamp value in milliseconds (e.g. 12:34:56.789) while value in database precise second (e.g. 12:34:56). thus, if attempt save object 2nd time, stalestateexception because 2 values not match.
i attempted fix altering data type of version
column timestamp(3)
. unfortunately, c# object , db value still off 1 millisecond (e.g. 12:34:56.789 vs 12:34:56.788), 2nd attempt save object still causes stalestateexception.
what can create working <timestamp>
mapping oracle column of type date
or timestamp
same object can saved multiple times?
thanks.
-- brian
timestamp(7) has correct precision match .net datetime class , fixed problem.
- Get link
- X
- Other Apps
Comments
Post a Comment