James, A ResultSet is tied to the database. Normally, you make a copy if you just want to store the data locally. You could use a disconnected resultset (or rowset), but you would need to be very careful to never re-connect it because then the database would be affected.
you question is not clear because if you dont want to delete row from database then why you need to do it. What is the reason? Because now i think by telling us your reason would help us to find the better way for you and solve your problem.
Love is GOD and GOD is Love.
M/s. Anand Karia Concreting IT
subject: How to delete a ResultSet row without deleting the underlying database row?