"Unable to locate JAR/zip" error for JDBC connections [BIRT Eclipse, Windows 7, Oracle 11g]

Question

As an FYI, I'm new to this entire stack, so I might be making a basic error.

I'm attempting to explore BIRT reporting for a Maximo system that was recently upgraded.

To do so, I installed the following:

• Java 6 & Java 7 JDKs
• BIRT version of Eclipse (Eclipse + BIRT plugins built in).
• Some Oracle 11gR2 client options (a custom install)
  • SQL*Plus
  • JDBC/ODBC drivers
  • Thin Client

I take the following steps:

• Open Eclipse
• Create a new Reporting Project
• Add a Data Source
• Select "JDBC Data Source" (also tried "JDBC Database Connection for Query Builder")
• Select the "Oracle" connection profile type and click next.

At this point, I see that the drivers list is empty. This strikes me as odd, but I figure maybe I have to define the driver definition. So I take the following steps:

• Click "Define driver definition"
• In the Name/Type tab, select "Oracle Thin Driver", system version 11

At this point, I see an error message: Unable to locate JAR/zip in file system as specified by the driver definition: ojdbc14.jar. It seems that ojdbc14.jar doesn't even exist on my system that I can find.

I have tried adding other jdbc jar files that I can find in the oracle client directory (i.e. from Oracle_Base\product\11.2.0\client_1\jdbc\lib) but nothing seems to resolve the issue.

Help?

Answer 1

I had similar issue. Clicking "Clear all" and then adding the jar manually solved the problem.

Answer 2

The answer in this case was unfortunately stupidly simple -- after closing and reopening Eclipse, I had no trouble removing the driver, adding another, and getting to work. I was up and running in no time.

Thanks for all your help!