Limited rows update

Thread view:

Khan - 25 Mar 2006 14:01 GMT

Hi,
I'm using a table which has 100 rows. I want to update only 15
rows, i'm using stmt.executeUpdate("update sasuser.color set text =
'blue' where value = 'blue'");

with the above quary all 100 rows are updating coz all rows meet the
criteria, but i just want to update 15 rows. I used
stmt.setFetchSize(15); but not working.

Advise some solution.

Thanx.

Reply to this Message

Bill Karwin - 25 Mar 2006 21:03 GMT

> Hi,
> I'm using a table which has 100 rows. I want to update only 15
[quoted text clipped - 3 lines]
> with the above quary all 100 rows are updating coz all rows meet the
> criteria, but i just want to update 15 rows.

Probably the best portable solution is to use a SELECT FOR UPDATE, and fetch
the first 15 rows of the SELECT (remember to explicitly use ORDER BY to make
sure you get the 15 rows you want). Then perform a positioned UPDATE ...
WHERE CURRENT OF CURSOR <cursorname> on each row of the result set.

See the section 5.1.16 "Positioned Updates" here:
http://java.sun.com/j2se/1.5.0/docs/guide/jdbc/getstart/resultset.html
(or in docs of earlier versions of J2SE -- whichever one you use)

Regards,
Bill K.

Reply to this Message

scoffer - 27 Mar 2006 18:46 GMT

Hi,

wich database you have installed??

The syntax of this kind of query is dependant at the database you are using.

> Hi,
> I'm using a table which has 100 rows. I want to update only 15
[quoted text clipped - 8 lines]
>
> Thanx.

Reply to this Message

Limited rows update

Free Magazines