ResultSet may only be accessed in a forward direction

      其实本章放在jdbc类别更合适，不过因为本例的连接是通过hibernate的session取得的，所以还是放在hibernate类别了。

驱动包jtds-1.2.2，操作mssql 2005，调用存储过程。抛出ResultSet may only be accessed in a forward direction错误，代码如下：

Connection conn = sessionFactory.getCurrentSession();//sessionFactory为org.hibernate.SessionFactory实例CallableStatement cstmt = null;ResultSet rst = null;cstmt = conn.prepareCall("{?=call p_sys_manager_venditionReport(?,?,?,?)}");cstmt.registerOutParameter(1, java.sql.Types.INTEGER);cstmt.setString(2, sdf.format(startDate));cstmt.setString(3, sdf.format(endDate));cstmt.setInt(4, dptId);cstmt.setInt(5, eplId);rst =cstmt.executeQuery();rst.last();//报错

查看jdk文档，java.sql .ResultSet：默认的 ResultSet 对象不可更新，仅有一个向前移动的光标。很明显，必须对resultSet指定为可滚动的。，

修改 conn.prepareCall代码：

cstmt = conn.prepareCall("{?=call p_sys_manager_venditionReport(?,?,?,?)}",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

但是修改代码后，还是报错：

java.sql.SQLException: ResultSet may only be accessed in a forward direction.
    at net.sourceforge.jtds.jdbc.JtdsResultSet.checkScrollable(JtdsResultSet.java:316)
    at net.sourceforge.jtds.jdbc.JtdsResultSet.last(JtdsResultSet.java:563)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.last(NewProxyResultSet.java:3368)

经过不继修改，用如下代码，终不再报错，究其原因，望知道的朋友解析一下。

Connection conn = sessionFactory.getCurrentSession();//sessionFactory为org.hibernate.SessionFactory实例CallableStatement cstmt = null;ResultSet rst = null;cstmt = conn.prepareCall("{?=call p_sys_manager_venditionReport(?,?,?,?)}",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);cstmt.registerOutParameter(1, java.sql.Types.INTEGER);cstmt.setString(2, sdf.format(startDate));cstmt.setString(3, sdf.format(endDate));cstmt.setInt(4, dptId);cstmt.setInt(5, eplId);cstmt.executeQuery();//注意以下这两行的不同rst = cstmt.getResultSet();rst.last();//不再报错