I am using rs.absolute() for pagination, after this I am population the Data to the ValueObject and sending back to
jsp page.
my resultset is not TYPE_FORWARD_ONLY.
pstmt=con.prepareStatement(query,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
once I made it to ResultSet.TYPE_SCROLL_INSENSITIVE, then it is working and it is not working for ResultSet.TYPE_SCROLL_SENSITIVE.
thanks for ur reply