aspose file tools
The moose likes JDBC and Relational Databases and the fly likes clarify updateInt method in ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "clarify updateInt method in ResultSet" Watch "clarify updateInt method in ResultSet" New topic

clarify updateInt method in ResultSet

Gary Frick

Joined: Sep 13, 2002
Posts: 28
Can someone tell me why I am not seeing the effect of updateInt on the row in resultSet.
1). I do a query to recieve one record in my resultSet.
2). Display record for user to verify.
3). If user changes a field value, I apply the users change to the field value in the resultSet row via an updateInt() method.
4). I pass the resultSet to a class/method that handles the inserts
5). Method inserts updated record into another table in same Database.
Since I am inserting the modifed record into another DB, I don't do the updateRow() method. Instead I do a separate Insert using the modified resultSet. However, the ResultSet isn't reflecting the change. I even attempt to display the ResultSet after doing the updateInt but it doesn't show the change either.
rs.updateInt(<value>,<pos> ;
rs.getString(<value> ;
I agree. Here's the link:
subject: clarify updateInt method in ResultSet