errors with flat file [message #48842] |
Tue, 21 June 2005 15:21  |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
Trying to test BIRT with a flat file (don't ask, aaargh) and keep getting
the following error when setting up a data set:
A Birt exception occurred.
Error Code:odaconsumer.CannotPrepareStatement
Error Message:Failed to prepare the follwing query for the data set type
(org.eclipse.birt.report.data.oda.flatfile.dataSet).
[select l sIncidentType, x nPotentialLossAmount from Incidents_2005-06-15]
Source data error
Source data error
Anyone have any thoughts as to why?
|
|
|
|
|
Re: found another instance of error mssg [message #49928 is a reply to message #49358] |
Wed, 22 June 2005 17:40   |
Eclipse User |
|
|
|
Hi Mark,
I was messing around with flat file stuff a bit back
the format of the data in the flat file, has to be something like
a,b,c
string,string,string
1,2,3
4,5,6
7,8,9
where abc are your labels
string,string,string are your data type for each column
and then of course the data
hope that helps some.
- Mike
Mark wrote:
> Documented at
> http://dev.eclipse.org/newslists/news.eclipse.birt/msg00759. html
>
> Can anyone report successfully working with flat file data sources?
>
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03275 seconds