hello, Thanks for the response. I am not using Oracle, but it seems that we are having very similar problems. It seems that when NHibernate returns the values it automatically tries to use a Decimal type instead of a Float type. Is there a way to force NHibernate to use a float on a field in a table? I have tried to set Type="float" in the mapping file, but that didn't help.
Thanks, Eli On Thu, Nov 3, 2011 at 2:21 PM, Mirko Klupitz <[email protected]> wrote: > are you using oracle? > i had the same issue with oracle since the .net provider calls > GetDecimal and should call GetOracleDecimal b/c a "oracledecimal" can > be larger than the standard .net decimal. > > On 1 Nov., 14:37, Eli <[email protected]> wrote: > > Hey guys, > > > > First of all, new member introduction. I'm Eli, and am working on a > > C# application to do spectrophotometry. Hopefully someone might be > > able to help with this problem. Bare with me, I inherited this > > NHibernate code from someone else, and am trying to learn it as fast > > as I can. Here goes... > > > > In a nutshell, I am using NHibernate to store data locally for a > > desktop application. Data is read from a USB device and then put into > > the local Database. This works fine. The problem is that when I try > > to read the data from the database I get an exception: > > > > NHibernate.Exceptions.GenericADOException{"could not initialize a > > collection: "} with an inner exception of : System.OverflowException > > {"Value was either too large or too small for a Decimal."} > > > > The suspect value is in a StandardDeviation float that we successfully > > put into the database, but it seems that it is too large to retrieve. > > When I look at the Database using sqlite3 I see that the value of > > StandardDeviation is 3.40282001837566e+38. > > > > Can anyone think of a reason why this would be allowable to be written > > to the DB, but not readable? > > > > Thanks, > > > > Eli > > -- > 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. > > -- 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.
