Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 355203

Summary:

Scripted Datasource is not able to fetch the record from JAXB objects when we try to preview the report

Product:

z_Archived

Reporter:

Shivani <shine_1611>

Component:

BIRT

Assignee:

Birt-Data-inbox <Birt-Data-inbox>

Status:

NEW ---

QA Contact:

Sissi Zhu <szhu>

Severity:

normal

Priority:

CC:

bluesoldier, hao.zhou, hustlg

Version:

unspecified

Target Milestone:

---

Hardware:

Other

OS:

Linux

Whiteboard:

Attachments:

Description	Flags
Stacktrace and code used in OPEN And FETCH event	none
Screenshot for dataset	none
Screenshot of Report PREVIEW	none

Description Shivani

2011-08-19 06:44:23 EDT

Build Identifier: Helios 3.6

I tried to use JAXB for the creation of the Javaobjects using XML.
My steps are get Dataset from DB -> create XML object on the fly -> Use JAXB marshalling and fill the JavaObjects.

Now when I use the jar (which i have created to do above metion entire process) during OPEN event of the Scripted Dataset,it behaves very weird, When I click on DATASET and click on "result preview" I see the Data coming correctly from the JavaObject. But as soon as I move to the Eclipse Report preview I see no data only table header is coming. I also tried logging the details and I clearly see the List size it shows ZERO when I use the Report Preview whereas when I do a dataset result preview I get X value.

Reproducible: Always

Steps to Reproduce:
1.Create a XSD from a simple RPTDESIGN XML file.
2. write code to get data from database and now convert the dataset to XML using transformation
3. Now use JAXB marshalling approach to fill the data from XML to JAVA objects.
4. create the jar file and export it with the all dependencies.
5. I am using JTDS for connection and I am using MS SQL DB
6. Go to eclipse helios 3.6, create a report project add a report.
7. create a Datasource by selecting Scripted datasource option.
8. create dataset, add colunms and write code in the open event to get the data from jar method
9. now in dataset FETCH add code to fill the columns.
10. now try Dataset preview and you will be able to see the values in that.
11. now drag and drop the Table and all the columns from dataset.
12. Now click on eclipse Preview and it will not show any thing just the report headers.

Comment 1 Shivani

2011-08-19 06:49:05 EDT

Created attachment 201776 [details]
Stacktrace and code used in OPEN And FETCH event

Comment 2 Shivani

2011-08-19 06:50:04 EDT

Created attachment 201777 [details]
Screenshot for dataset

Comment 3 Shivani

2011-08-19 06:50:51 EDT

Created attachment 201778 [details]
Screenshot of Report PREVIEW

Comment 4 Shivani

2011-08-19 06:53:02 EDT

Jason Weathersby has helped me alot to try this issue, but finally after trying all the possibility, he has suggested that I should be creating a ticket.
Also I have not seen any questions on JAXB on the birt site, there are very few questions and no one has tried java objects using JAXB. whereas othe simple javaobjects  are working fine if I do not use the JAXB.

Comment 5 Gang Liu

2011-11-09 21:58:53 EST

From the error stack, the java.lang.IndexOutOfBoundsException is thrown from user's script, Please check the opee() script.

Could you please tell us the version number of birt?

By the way, the dataset preview may different with the report preview, since the dataset preview is not a precise result