有人遇到过SqlServer2000的这个问题么?在分页的时候

2004-02-12 21:47:31,633 WARN  hibernate.util.JDBCExceptionReporter  -> SQL Error: 0, SQLState: null
2004-02-12 21:47:31,633 ERROR hibernate.util.JDBCExceptionReporter  -> The result set type is TYPE_FORWARD_ONLY
2004-02-12 21:47:31,653 WARN  hibernate.util.JDBCExceptionReporter  -> SQL Error: 0, SQLState: null
2004-02-12 21:47:31,653 ERROR hibernate.util.JDBCExceptionReporter  -> The result set type is TYPE_FORWARD_ONLY
2004-02-12 21:47:31,673 ERROR hibernate.util.JDBCExceptionReporter  -> Could not execute query
java.sql.SQLException: The result set type is TYPE_FORWARD_ONLY
	at net.sourceforge.jtds.jdbc.TdsResultSet.absolute(TdsResultSet.java:624);
	at net.sf.hibernate.loader.Loader.advance(Loader.java:628);
	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:797);
	at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:846);
	at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540);
	at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27);
	at util.common.PageList.listByCategory(PageList.java:37);
	at test.database.BookDAO.findAllBooks(BookDAO.java:36);
	at test.struts.action.BookListAction.execute(BookListAction.java:30);
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484);
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274);
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482);
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507);
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740);
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853);
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247);
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193);
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643);
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480);
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995);
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643);
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480);
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995);
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417);
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643);
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641);
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641);
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480);
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995);
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174);
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643);
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480);
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995);
	at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193);
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781);
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549);
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589);
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666);
	at java.lang.Thread.run(Thread.java:534);

结果集是不可以滚动的
“The result set type is TYPE_FORWARD_ONLY “

检查hibernate.properties文件
hibernate.jdbc.use_scrollable_resultset=true

---------
刚接触hibernate，不知道对不对，你试一下吧

我知道问题再哪。。。      哎。。。 翻了N久的HIBERNATE网站 才知道SQL SERVER还有一个驱动，下了就解决问题了

说的是jsql吧？

有license?

没有啊，我没查到它做了什么样的限制。是限制使用时间还是怎么的？

当然罗，哪有那么好的便宜捡。
有时间限制！！！

TYPE_FORWARD_ONLY  这个问题是不是回在 ms 的jdbc pack2里出现？