Cannot load JDBC Driver class:null

Hi,

Am brand new to BIRT and am just setting up first report. I've had a dig around and cannot find an answer to this anywhere - my apologies if I've missed it somewhere on this forum.

I wish to connect to an oracle database with jdbc.

I've copied ojdbc.jar into place here..

C:birtbirt-rcp-report-designer-2_2_0pluginsorg.eclipse.birt.report.data.oda.jdbc_2.2.0.v20070615drivers

I can set up a data source , test it and it works.

However if I try to preview my sql in the Data Set configuration, or attempt to create and configure a chart I get an error
<<<
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.2.0.v200706221
Error Code:odaconsumer.CannotOpenConnection
Error Message:Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: null
>>>

The thing is I know the jdbc data source works ok as I tested the connection in the datasource config. Also when I use the preview tab at the bottom of the report design window , it does return data.

Anyone know what I might be doing wrong - just seems odd that my datasource works ok for some things but not others??

Thanks,

Tim

Find more posts tagged with

Comments

mwilliams

Hi Tim,

What all steps did you follow to set up your dataSource and driver?

terrier77

Hi Michael,

As per instructions from BMC software for use with one of their products, I copied the jdbc driver for oracle to the location as above.

In BIRT,I dragged the datasource object from the library explorer to the outline view, then double clicked it to enter the following:

driver class : oracle.jdbc.driver.OracleDriver (v10.2)
database url : jdbc:oracle:thin:@10.216.180.231:1521:tm32prod
username: TIMP
password: ****

(I left JNDI URL blank)

Test connection at this point worked ok. I've even tried incorrect passwords to make sure this isnt a false positive. It connects just fine.

Then I dragged the parameters :sourcedriver{},sourcepassword{},sourceurl{} and sourceuser{} from the library to the outline.

Next, I created a dataset based on a SQL query. Again, I can tell the JDBC driver connection is working as I can see the database object browser. The query is :

select seriestime,avg(value) from tm32.sv_v_monitors_timeseriesdata
where MONITORNAME='my monitor'
AND PROJECTNAME='myproject'
and MEASURENAME='Availability'
AND AGGREGATIONDESCRIPTION='Week'
group by seriestime
order by seriestime

I haven't done anything with any of the other options (eg output columns, parameters,settings etc..).

Now, if I select preview results I get the error:

cannot open the conenction for the driver: org.eclipse.birt.report.data.oda.jdbc
cannot load JDBC Driver class:null

Reason: A BIRT exception occurred.

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.2.0.v200706221
Error Code:odaconsumer.CannotOpenConnection
Error Message:Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: null

The sql works ok as my user (ie have the neccessary privileges) when connecting with other products.

By the way my version of BIRT is one I downloaded from an application called BMC TMART (version is 2.2.0). I will perhaps try a reinstall with the latest version from the eclipse site.

thanks

Tim

mwilliams

Tim,<br />
<br />
Are you using the latest version of the driver jar file? Here are the instructions on installing a driver file into BIRT for use that you can look at to make sure everything is set up correctly:<br />
<br />
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/build/#drivers'>Pre-Requisites and Detailed Installation Instructions for BIRT</a>