java 和 oracle8i 的连接问题

flush2621 · 发表于 2006-12-15 16:03

找不到JDBC的驱动

JavaRanch · 发表于 2006-12-15 16:08

1 把代码贴上来

2 把classpath贴上来

3 把这个jar包所在目录贴出来

4 把出错信息贴出来
好好看看

flush2621 · 发表于 2006-12-15 16:14

代码：
import java.sql.*;
class Ora8iConnect
{
  public static void main (String args [])
   throws SQLException
  {
  try{
  Class.forName("oracle.jdbc.driver.OracleDriver"

;
}catch(Exception e){
System.out.println("No Driver!"

;
}

String url = "jdbc

racle:thin:@148.20.30.2:1521

ra10";
String userName = "headof";
String password = "headof";

if (args.length > 0) url = args[0];
if (args.length > 1) userName = args[1];
if (args.length > 2) password = args[2];
System.out.println(url);
System.out.println(userName);
System.out.println(password);
Connection conn =
DriverManager.getConnection (url, userName, password);

Statement stmt = conn.createStatement ();

ResultSet rset = stmt.executeQuery ("select * from buyer"

;

while (rset.next ())
System.out.println (rset.getString (1));
}
}

classpath :
C:\j2sdk1.4.2_12\lib\dt.jar;C:\j2sdk1.4.2_12\lib\tools.jar;D:\orant\jdbc\lib\classes12.jar;
jar目录：
D:\orant\jdbc\lib\

JavaRanch · 发表于 2006-12-15 16:22

http://www.oracle.com/technology ... /jdbc_faq.htm#31_01

flush2621 · 发表于 2006-12-15 16:37

是版本问题？打开ORACLE的官网太慢

flush2621 · 发表于 2006-12-15 16:42

我的是JDK1.4的估计不能用8i class12.jar

billyren · 发表于 2007-1-12 10:08

Note: only jars function,zips not. I've notice the problem since 8i,but I don't know the reason.

java 和 oracle8i 的连接问题

浏览过的版块