Member Avatar for best4050

I am using getRow() method of ResultSet class like:

int rowCount = result.getRow();

but when i run the application, it gives me the exception that says: The 'getRow()' method is only allowed on scroll cursors.

Please, anyone, who knows why it happened, explain it with some possible solutions
Thanks!

  • 2 Contributors
  • 1 Reply
  • 215 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Ezzaral
Member Avatar for Ezzaral

The API doc on ResultSet says getRow() is optionally supported on forward-only result sets. Sounds like your JDBC driver opted to not support it.

Try creating your statement to be scrollable

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
Edited by Ezzaral
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.