Question Re: NHibernate driver/dialect error in Technology Q&A

NHibernate driver/dialect error

Former Member — Wed, 14 Nov 2012 14:51:28 GMT

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:

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

Thank you.

Re: NHibernate driver/dialect error

Former Member — Fri, 16 Nov 2012 04:54:52 GMT

I had this problem too!

Re: NHibernate driver/dialect error

jeff_albion — Fri, 16 Nov 2012 13:25:03 GMT

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.

Re: NHibernate driver/dialect error

Former Member — Mon, 19 Nov 2012 14:01:00 GMT

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