com.microsoft.sqlserver.jdbc.SQLServerException: TDS 协议流无效。

Question

2011-12-4 10:44:21 com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
严重: TDSReader@13f5a2f (ConnectionID:3) got unexpected value in TDS response at offset:149
com.microsoft.sqlserver.jdbc.SQLServerException: TDS 协议流无效。
2011-12-4 10:44:21 com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
严重: TDSReader@13f5a2f (ConnectionID:3) got unexpected value in TDS response at offset:149
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130)
at com.microsoft.sqlserver.jdbc.SimpleInputStream.getBytes(SimpleInputStream.java:343)
at com.microsoft.sqlserver.jdbc.DDC.convertStreamToObject(DDC.java:437)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:1909)
at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:164)
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:113)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1820)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1805)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2078)
at com.qy.dao.impl.JdbcDaoImpl.getObjList(JdbcDaoImpl.java:123)
at com.qy.biz.impl.JdbcBizImpl.getObjList(JdbcBizImpl.java:29)
at com.qy.web.action.TtTlDwr.getTlFlNameList(TtTlDwr.java:25)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

Answer 1

一般是网络协议设置不当造成的，你是不是设置的动态ip，然后ip改变了造成无法连接。。

Answer 2

2012-4-12 14:59:47 com.microsoft.sqlserver.jdbc.TDSReader readPacket
警告: TDSReader@56860b ( ConnectionID:181 TransactionID:0x0000000000000000) Unexpected message type:-127 in TDS header; expected type:4
2012-4-12 14:59:47 com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
严重: TDSReader@56860b ( ConnectionID:181 TransactionID:0x0000000000000000) got unexpected value in TDS response at offset:0
2012-4-12 14:59:47 com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement close
警告: SQLServerPreparedStatementID:181 ( ConnectionID:181 TransactionID:0x0000000000000000): Error (ignored) closing PreparedHandle:0
com.microsoft.sqlserver.jdbc.SQLServerException: TDS 协议流无效。
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.throwInvalidTDS(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.throwInvalidTDS(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$1PreparedHandleClose.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closePreparedHandle(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.close(Unknown Source)