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

Bug 358995

Summary: Problem running report with crosstab deploy in server
Product: z_Archived Reporter: MartinE <martin_erfe>
Component: BIRTAssignee: Birt-ReportViewer <Birt-ReportViewer-inbox>
Status: RESOLVED WORKSFORME QA Contact:
Severity: major    
Priority: P3 CC: bluesoldier, weiming.tang
Version: 2.3.1   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Whiteboard:
Attachments:
Description Flags
sample reports none

Description MartinE CLA 2011-09-26 23:06:43 EDT 
Build Identifier: Version: 3.4.0  Build id: I20080617-2000

Hi,

We only have problem for the report using crosstab.
but we can preview crosstab using eclispse report design(local) but when we deploy to server error encountered running the report:

org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:exception.errorCannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.

other report using table can preview both local and deployed in server.

other info:
BIRT 2.3.1
Java 5
Eclipse 3.4.0
apache-ant-1.6.3
jboss-4.2.3 

note: sample crosstab report send by Jason Weathersby and it works both in local and deployed in server. He ask me to log this in bugzilla for other developer to see.

Reproducible: Always

Steps to Reproduce:
1. run the reports with crosstab in local using report designer and it preview the reports.
2. deploy in linux server and run the report wtih crosstab using apps error encountered
3. same procedure done with report using table and it works both local and server
4. sample report send by Jason it work both local and server
Comment 1 MartinE CLA 2011-09-28 23:46:24 EDT 
Created attachment 204242 [details]
sample reports


JFC_Bulk_Picklist.rptdesign - can run both local preview and deployed in server

JFC_Daily_Bread_test.rptdesign - can run local preview but failed to run in server
Comment 2 MartinE CLA 2011-10-03 05:40:43 EDT 
hi dev team,

can someone help me on this?

thanks/martin100311
Comment 3 MartinE CLA 2011-10-10 02:38:16 EDT 
hi dev team,

any update on this.

thanks/martin101011
Comment 4 weiming tang CLA 2011-11-13 22:34:37 EST 
The report's datasource can't connection.
Can you attach a simple report?
Comment 5 MartinE CLA 2011-11-13 23:30:27 EST 
Hi, 

pls see attached 2 sample reports in zip file

thanks/martin111411
Comment 6 Xiaoying Gu CLA 2013-03-05 01:28:09 EST 
According to the error message, it seems that JDBC driver can not be finded on the server.

I tried with the latest 4.2.2 release and can not reproduce with our in-house oracle database. 
Set as worksforme.

Please feel free to reopen if there is any issues.