Im trying with an web page which selects some records for update. The next time when the user sends a requests for update or rollback how to find which connection object was used to select those records. Is there any way to rollback just a few records update if a set of records has been selected for update. Please help.
Connection Pooling gives no warranty that a connection will surely be available laterly.
You cannot "rollback" after reading, only after making changes.
If you do updates and evtl. want to rollback laterly, use transactions. But you have no control then on single rows out of the set of updated rows. Always an entire transaction is committed or rolled back.
I would suggest to think about your logic.
You must define a point, until when the user can undo.
Why not doing this all in logic only, not yet in DB.
After user has passed this "point of no return", do the DB update.
