I am learning CachedRowSet. How do I control transation using CachedRowSet.
Suppose I have two CachedRowSets. I make changes to one of the CachedRowSet and do acceptChanges(); While making updates using another CachedRowSet, I get some database error. Now I want to rollback the changes which I made using first CachedRowSet. How do I do it?
I am using Oracle 9i Database.
I tried connection's rollback, but it doesnt work. Thanks in advance