jdbc至oracle 11g xe.找不到类错误 [英] jdbc to oracle 11g xe. class not found error

问题描述

我已经安装了Oracle 10g Express Edition.我需要将其连接到使用jdbc的java程序.我有ojdbc6_g.jar并设置其类路径.我正在获取类未找到错误.代码如下.请帮助

I've installed oracle 10g express edition. I need to connect it to java program, used jdbc. I have ojdbc6_g.jar and set its class path. I am getting class not found error.Code is given below. Please help

import java.sql.*;

public class OraThin {

    public static void main(String[] args) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@//Terminator:1521/CLRExtProc", "scott", "tiger"); //hostname=Terminator, sid=CLRxtProc
            Statement s = con.createStatement();
            s.execute("insert into student values('PQR',10)");
            s.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

堆栈跟踪:

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver at 
java.net.URLClassLoader$1.run(URLClassLoader.java:366) at 
java.net.URLClassLoader$1.run(URLClassLoader.java:355) at 
java.security.AccessController.doPrivileged(Native Method) at 
java.net.URLClassLoader.findClass(URLClassLoader.java:354) at 
java.lang.ClassLoader.loadClass(ClassLoader.java:423) at 
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at 
java.lang.ClassLoader.loadClass(ClassLoader.java:356) at 
java.lang.ClassLoader.forName0(Native Method) at OraThin.main(OraThin.java:6) 

推荐答案

jar不在类路径中.您可以尝试

The jar is not in the class path. You could try

java -classpath 'path to ojdbc6_g.jar;.' OraThin

ojdbc6_g.jar是调试版本，因此其名称略有不同.可能是您的脚本正在寻找ojdbc6.jar或ojdbc6.jar (如果使用的是IDE，则可以创建一个库并将其添加到项目模块中).

ojdbc6_g.jar is debug version, hence its name is bit different. May be your scripts are looking for ojdbc6.jar or ojdbc6.jar (If you are using an IDE, you will able to create a library and add to the project module).

这篇关于jdbc至oracle 11g xe.找不到类错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！