| Strange behaviour with mysql and BIRT data types [message #264138] |
Tue, 08 January 2008 09:37 |
Eclipse User |
|
|
|
I am using BIRT 2.2.1 with mysql 5.0.37 and com.mysql.jdbc.Driver ( v3.0)
for the jdbc connection.
I am creating a dataset with the following query:
select SUM(ulDurationSec) from table1;
The ulDurationSec field is of type "unisgned int" in the mysql table.
Now my problem is that BIRT interpretes the result as being of type
"String" for some reasons and not Integer.
If I explicitly CAST the value:
select CAST(SUM(ulDurationSec) AS UNSIGNED) from table1;
Then BIRT takes the result as a "Decimal" and still not as Integer.
Does that make any sense at all?
Also if I do something like:
select COUNT(*) from table1;
The result is again "Decimal" not Integer.
Is this a normal behaviour? Am I doing something wrong? Could it a problem
with my jdbc connector?
Thanks in advance.
|
|
|
Powered by
FUDForum. Page generated in 0.03811 seconds
Home