Eclipse Community Forums: BIRT » Column types of SQLite data source are all strings

Help

Home

Home » Archived » BIRT » Column types of SQLite data source are all strings(and therefore grouping fails)

Show: Today's Messages :: Show Polls :: Message Navigator

Column types of SQLite data source are all strings [message #664059]

Thu, 07 April 2011 10:56

Jani

Messages: 14
Registered: April 2011

Junior Member

Using BIRT Report Designer 2.6.2 in Linux.

I have a SQLite database (SQlite version 3.7.2) and I'm able to access it with Xerial JDBC driver (http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC).

When I was trying to group data I noticed that BIRT thinks that all columns are strings and therefore report preview complains that Setting a numeric interval on a column with type String is not supported.

I can see from data set (Edit Data Set-dialog > Output Columns) that indeed all columns type are strings even I do have a several integer columns in the database like:

age_years INTEGER NOT NULL,
age_days INTEGER NOT NULL,

I can redefine a column type in Edit Data Set-dialog and change the type from string to integer, but it has no effect. When eclipse is restarted the refinition disappears.

[Updated on: Thu, 07 April 2011 10:59]

Report message to a moderator