java连接DB2的错误,实在搞不定了。
code:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312" %>
<%
Connection con;
try {
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
String url = "jdbc:db2://192.168.0.240:6789/mytest";
String userid ="db2inst1";
String password = "password";
// connect to database with userid and password
con = DriverManager.getConnection(url, userid, password );
}
catch (Exception e)
{
out.println(e.getMessage());
return;
}
if(con==null)
{
out.println("connection is null,fail!");
return;
}
out.println("connection ok!");
%>
错误信息:
[IBM][JDBC Driver] CLI0621E “JDBC 服务器”配置不受支持。
如果端口改为50000则另一个错误:
[IBM][JDBC Driver] CLI0615E 从套接字接收时出错,服务器不响应。SQLSTATE=08S01
但是我的/etc/services文件中有:
db2cdb2inst1 50000/tcp # Connection port for DB2 instance db2inst1
所以我认为connection 的port应该是50000,但实际又好像6789才是????????????????????????????????????????