Re: updatable resultsets -> SQLException: -1

On Wed, 21 Jan 2004, Guido Fiala wrote:

> Am Mittwoch, 21. Januar 2004 03:11 schrieben Sie:
> > > rs.updateString(2,"abc");
> > > rs.updateRow();
> > > rs.previous();//show some other record
> > > rs.next();//go back to modified one
> > > //now the above record has strangely enough vanished from my ResultSet
> > > !!! //how do i get it back? (the ResulSet gives me at that position the
> > > values of the previous-record instead) rs.updateString(2,"xyz");
> > > rs.updateRow();//now i get the SQLException -1
> >
> > You have apparently not navigated back to the original row. The attached
> > program shows the error you are getting. The error message is completely
> > unhelpful here, but it is your code that isn't working.
>
> The question is for me - would have the above code navigate back to the same record?
>
> For me it looks like this:
>
> (see attached code, it throws no excpetion)
>
> The result is with one next():
> a b
> 1 zzz
> 2 aaa
> 3 world
>
> But i would expect it should be:
> a b
> 1 hello
> 2 zzz
> 3 world
>
> Do i need to requery the ResultSet to get the updated record back?
> I would have to remember the primary-key of the record i was editing, to be able to jump back to the correct record after requery.
> Which would be going through a loop until i find my record again as i can not assume that the records are ordered by primary key.
> What a waste of CPU!
>

This is a bug, and it has been fixed. If you use the 7.4 series jar file
from http://jbdc.postgresql.org/download.html you should see the correct
behavior.

Kris Jurka