Subject Re: [Firebird-Java] RowSet Scrolling problem fixed
Author Roman Rokytskyy
Hi Rick,

> The latest code in HEAD fixes the RowSet scrolling problem for some
> reason. I don't have a clue why. Maybe it had something to do with
> updatable ResultSets?

Hmm... in theory it should not. I will check if I did not introduce some
unwanted "functionality" into JayBird with updatable cursors.

Today I have committed fix for auto-commit mode, so updatable result sets
seems to be fully implemented.

> It no longer blows up if you try to scroll past the end of a RowSet or
> before the first item in an updatable JSF DataTable in Creator.

Nice.

> Doing an update of a RowSet is getting much further now, but Creator
> seems to be passing a bad parameter to FBPreparedStatement. I'm
> getting an "Unknown Data Type" SQL error when it tries to update the
> database.

Please check the logs for isc_dsql_prepare_statement, the actual SQL being
prepared. This happens in Firebird when it has no idea about the data type
of the parameter (for example SELECT ? FROM rdb$database).

Thanks!
Roman