Problem in loading the oracle.jdbc.driver.OracleDriver using DEAPI !

Hello,
I'm quite new to BIRT and currently working on BIRT 2.2 version. I'm writing a customised report engine for my project, wherein I am using both DEAPI and REAPI for modifying the repdesign document.
I'm trying to externalize the DB details (e.g. URL, userID, pwd) from the rptdesign document -- so that using DEAPI I can set the appropriate properties on the OdaDataSourceHandle object at the run-time.
If I work with the default DB (ClassicModels), it works fine; however gives the problem when I try to use our own Oracle DB with the oracle.jdbc.driver.OracleDriver. The error is coming from loading the driver - "unable to load the driver".
I would like to know if anyone has faced similar problem and any solution over the same.
Thanks in advance,

Cheers,
Amit

Find more posts tagged with

Comments

mwilliams

Hi Amit,

Where are you viewing the reports? In the designer or in the deployed viewer?

bholenath

Thanks for the response. Michael. I forgot to mention that part. Our aim is to build a custom report engine -- using the BIRT. This report engine will be exposed to the calling applications in the form of API -- standalone as well as web-enabled.
The problem I encountered was during the POC -- wherein I have a java class which is making use of both DEAPI as well as REAPI. The class is used to modify the report design based on the user parameters - using both DE as well as RE APIs. For rendering I am making use of RE API and not the BIRT viewer. The program gets the repdesign file-name and parameters to apply on report -- it then modifies the report design and generates the report by using RE API classes like IReportEngine and IReportRunnable tasks.
The project classpath consists of all the BIRT 2.22 runtime libs and the ojdbc14.jar - added seperately. The code-snippet I'm using for setting the DB properties is as below:

OdaDataSourceHandle dataSourceHandle = (OdaDataSourceHandle)reportDesignHandle.getDataSources().get(0);
dataSourceHandle.setProperty("odaURL", dbURL);
dataSourceHandle.setProperty("odaUser", userID);
dataSourceHandle.setProperty("odaPassword", password);
System.out.println("report database details are updated.");

Any inputs from your side are much appreciated as I am still unable to figure out any solution.

Thanks,

Cheers,
Amit

mwilliams

Amit,

Possibly could need to put your JDBC drivers in the plugin directory like, ReportEnginepluginsorg.eclipse.birt.report.data.oda.jdbc_[version]drivers.

bholenath

Michael,
Thanks a lot for your help. After placing the JDBC jars in the required directory, the program is working fine.
You're a saviour ! Thanks again.

Cheers,
Amit