I am using a scrollable sensitive result set. What I know about it, if the Data base value has been changed in the mean time when the JDBC application is traversing the result set, the effect will be displayed in the result set. But surprisingly I am not getting the result. Here is the code.
Hi Gourav, i think you missed the wonder of SCROLLABLE resultset...it facilitates you with the power to traverse the data to and fro, which wasn't available in prev version of Resultset(OK, i won't bother you with the versions).Now, if you have any SELECT query, that creates an implicit cursor in the DB, as if making a COPY of your desired table, with required field values.mind the copy thing, as it's not a live pointer to your DB table.so, once you ran the query, you get data in resultset, but it's now out of sync if you try changing the data from back-end DB itself. Unless you run the query again (through your class), it won't take the updated value.