ResultSet.updateString() , updateInt() are not updating values

[Shounak Kundu]

Hi,
Here I am .. again to pester you.

This is the code :

  
String firstname = request.getParameter("firstname");
                                                    String lastname = request.getParameter("lastname");
                                                    String password = request.getParameter("password");
                                                    String email = request.getParameter("email");
                                                    String gender = request.getParameter("gender");
                                                    int age = Integer.parseInt(request.getParameter("age"));
            
            Statement stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
            
            
                      String query1 = "SELECT * FROM user_basic_shounak where username = '"+session.getAttribute("loggeduser").toString()+"'";
                      
					  ResultSet rs = stat.executeQuery(query1);
					  while(rs.next())
					  {
                                                    
                                                    rs.updateString("firstname","harry");
                                                    
                                                    rs.updateRow();
                                                    //firstname_temp = rs.getString("firstname");
                                                    rs.updateString("lastname", lastname);
                                                    rs.updateRow();
                                                    rs.updateString("password", password);
                                                    rs.updateRow();
                                                    rs.updateString("email", email);
                                                    rs.updateRow();
                                                    rs.updateString("gender", gender);
                                                    rs.updateRow();
                                                    rs.updateInt("age", age+30);
                                                    rs.updateRow();
                                                  temp_age=  rs.getInt("age");
                                                 out.println("\n\n    Updating :"+rs.getString(3));
					  }
                                         
            






  

[David O'Meara]

how do you know the values are not being updated?

[Shounak Kundu]

Actually I am finding it by making query from the table..

And i don't see any change in the values.

[David O'Meara]

What is your database, what is your Driver, are you using transactions, how are you querying the table?