Long to be BigDecimal in Report Query

[pttsui]

Hi all, I am connecting using iReport connecting to a MS SQL Server.
I have a table column of bigInt and when I am selecting it through a sQL in the "Report Query". HOwever, the
Field Type retrieved becomes java.math.BigDecimal, which I expected to be java.lang.Long.
Any clues of the wrong data type detection?

[gail26]

From Report Inspector window click the Field you want to change to BigDecimal>Its property will show to property window, right side of your window, change the field class to java.mat.BigDecimal

[pttsui]

Thanks for your reply. I know your solution and it's what we're doing now.

However, it's rather annoying to modify the parameters everytime the SQL is updated. Btw, I find that my colleaque doesn't has the same problem. They get Long from the SQL; whereas I get BigDecimal. We are installing from the same package and cannot explain the difference.

[mdahlman]

One mitigating item is to turn off the auto-refresh feature in the SQL window. I hate that thing. Then the fields only get updated when you want to update them.

The underlying cause is the JDBC driver. The driver reports the data types and iReport just displays them. I suspect that your colleague is using a different driver (or connecting to a different database).

Regards,
Matt