updateable and scrollable resultset for oracle driver

[sinasi susam]

I created an updateable and scrollable Resultset for Oracle database.
I can update a specific column and scroll down and up too.
I can insert a row in insert row too.

If i commit (its setted to autocommiting to false) the connection then it places the row to table too.

But The problem is ;
for some reason i can't see the inserted row when i scrolled back to the first row and print the rows in a loop.

Here is how i am tring to do that ,

conn.setAutoCommit(false);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

ResultSet rs=stmt.executeQuery("select A from SINASI");


  rs.moveToInsertRow();
  rs.updateString(1,"sssss");
  rs.insertRow();

  rs.beforeFirst();
  
while(rs.next()){
System.out.println(rs.getString(1);
}

Is there something wrong with my code ?
Its thin driver.Or something wrong with my driver?

Thank you.
[ September 12, 2006: Message edited by: sinasi susam ]

[sinasi susam]

Anybody did'nt have any opinion?

Any experience about this?

Do i have to set some more things to achieve that?

[Rajesh Agarwal]

I somehow feel that the row could have been inserted, but what makes you say that this would be the first row.