ResultSet.updateRow() problem

[kvikas]

Hi All,
I'm using MS Access DB. I want to trim the data in the table named 'Sold'. I'm getting correct resultset with all rows from table 'Sold'. When i iterate over resultset and tries to update the column value after trimming, only first row gets updated correctly with trimming. Unexpected results occurred from second row. It fetches empty string or string with characters omitted from right if i places leading spaces to the column value in DB.
*empName is the only column in the table 'Sold'. Whose type is 'Text'.

Heres the code,

public void trimDataRows(){
ResultSet rs=null;
int updateCount=0;
String empNo=null, empName=null, tempName=null, checkedFlag=null;
try{
rs=stmt.executeQuery("select * from Sold");

rs.last();
int rowCount=rs.getRow(); //Nomber of rows in resultset.
System.out.println("Count "+rowCount);

for(int i=1; i<=rowCount; ++i){

rs.absolute(i);
empName=rs.getString(1);
System.out.println("Old: "+rs.getString(1)+"& "+empName.length());
tempName=empName.trim();
System.out.println("New: "+tempName+"& "+tempName.length());
rs.updateString(1, tempName);
rs.updateRow();
updateCount++;
}
rs.close();
stmt.close();
con.close();


}catch(Exception e){ e.printStackTrace();}
}

[rico16135]

while(rs.next() ) {
//stuff todo
}

Not clear exactly what your prob is