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

eclipse jdbc oracle11g driver birt
SeanKilleen picture SeanKilleen · Oct 18, 2011 · Viewed 38.4k times · Source

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

Daniil Shevelev picture Daniil Shevelev · Jul 10, 2013

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

Related questions

Java program to connect to Sql Server and running the sample query From Eclipse

package sqlselection; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Sqlselection { public static void main(String[] args) { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String userName = "sa"; String password = "…

Read More
How to install JDBC driver in Eclipse web project without facing java.lang.ClassNotFoundexception

There is a VERY similar question to mine but in my case I don't have any duplicate jars in my build path, so the solution does not work for me. I've searched google for a couple of hours now, but …

Read More
JDBC connection pool runs out of connections when Context reload="true" is enabled in Tomcat

I am developing a Java EE web application in Eclipse Juno. I have configured Tomcat to use JDBC connection pool (org.apache.tomcat.jdbc.pool) along with PostgreSQL database. Here are the configurations in my project's META-INF/context.xml: <?…

Read More