Subject Re: [Firebird-Java] .FBSQLException: The resultSet is not in a row, use next
Author Roman Rokytskyy
> Hi I'm getting the following error when using JayBird with RowSets in
> a Java Server Faces DataTableModel:
>
> javax.faces.FacesException: org.firebirdsql.jdbc.FBSQLException: The
> resultSet is not in a row, use next
>
>
> This happens when scrolling past the end of a RowSet or attemting to
> scroll back from the beginning.

For some reason RowSet tries to get data after scrolling past the last row.
I have not clue why this happens and I'm not sure if that is a bug in
JayBird.

> It only happens when the RowSet has been bound to a Firebird Table for
> updates.

You mean updatable cursor or ResultSet.CONCUR_UPDATABLE? If latter, can you
try the version from HEAD, it has already support for updatable cursors.

Roman