It's all about the answers!

Ask a question

Jazz Team Server Report cant show the data


z lee (4662) | asked May 12 '09, 5:37 a.m.
Hi, I have successfully created a birt report with csv as data.... I then go to rtc and create a report template to deploy the report. It can show the design of the report like the description which I type in the report, but not the data.

It says:
"ReportDesign (id=1):
+ Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: org.eclipse.birt.report.data.oda.sampledb.Driver"



Can someone please advise me how can I solve this problem? Cuz i need to show the data in jazz team server.


Thanks

10 answers



permanent link
James Moody (3.3k24) | answered May 12 '09, 1:42 p.m.
JAZZ DEVELOPER
On 5/12/2009 5:38 AM, disfunction2106 wrote:
Hi, I have successfully created a birt report with csv as data.... I
then go to rtc and create a report template to deploy the report. It
can show the design of the report like the description which I type
in the report, but not the data.

It says:
"ReportDesign (id=1):
+ Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class:
org.eclipse.birt.report.data.oda.sampledb.Driver"



Can someone please advise me how can I solve this problem? Cuz i need
to show the data in jazz team server.


Thanks


Can you please tell me:
1. Which version of RTC you are using? (Specifically, which version is
running on your server)
2. Which data source type did you create in your BIRT report? (looks
like jdbc but you mention csv).

Thanks,
james
Jazz Reports Team Lead

permanent link
z lee (4662) | answered May 13 '09, 3:30 a.m.
I'm using RTC 1.0.1.1... I used attach csv file to the data set and retrieve the data by dragging it to the table. How can I make it shown on jazz team server as well?

permanent link
James Moody (3.3k24) | answered May 13 '09, 11:29 a.m.
JAZZ DEVELOPER
On 5/13/2009 3:38 AM, disfunction2106 wrote:
I'm using RTC 1.0.1.1... I used attach csv file to the data set and
retrieve the data by dragging it to the table. How can I make it
shown on jazz team server as well?


In 1.0.1.1, we did not support CSV data sets. I.e. the BIRT plugins
required to make this work were not deployed in the WAR on our server.
In 2.0 we have added these plug-ins to the server.

james
Jazz Reports Team Lead

permanent link
z lee (4662) | answered May 13 '09, 9:21 p.m.
So am I suppose to re-download RTC 2.0 instead? And if I re-download will I be able to show the CSV dataset on the jazz team server?


Thanks

permanent link
z lee (4662) | answered May 14 '09, 3:33 a.m.
I have downloaded RTC 2.0 and I start the eclipse program. I created a new report and I created a:

data source: Flat File Data Source
data set: I type the data set name click next, there's a error stating
"An error has occurred. See error log for more details.
org/eclipse/datatools/connectivity/oda/flatfile/util/querytextutil/QueryTextUtil.getColumnsInfo(Ljava/lang/String;)LJava/Lang/String;

Please advise me. thanks

permanent link
James Moody (3.3k24) | answered May 14 '09, 10:52 a.m.
JAZZ DEVELOPER
On 5/14/2009 3:38 AM, disfunction2106 wrote:
I have downloaded RTC 2.0 and I start the eclipse program. I created a
new report and I created a:

data source: Flat File Data Source
data set: I type the data set name click next, there's a error stating

"An error has occurred. See error log for more details.
org/eclipse/datatools/connectivity/oda/flatfile/util/querytextutil/QueryTextUtil.getColumnsInfo(Ljava/lang/String;)LJava/Lang/String;

Please advise me. thanks


Can you open a defect with this information please, and assign it to the
Reports component? Also, can you please indicate in the defect whether
you are using 2.0 beta1, or 2.0 M3, or some other milestone? (2.0 final
is not released yet).

Thanks,

james
Jazz Reports Team Lead

permanent link
z lee (4662) | answered May 18 '09, 12:36 a.m.
Hi james, I realised the RTC i'm using initially was RTC version 2.0. I created a new report template and attach the report and save it. And when I double click the report template, the description (text, labels) can appear but not the data (.csv files).

It states the same error:
"ReportDesign (id=1):
+ Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: org.eclipse.birt.report.data.oda.sampledb.Driver"


My RTC is version 2.0 meaning it can accept .csv file? Then why the data cant be shown? Please advise me.


Thanks

permanent link
James Moody (3.3k24) | answered May 19 '09, 1:24 p.m.
JAZZ DEVELOPER
On 5/18/2009 12:37 AM, disfunction2106 wrote:
Hi james, I realised the RTC i'm using initially was RTC version 2.0.
I created a new report template and attach the report and save it.
And when I double click the report template, the description (text,
labels) can appear but not the data (.csv files).

It states the same error:
"ReportDesign (id=1):
+ Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class:
org.eclipse.birt.report.data.oda.sampledb.Driver"


My RTC is version 2.0 meaning it can accept .csv file? Then why the
data cant be shown? Please advise me.


Thanks


What I mean is that we have not released RTC 2.0 yet. So you are running
one of our milestones, or one of our betas. What version, exactly, are
you using?

james
Jazz Reports Team Lead

permanent link
z lee (4662) | answered May 20 '09, 4:03 a.m.
Sorry James, I didnt understood your qns. I've downloaded RTC 1.0.1.1 but when I starts RTC and when it's loading, I show the prompt with Version 2.0. So I guess I'm using 1.0.1.1?


If that's the case does it means RTC can support .csv file only when it is released? Sorry for being so blur

permanent link
James Moody (3.3k24) | answered May 26 '09, 11:27 a.m.
JAZZ DEVELOPER
On 5/22/2009 12:23 PM, disfunction2106 wrote:
Sorry James, I didnt understood your qns. I've downloaded RTC 1.0.1.1
but when I starts RTC and when it's loading, I show the prompt with
Version 2.0. So I guess I'm using 1.0.1.1?


If that's the case does it means RTC can support .csv file only when
it is released? Sorry for being so blur


1.0.1.1 does not support csv, but in 2.0 we've added the necessary
plug-ins to the server to enable this. Can you try your scenario with
2.0beta2 and see if you have any problems?

james
Jazz Reports Team Lead

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.