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();//不再报错