NHibernate driver/dialect error

[Former Member]

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:

1. How to solve / work around?
2. Why using NHibernate 3.1.0.4000 with sa11 dialect it works?

Thank you.

[Former Member]

I had this problem too!

[jeff_albion]

Currently I have an linq expression that take sum of a column [type: numeric(19,2)]

Can you post the LINQ code that you're using to calculate this expression?

Why using NHibernate 3.1.0.4000 with sa11 dialect it works?

Have you tried the SA12 dialect with NHibernate 3.1.0.4000 also? Do you see the same issue?

How to solve / work around?

If you examine the SQL Anywhere 11 Dialect code for how the dialect handles the NUMERIC type:

 RegisterColumnType( DbType.Decimal, "NUMERIC(19,$l)" ); // Precision ranges from 0-127

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.

[Former Member]

Jeff, I'll analyze your questions and reply tomorrow.