Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358995 - Problem running report with crosstab deploy in server
Summary: Problem running report with crosstab deploy in server
Status: RESOLVED WORKSFORME
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.3.1   Edit
Hardware: PC Linux
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Birt-ReportViewer CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-26 23:06 EDT by MartinE CLA
Modified: 2013-03-05 01:28 EST (History)
2 users (show)

See Also:

Attachments
sample reports (8.98 KB, application/x-zip-compressed)
2011-09-28 23:46 EDT, MartinE CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.