On 28/06/2010 10:41, gk wrote:
please look at the doc for ResultSet
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#TYPE_...
TYPE_SCROLL_SENSITIVE
public static final int TYPE_SCROLL_SENSITIVEThe constant indicating
the type for a ResultSet object that is scrollable and generally
sensitive to changes made by others.
What it means by "generally sensitive to changes made by others" ? I
don't get this part.
For general questions of this sort, you'll often get an adequate answer
by searching using Google or some other search engine:
http://en.wikipedia.org/wiki/Cursor_%28databases%29
"Scrollable cursors can potentially access the same row in the result
set multiple times. Thus, data modifications (insert, update, delete
operations) from other transactions could have an impact on the result
set. A cursor can be SENSITIVE or INSENSITIVE to such data
modifications. A sensitive cursor picks up data modifications impacting
the result set of the cursor, and an insensitive cursor does not."
Note that this is really an SQL question, more than a Java question.
Sometimes you'll get more relevant answers to DBMS-specific SQL
questions in an appropriate database newsgroup or forum.
Thanks . your post was very much helpful.- Hide quoted text -