no db2jdbc in java.library.path

显示全部楼层 · 2006-12-12 09:40:00

问题：
在用jdbc连接db2的时候，程序报：
java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path

at COM.ibm.db2.jdbc.app.DB2Driver.(Unknown Source)

at com.servinvent.itmanager.test.DB2Test.(DB2Test.java:16)

at com.servinvent.itmanager.test.DB2Test.main(DB2Test.java:43)
java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:193)

at com.servinvent.itmanager.test.DB2Test.getRs(DB2Test.java:29)

at com.servinvent.itmanager.test.DB2Test.main(DB2Test.java:45)
java.lang.NullPointerException

at com.servinvent.itmanager.test.DB2Test.main(DB2Test.java:47)
---------------------------------------------------------
有人说要把db2java.zip加入到classpath中，可是我这个在db2安装成功之后所有他的驱动都被添加到classpath中去了。
下面的是classpath的设置：
----------------------------------------------------------------------
.;D:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;D:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;D:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;D:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cisuz.jar;D:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;D:\PROGRA~1\IBM\SQLLIB\bin;D:\PROGRA~1\IBM\SQLLIB\java\common.jar
--------------------------测试连接代码----------------------------------------
package com.servinvent.itmanager.test;
import java.sql.*;
public class DB2Test {

Connection con = null;

Statement stmt = null;

String url = "jdbc:db2:SAMPLE";

DB2Test(){

try{

//DriverManager.registerDriver(new COM.ibm.db2.jdbc.app.DB2Driver());

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver&quot

.newInstance();

//Class.forName("com.ibm.db2.jcc.DB2Driver&quot

;

System.out.println("----&quot

;

}catch(Exception e){

e.printStackTrace();

}

}

public ResultSet getRs(String sql) {

ResultSet rs = null;

try {

con = DriverManager.getConnection(url);

stmt = con.createStatement();

rs = stmt.executeQuery(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

if (con != null)

con = null;

}

return rs;

}

public static void main(String[] args) {

DB2Test dt = new DB2Test();

//ResultSet rs1 = dt.getRs("select * from assets$oratbspace&quot

;

ResultSet rs1 = dt.getRs("select * from t$salary&quot

;

try{

while(rs1.next()){

System.out.println(rs1.getString(2));

}

}catch(Exception e1){

e1.printStackTrace();

}

}
}
------------------
各位xdjm帮忙啊~~