找不到Oracle jdbc驱动程序
问题描述:
我是java和数据库连接的新手,我试图与oracle数据库进行非常简单的连接。当我运行这段代码时:找不到Oracle jdbc驱动程序
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
public class Hello
{
public String sayHtmlHello()
{
try {
// Load the JDBC driver
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
// Create a connection to the database
String serverName = "sever2";
String portNumber = "1521";
String sid = "serv1";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber +":" + sid;
String username = "user";
String password = "pass";
OracleDataSource ods = new OracleDataSource();
ods.setUser(username);
ods.setPassword(password);
ods.setURL(url);
Connection conn = ods.getConnection();
System.out.println("Connection made?");
} catch (ClassNotFoundException e) {
// Could not find the database driver
System.out.println("Can't find database driver");
} catch (SQLException e) {
// Could not connect to the database
System.out.println("Can't connect to database");
}
我得到输出Can't find database driver
。我正在使用Eclipse Helios,并且已将ojdbc6.jar
添加到我的构建路径中(我仔细检查了第一件事),并且使用了JDK 1.6。
您可以在第一个catch块中使用e.printstacktrace()并粘贴完整的堆栈跟踪吗? – nsfyn55 2011-05-25 14:49:55
还是更好,不要捕捉异常(重新抛出它''抛出新的RuntimeException(e)') – artbristol 2011-05-25 14:55:15
@atbristol在技术上你必须赶上它来重新抛出:) – nsfyn55 2011-05-25 16:31:27