java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
redv 2003-03-26 01:02:06 JAVABEAN 程序运行一段时间后,出现下面的异常,必须在SQLServer服务管理器里刷新“刷新服务”才能继续运行(而其他的odbc应用程序却能继续连接数据库)。
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
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.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at com.redv.sql.QueryBean.doQuery(QueryBean.java:139)
at com.redv.sql.PrintBean.getRec(PrintBean.java:368)
at com.redv.sql.PrintBean.printTable(PrintBean.java:399)
at baoming.PrintKaoShiJiHuaBean.print(PrintKaoShiJiHuaBean.java:51)
at _ea._baoming._bxxs._kaoshijihua__jsp._jspService(_kaoshijihua__jsp.java:59)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Wed Mar 26 09:37:02 CST 2003 [wsxk] Can't create a new connection for jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=wsxk
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.redv.sql.DBConnectionManager$DBConnectionPool._$18087(DBConnectionManager.java:556)
at com.redv.sql.DBConnectionManager$DBConnectionPool.getConnection(DBConnectionManager.java:430)
at com.redv.sql.DBConnectionManager$DBConnectionPool.getConnection(DBConnectionManager.java:452)
at com.redv.sql.DBConnectionManager.getConnection(DBConnectionManager.java:120)
at com.redv.sql.QueryBean.getConnection(QueryBean.java:88)
at com.redv.sql.QueryBean.doQuery(QueryBean.java:128)
at com.redv.sql.PrintBean.getRec(PrintBean.java:368)
at com.redv.sql.PrintBean.printTable(PrintBean.java:399)
at baoming.PrintMyKaoShiBean.printBenXiaoXueSheng(PrintMyKaoShiBean.java:76)
at baoming.PrintMyKaoShiBean.print(PrintMyKaoShiBean.java:30)
at _ea._baoming._bxxs._my_0kaoshi__jsp._jspService(_my_0kaoshi__jsp.java:47)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)