Hi Peter
> Why the scrollable result sets are not implemented in the current jdbc
> driver? Is it technically impossible or just no one needed this feature yet?
As far as I know the read-only result sets are working in the recent drivers.
for instance
Statement stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stm.executeQuery("SELECT * FROM foolist");
rs.afterLast();
System.out.println("Printing it reversed");
while (rs.previous()){
System.out.println(rs.getString("id")+", "+rs.getString("text"));
}
works just fine with the latest stable driver
the same is true for last()/first() relative() and absolute() methods.
Regards
--
Jakub Labath