ITPUB论坛 » Java入门与认证版 » 一个很诡异的异常
新一届的微软MVP评选已经开始,欢迎各位推荐!
2008-7-18 22:16 jiangqiuqiu
一个很诡异的异常

源代码如下:
import java.sql.*;
public class TestSQLServer
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","tom","cat");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from mytable1");

while(rs.next())
{
System.out.println("sid: "+rs.getInt(1));
System.out.println("        name: "+rs.getString(2).trim());
System.out.println("        sex: "+rs.getString(3).trim());
System.out.println();
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
在安装了SQL Server 2000 Driver for JDBC Service Pack 3以及SQLServer SP4补丁后,并且设置了CLASSPATH并且在JCreator中进行了配置,将那三个jar包都添加到了JDK Profiles中后,结果还是出现了如下异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
    at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.microsoft.jdbc.sqlserver.tds.TDSConnection. <init>(Unknown Source)
    at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
    at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
    at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
    at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at TestSQLServer.main(TestSQLServer.java:17)

Process completed.

然后我进行了对1433端口的测试
用telnet进行1433端口测试后,发现了这个问题(显示结果是):
正在连接到1433...不能打开到主机的连接,在端口23:连接失败

我实在是不知道该怎么办了啊!希望高手能够帮帮我
在此多谢各位高手了

2008-7-18 22:33 justforregister
server起了吗,

2008-7-18 22:33 justforregister
防火墙关了吗

2008-7-19 01:32 greenflute
[quote]
然后我进行了对1433端口的测试
用telnet进行1433端口测试后,发现了这个问题(显示结果是):
正在连接到1433...不能打开到主机的连接,在端口23:连接失败
[/quote]

“在端口23:连接失败”?! 您该不会是"telnet 1433"吧:sweat2: :sweat2:

页: [1]
查看完整版本: 一个很诡异的异常


Powered by ITPUB论坛