how to refresh resultset

[Royal Scorpion]

hi guys, i get an updatable resultset from a connection then used it to insert a new row but the result set doesn't chane after insertion, i mean the no of rows before insertion is the same after insertion and also the data, this is the code prove what i say

int currentRow = resultset.getRow();          
display(resultset);          
resultset.moveToInsertRow();          
for (int i = 0; i < fields.size(); i++) 
{            
updateCurrentRow(resultset, fields.getField(i));          
}          
resultset.insertRow();          
display(resultset);

the display function body is
[code]
int currentRow = res.getRow();
res.first();
while (true)
{
System.out.println("CountyCode= " + res.getInt(1)); System.out.println("CountyName= " + res.getString(2));
if (!res.next())
break;
}
res.absolute(currentRow);
Please help me
N.B.
the type of resultset after creation it is res.getConcurrency() == ResultSet.CONCUR_UPDATABLE???
Thanks for your efforts

[Seetesh Hindlekar]

Hi,
Cld be that the record inserted has not been committed!!!
Might as well use the connection.commit() to post the records after inserting.
Seetesh

[Bear Bibeault]

Welcome to the Ranch "Royal Scorpion"!
You'll find this forum a great place to seek help on JSP pages, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
Forum Bartender