连接db2数据库报错:打开套接字时出错。
import java.sql.*;
public class Test{
public Test() {
}
public static void main(String[] args) {
try{
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
String url = "jdbc:db2://10.64.1.202:5000/QICC_DB";
String user = "wpl";
String password = "111";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from XZ_GDZC";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
}catch(Exception ex)
{
System.out.println(ex);
}
}
}
编译没问题,运行报错
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E 打开套接字时出错。SQ
LSTATE=08S01