无法找到或加载oracle.jdbc.driver.OracleDriver [英] Cannot find or load oracle.jdbc.driver.OracleDriver

问题描述

我已经安装了Oracle 11.2和Java:

I have installed Oracle 11.2 and Java:

java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

在命令行中，如果我尝试执行以下操作:

In the command line, if i try to:

java oracle.jdbc.driver.OracleDriver

Java说:无法加载或找到oracle.jdbc.driver.OracleDriver

Java says: impossibile to load or find oracle.jdbc.driver.OracleDriver

我已经复制了ojdbc5.jar，ojdbc6.jar和ojdbc6_g.jar

从oraclexe\app\oracle\product\11.2.0\server\jdbc\lib到
C:\Program Files\Java\jdk1.7.0_09\lib

如果我运行echo %CLASSPATH%，我会得到:

If i run echo %CLASSPATH% I get:

C:\Program Files\Java\jdk1.7.0_09\lib (ie where I have copied the jar files)

任何Java无法找到oracle.jdbc.driver.OracleDriver的原因吗?

Any reasons why Java can't find oracle.jdbc.driver.OracleDriver ?

推荐答案

您在类路径上引用了一个文件夹，并希望它可以加载其中的所有jar.这不是类路径的工作方式，您需要引用特定的jar(通常应该不将第三方jar放入JDK文件夹中).

You reference a folder on the classpath and expect it to load all jars in it. That is not how the classpath works, you need to reference specific jars (and normally you should NOT put third party jars inside the JDK folder).

除了最基本的用例之外，java应用程序通常会忽略CLASSPATH，这也是很重要的.

It is also important to know that the CLASSPATH is usually ignored by java applications, except for the most basic use cases.

您可以通过以下方法来实现自己的目标:

You can do what you try to achieve by doing:

java -cp <path-to>\ojdbc7.jar oracle.jdbc.OracleDriver

这将失败，因为OracleDriver没有public static void main(String[] args)方法，因此无法像这样运行.使用JDBC驱动程序的通常方法是将驱动程序放在应用程序的类路径中，并简单地指定正确的驱动程序URL.会自动从类路径中加载JDBC 4.0(Java 6)或更高版本的JDBC驱动程序(由-cp，Class-Path清单条目等指定).

This will fail btw because OracleDriver has no public static void main(String[] args) method and therefor cannot be run like this. The normal way to use a JDBC driver is to have the driver on the application classpath, and simply specify the right driver URL. JDBC 4.0 (Java 6) or higher compliant drivers will be automatically loaded from the classpath (as specified with -cp, the Class-Path manifest entry etc).

在不相关的注释上，oracle.jdbc.driver.OracleDriver被认为已弃用，请改用oracle.jdbc.OracleDriver，请参见

On an unrelated note, oracle.jdbc.driver.OracleDriver is considered deprecated, use oracle.jdbc.OracleDriver instead, see Difference between Oracle jdbc driver classes?

这篇关于无法找到或加载oracle.jdbc.driver.OracleDriver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！