
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论坛