RE: [birt-dev] Preview doesn't work but Standalone Tomcat works.

["Jianqiang Luo" <jluo@xxxxxxxxxxx>]

Hi,

 

The birt-dev mailing list is used by BIRT developers to communicate development-related issues. For questions about using BIRT, please visit the BIRT newsgroup. To report a bug, please use Bugzilla. For more information, please visit http://www.eclipse.org/birt/index.php?page=community.html

 

Thank you for your interest in BIRT.

 

Answer for you question is below: 

In BIRT, currently the jar file of JDBC driver needs to be put into two places. One is %eclipse_home%\plugins\org.eclipse.birt.report.data.oda.jdbc_XXX\drivers, and the other is %eclipse_home%\plugins\org.eclipse.birt.report.viewer_XXX\birt\plugins\org.eclipse.birt.report.data.oda.jdbc_XXX\drivers. If in a little earlier time, the latter is %eclipse_home%\plugins\org.eclipse.birt.report.viewer_XXX\birt\plugins\WEB-INF\org.eclipse.birt.report.data.oda.jdbc_XXX\drivers

 

Thanks,

Jianqiang

 

-----Original Message-----
From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx] On Behalf Of Sri
Sent: 2005年8月13日 2:17
To: birt-dev@xxxxxxxxxxx
Subject: [birt-dev] Preview doesn't work but Standalone Tomcat works.

 

I am quite new to BIRT but using Eclipse for more than a year.

I was a able to create a simple report and was able to see the preview in the 'Data Set', but when I hit the preview tab in the editor area, I see the following error.

Error0 : odaconsumer.CannotOpenConnection(1 time)

detail: Cannot open the connection for the driver

(org.eclipse.birt.report.data.oda.jdbc).

Cannot load JDBC Driver class: [oracle.jdbc.driver.OracleDriver]. 

Cannot load JDBC Driver class: [oracle.jdbc.driver.OracleDriver]. 

I am using Oracle and latest Eclipse & BIRT.

I copied ojdbc14.jar to C:\Apps\eclipse.org\eclipse\plugins\org.eclipse.birt.report.viewer_1.0.1
C:\Apps\eclipse.org\eclipse\plugins\org.eclipse.birt.report.viewer_1.0.1\drivers
C:\Apps\eclipse.org\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_1.0.1
C:\Apps\eclipse.org\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_1.0.1\drivers

Same report works perfect from standalone tomcat using this ojdbc14.jar.

Thanks for any help,
Sri