jdbc.url=jdbc:jtds:sqlserver://182.92.222.131:1433/shopxx jdbc.driver=net.sourceforge.jtds.jdbc.Driver问题解决。
SQLServer2000使用Hibernate翻页失败的问题(六)
soft.sqlserver.jdbc.SQLServerResultSet.
(SQLServerResultSet.java:296)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1465)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 144 more
错误信息很多，但主要错误是TDS协议流无效，TDS为SQLServer 所使用的传输协议。刚开始以为是程序问题，但将
数据库换成MySQL后就没有这个错误了，及通过断点调试确定了是SQL Server2000的 问题，就想着换个驱动包试试，网上搜了个JTDS的SQLServer驱动包并修改了下配置，如下：