I'm using NHibernate (3.3.2.4000) to access my SA12 database. Currently I have an linq expression that take sum of a column [type: numeric(19,2)] but sa server is throwing an exception since generated sql is something like select sum(cast(value as numeric(19,255))) I know numeric(19,255) is invalid. But now I have 2 questions:
Thank you. |
I had this problem too!
Can you post the LINQ code that you're using to calculate this expression?
Have you tried the SA12 dialect with NHibernate 3.1.0.4000 also? Do you see the same issue?
If you examine the SQL Anywhere 11 Dialect code for how the dialect handles the NUMERIC type:
and the (Java) Hibernate documentation describes how
$l
(length, or scale) is automatically passed in by the Hibernate framework. It's possible that this mechanism has changed somehow in 3.3.2.4000 - we'll need more details from you to help confirm this.Jeff, I'll analyze your questions and reply tomorrow.