Issue in deploying BIRT report

Hi,

We are using BIRT Eclipse Version: 3.4.0 Build id: I20080617-2000 and MYSQL 5.0 as the back-end. We did a sample development and report design file works perfectly fine in our environment ( windows platform), but doesn't work for our client. When the client tries to run the rptdesignfile in eclipse (they use the same version of eclispe & MYSQL) , BIRT Report Viewer throws an error: "Can't load the report query". Client has deployed the MYSQL on LINUX platform.

There is nothing wrong with the query. I have attached the rtpdesign file.What could be causing this issue?

Appreciate any help on this regard.

Thanks.

Find more posts tagged with

Comments

Virgil Dodson

Hi Susa,

Have you moved over the JDBC driver for MySQL? On their machine, open the data source and use the manage drivers button to make sure that version of Eclipse can see the same JAR files.

Are the versions (and database table schema) of MySQL exactly the same between yours and theirs? I noticed your SQL uses some CAST, InnerJoin, Outerjoin, etc that may act differently if not on the same version.

FYI - I'm moving this thread to the Deploying BIRT forum.