0

May I know that anyone have idea on how to go to last row of the result set in JDBC with ctree server?

We have try to use the rs.last() but it return the message said that "Driver not support this function".

Is anyone know in c-tree server, what is the function to have the same result as rs.last() in SQL server?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Alice Tan
  • 1
  • 1
  • If immediately jumping to the last row isn't supported you might need to iterate through the results to get the last. Or you could try to reorder the result to make the last record the first. :) – Thomas Apr 06 '22 at 09:44
  • 1
    Please provide a [mre]. Also, have you checked the documentation, to see if the driver actually supports TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE? `ResultSet.last()` is only supported when you requested those types of result set (the default is TYPE_FORWARD_ONLY) **and** the driver actually supports those types. The error message suggests that either you did not ask for a scrollable result set, or the driver doesn't support it at all. – Mark Rotteveel Apr 06 '22 at 10:10

0 Answers0