This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes cachedrowset acceptchanges()  NOT working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "cachedrowset acceptchanges()  NOT working" Watch "cachedrowset acceptchanges()  NOT working" New topic

cachedrowset acceptchanges() NOT working

tushar panda
Ranch Hand

Joined: Feb 16, 2009
Posts: 133
i wrote this code so that "cachedrowset -- crs" (i got from the "resultset -- rs") can be changed according to the condn specified and the modified cachedrowset will be updated in the oracle database.

condn. is when " name=sanjiv" it will change it to "rajiv" both in cachedrowset and database , it is changed in the cachedrowset (according to output below) but NOT changed in the database.

the output is

strange thing is it is not reflected in oracle database even after line 39

Do Right , Fear No Man
wood burning stoves
subject: cachedrowset acceptchanges() NOT working
Similar Threads
Resultset with million rows
CachedRowSet giving "SQLException" when using nextPage( ) method on it.
Strange behaviour when accessing Oracle 8i table from servlet
using datasource help