db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: ResultSet updateRow() error
Date Tue, 29 Nov 2005 19:00:25 GMT
Hi Danny,

The scenario you described should work. Can you provide a simple
reproducible program for this(along with the table and index creation?

Mamta


On 11/29/05, Danny <danny.gallagher@gainergroup.com> wrote:
>
>
> Derby version = 10.1.2.1
>
> I cannot seem to figure out why this ResultSet update is not working.
>
> I create the ResultSet with the following:
>
> Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
> ResultSet.CONCUR_UPDATABLE, ResultSet.HOLD_CURSORS_OVER_COMMIT);
>
> The query that I execute to return the result set contains the primary
> key,
> FROM contains only one table, and the query contains no JOINS or UNIONS.
>
> So then I call next()
> Update all the columns that I am interested in updating, up to this point
> everything is fine, I can get the column that I updated out, and the
> values
> are the updated ones.
>
> When I call updateRow(), I get: Invalid cursor state - no current row
>
> But there is a current row, I am updating columns in it and those updates
> are taking place.
>
> Any help is appreciated.
> Thanks
>
> Danny Gallagher
> The Gainer Group
> 6525 The Corners Parkway
> Suite 215
> Norcross Ga, 30092
>
>
>
>
>
>

Mime
View raw message