SQL Server JDBC - Resultset updateRow , refreshRow not working

Author

Resultset updateRow , refreshRow not working

Carel du toit

2005-06-07, 9:23 am

Hi

When I do the following:

rs.updateRow
rs.refreshRow

the resultset is not updated as stated in the help files. After
rs.refreshRow was executed I can move between the records succesfully, but
the fields that were updated are not refreshed. When I do a query on the
database the field were correctly updated. I now need to do a re-execute to
update the resultset.

I've got JDBC SP3 installed. I've actually tested this code with JConnect
driver (Evaluation Version) and it worked fine.... just to test the code
logic.

Anybody else got this problem or had this problem and fixed it?

Shelby Goerlitz [MSFT]

2005-06-09, 3:23 am

Carel:

Which help files are you looking at?

This driver doesn't support TYPE_SCROLL_SENSITIV
E resultsets and per spec
this refreshRow() behavior is not-supported by design.

I think this is the same issue from your previous thread --
http://www.mcse.ms/archive90-2005-4-1492887.html.

-shelby

Shelby Goerlitz
Microsoft SQL Server

"Carel du toit" < Careldutoit@discussi
ons.microsoft.com> wrote in message
news:3702B34C-30C1-4C9C-AAD5- 2566FE868154@microso
ft.com...
> Hi
>
> When I do the following:
>
> rs.updateRow
> rs.refreshRow
>
> the resultset is not updated as stated in the help files. After
> rs.refreshRow was executed I can move between the records succesfully, but
> the fields that were updated are not refreshed. When I do a query on the
> database the field were correctly updated. I now need to do a re-execute
> to
> update the resultset.
>
> I've got JDBC SP3 installed. I've actually tested this code with JConnect
> driver (Evaluation Version) and it worked fine.... just to test the code
> logic.
>
> Anybody else got this problem or had this problem and fixed it?

Sponsored Links