rs.updateInt() not working. . please help

[vikhyath reddy]

Hello everybody... i have a program code which needs to update the fields provided by the user . i am doing something like this.. i have a mysql table which has 27 rows and 20 columns in each row.


<%
String url="jdbc:mysql://localhost:3306/vikh?user=root&password=admin";

con=DriverManager.getConnection(url);
stmt=con.createStatement();
rst=stmt.executeQuery("select * from it_21;");
while(rst.next())
{

out.print("inside while"); //this is getting displayed

rst.updateInt(3,123445); // the program flow is stopping at this point.

rst.updateRow();

out.print("In while"); // this is not getting displayed

}

---- rest of the code ------

%> Thanks in advnace

[Masoud Kalali]

You need to create an update-able ResultSet, something similar to

stmt = con.createStatement(
        ResultSet.TYPE_FORWARD_ONLY,
        ResultSet.CONCUR_UPDATABLE);

The ResultSet object will be forward only meaning that you can not go backward in the ResultSet by calling previous() method.

[vikhyath reddy]

Thanks a lot Masoud ... Im a newbie so learning things ... thanks once again ! : )