| errors with flat file [message #48842] |
Tue, 21 June 2005 19: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 21:40  |
 Mike Boyersmith
Messages: 143
Registered: July 2009 |
Senior Member |
|
|
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?
>
|
|
|
|
| or... [message #50362 is a reply to message #49928] |
Thu, 23 June 2005 13:48 |
| Eclipse User |
|
|
|
Originally posted by: no.spam.com
...are you saying that all the data types must be strings?
|
|
|
|
Powered by
FUDForum. Page generated in 0.03601 seconds
] 
Search
Help
Register
Login
Home
