This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Updateable ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Updateable ResultSet" Watch "Updateable ResultSet" New topic
Author

Updateable ResultSet

sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
Hi,
Probably it will sound funny to you,

Do Updateable ResultSets update the columns in db when they are updated?
Or the changes becomes only in ResultSet?
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
I think it would be easier if you described the behaviour you are seeing and what you don't understand about it. A call to updateXXX() methods won't update the database but updateRow() will... or should anyway.

But there are also things like transaction isolation levels that mean that an update you make may not seen by others.. also cursor sensitivity of others.

So the answer is changes in the DB but what you see (depending on above) may not neccessarily make that obvious to you.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Updateable ResultSet
 
Similar Threads
Get Updated Record
ResultSet constants
SQLException: unable to execute updateString for read only Resultset
Programmatic updates in JDBC 2.0
Cursor in DB2