File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes cachedrowset acceptchanges()  NOT working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
I agree. Here's the link:
subject: cachedrowset acceptchanges() NOT working
It's not a secret anymore!