|
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. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 14 Nov '12, 14:51
question was seen: 2,129 times
last updated: 19 Nov '12, 14:01
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.