java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver(100分)

Z

zhjwjan

Unregistered / Unconfirmed
GUEST, unregistred user!
我的程序在unix或linux下连接oracle数据库,使用classes111.zip连接时出现“Exceding key size”的错误;当使用classes12.zip时,出现java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver的错误,请问为什么用classes111.zip可以找到oracle.jdbc.driver.OracleDriver,但出现
“Exceding key size”的错误,而用classes12.zip就找不到oracle.jdbc.driver.OracleDriver呢?我在windows下完全没问题的。
import java.io.*;
import java.sql.*;
import java.lang.*;
public class OracleTest{
public static void main(String[] args) {
String host = null;
String port = null;
String sid = null;
String pwd = null;
String user = null;
try {
BufferedReader bin = new BufferedReader(new InputStreamReader(System.in));
System.out.println("Oracle connection test, please input the following info:");
System.out.print("host:");
host = bin.readLine();
System.out.print("port:");
port = bin.readLine();
System.out.print("sid:");
sid = bin.readLine();
System.out.print("user:");
user = bin.readLine();
System.out.print("password:");
pwd = bin.readLine();
bin.close();
}
catch (IOException e) {
System.err.println("Error: "+e.getMessage());
}
String driver="oracle.jdbc.driver.OracleDriver";
String url = "jdbc:eek:racle:thin:mad:"+ host +":" + port + ":" + sid ;
System.out.println();
System.out.println(driver);
System.out.println(url);
System.out.println("user:"+user+" pwd:"+pwd);
System.out.println();
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, pwd);
System.out.println("Connection to oracle succeeded");
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
java -classpath .:classes12.zip OracleTest
 
没有人懂吗?高手帮帮忙吧。谢谢了
 
你的classes12.zip版本正确吗?
试着换一个更高的版本。比如6.1.7的jdbc zip版本会比8.1.6稳定。
 
我的classes12.zip是在oracle网站上下载的。我比较了一下classes111.zip和classes12.zip
中的OracleDriver.class文件,发觉在classes12.zip中,OracleDriver.class里有import
oracle.jdbc.driver.OracleDriver,而classes111.zip没有。在windows下,这2个都可以
用,而在unix下只有classes111.zip中的OracleDriver被找到,但是连接时会出现“exceding
key size"的错误。请问会不会因为多了import oracle.jdbc.driver.OracleDriver这句而令
到unix下无法使用呢?
 
接受答案了.
 
顶部