java连接oracle9i,急，急，急！

2006-05-23 12:49:50 278 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

CentOS 7 安装 Python 3.10 我这里已经软链接了，正常未链接之前是python->python2.7而不是python3.10。python2.7默认安装是在 /usr/bin目录中，切换到/usr/bin/更改yum配置，因为其要用到python2才能执行，否则会导致yum不能正常使用。2. 安装 Python 3.10 必需的 openssl >= 1.1.1。默认的centos7是没有安装pip，先添加epel扩展源。/usr/bin/python 修改为如下。添加软链接，将原来的链接备份。添加python3的软链接。阅读详情

我的系统：windows xp(sp2)
sdk: jsdk1.4.2_10,环境变量已设好
IDE:eclipse
jdbc驱动是：ojdbc14.jar
我的源代码：
public class DataOracle {

public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle.thin:@" + "127.0.0.1" + ":" + "2030" + ":" +
"ora92";
String username = "scott";
String password = "tiger";
showEmployeeTable(driver,url,username,password);
}

public static void showEmployeeTable(String driver,
String url,
String username,
String password){
try{
Class.forName(driver);
Connection connection =
DriverManager.getConnection(url,username,password);
System.out.println("Employees\n" + "=========");
Statement statement = connection.createStatement();
String query =
"SELECT * FROM emp";
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()){
System.out.print(resultSet.getString("EMPNO") + " ");
System.out.println(resultSet.getString("JOB"));
}
connection.close();
}catch(ClassNotFoundException cnfe){
System.err.println("Error loading driver: " +cnfe);
}catch(SQLException sqle){
System.err.println("Error with connection: " + sqle);
}
}
}
驱动能注册成功，但在连接时出错，显示错误是:
Error with connection: java.sql.SQLException: No suitable driver

...全文