From the code fragment in your question, I strongly suspect that you are a
newbie: "set rowcount 2" in an executeUpdate() statement makes no sense. The
'rowCount' is the _result_ of the executeUpdate() method, not an input. For
example, this fragment shows the proper use of executeUpdate():

       String updateRowsSQL = "update my.table set salary = salary * 1.5
where workdept = 'D21'";
       Statement updateRowsStmt = null;
       try {
           updateRowsStmt = conn01.createStatement();
           int rowCount = updateRowsStmt.executeUpdate(updateRowsSQL);
       } catch (SQLException sql_excp) {
           System.err.println(CLASS_NAME + "." + METHOD_NAME
                   + " - Encountered SQLException during update. Error: " +
sql_excp);
           sql_excp.printStackTrace();
           System.exit(16);
       }

In this example, 'rowCount' is the value returned by executeUpdate() to show
you the number of rows which _were_ updated; it is not the number of rows
that you _want_ to update.

Now, you may still want to limit the number of rows of your table which are
updated but the normal way of accomplishing that is to write the WHERE
clause of the UPDATE statement so that only the desired rows are updated.
Remember, the SQL UPDATE statement is designed to update _all_ of the rows
which satisfy the WHERE, no matter how many rows that is.

If you can't write a WHERE clause that lets you identify the exact two rows
you want to update, it is very possible that you haven't defined your table
correctly; perhaps you need an additional column or columns to describe each
row more fully. It is also highly possible that you haven't defined a
primary key on your table or that you have chosen the wrong primary key. You
may want to post your table design, indicating all columns in the table and
the primary key that you have chosen, so that someone can assess your design
to see why it doesn't let you update the rows you want to update. Newbies to
database design frequently make mistakes so they should always get more
experienced designers to review their designs.

--
By the way, database questions like yours should normally be asked on
comp.lang.java.databases, not here, since they are more appropriate for that
newsgroup.

--
Rhino