File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
sending updated array of javaBeans from JSP back to Servlet!
cookies problem
need help :: multiple rows update without primary key
NX: How to get the new value from the cell of the JTable ?
Knowning which link was clicked (take 2)