Can't preview report on Oracle 11.2 database

Can anyone tell me what is required for BIRT to access an Oracle 11.2 database?

I have a new data source on an 11.2 Oracle database. My current reports were written against a 10g instance.

When I try to preview the same reports now, I get the following message:

Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
There is an error in get connection, Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))).

I suspect I need to install new drivers but my internet searches are not returning any helpful information. And also - which folder(s) should I install the drivers into? /plugins/org.eclipse.birt.report.data.oda.jdbc_<latest version>/drivers ?

Any assistance in this matter would be greatly appreciated.

Using:
Eclipse 3.4.1
BIRT 2.3.1

Find more posts tagged with

Comments

debbie_m

Just some further info:
I have downloaded the 11.2 drivers into Eclipsepluginsorg.eclipse.birt.report.data.oda.jdbc_2.3.1.v20080827drivers but still no joy.

I've edited the datasource to point to the new driver but then get the error 'the selected driver cannot partse the given url'. The given URL is our oracle SID and host file entry for the database

Any clues/hints/suggestions would be welcome. Thank you.

debbie_m

Solution:

The Driver URL values required are:

[HTML]jdbc:oracle:thin:@<server>:1521:<oracle SID>[/HTML]

Avinash02

hi debbie,

same problem i m having, i have created reports ,
DB - oracle 11g release 1
Driver name - ojdbc5.jar
driver url - jdbc:oracle:thin:@192.168.2.xx:xxxx:dbname

the reports are running. but i want to run this in oracle 11g release 2

so can u suggest me the driver name & url.

Also can u tell me y this error comes :

Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
There is an error in get connection, Io exception: The Network Adapter could not establish the connection.

Thanks & regards,
avin