问题是每隔一段时间估计在7--10分钟后会出现一次 TCP/IP 连接失败,由于程序需要,我是每隔3秒钟刷新一次数据库的,要不刷新就没有这问题com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.NoRouteToHostException: No route to host: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)附:服务已启动,1433端口已打开,防火墙已关闭,tcp/ip已启动
sql05驱动,配置如下
<drivername>com.microsoft.sqlserver.jdbc.SQLServerDriver</drivername>
<url>jdbc:sqlserver://localhost:1433;DatabaseName=dzu8</url>
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)附:服务已启动,1433端口已打开,防火墙已关闭,tcp/ip已启动
sql05驱动,配置如下
<drivername>com.microsoft.sqlserver.jdbc.SQLServerDriver</drivername>
<url>jdbc:sqlserver://localhost:1433;DatabaseName=dzu8</url>
在发生故障时,可以用netstat -an看看1433上的连接数是否很多。