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 rs = stm.executeQuery("SELECT * FROM foolist");
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.


Jakub Labath

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to