ResultSet problem

[ewan91]

Hi

i have code that compiles, and returns the first row of a resultset to a window,
however when i use my menu items to navigate to the last, first etc rows of the result set i get

Exception Occurered during event dispatching:
java.lang.unsupportedOperationException

on the console and nothing happens in the window

any ideas what is happening

thanks
ewan

 

[varocho]

What version of JDBC are you using? I think version 1.0 doesn't allow you to navigate to a previous record.

 

[javaarray]

The way to do this would be to use a CachedRowSet, with this you can move forward,backward and go to locations within the result set.

To get everything you need here are the locations:

JDBC 2.0

http://java.sun.com/products/jdbc/download.html

JDBC Rowset

http://developer.java.sun.com/developer/earlyAcess/crs

JNDI

http://java.sun.com/products/jndi/index.html

Hope this helps