Friday, June 25, 2010

Difference between ResultSet TYPE_SCROLL_SENSITIVE and TYPE_SCROLL_INSENSITIVE

Difference between ResultSet TYPE_SCROLL_SENSITIVE and TYPE_SCROLL_INSENSITIVE

If you would like to have a scrollable ResultSet Object then you need to supply constant when you create an object of it. By default it is FORWARD_ONLY, you can traverse forward in order to fetch records from table.

e.g. Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_READ_ONLY);
Or
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE , ResultSet.CONCUR_READ_ONLY);

Or
Statement stmt = this.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

Or
Statement stmt = this.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);


A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.
Changes will be visible if result set is closed and re-opened.

TYPE_SCROLL_SENSTIVE does not *guarantee* that all changes made to the result set by others will be visible.It depends on a number of factors including the driver implementation (whether it caches the rows or not), the transaction isolation level etc...

4 comments:

  1. There are certain things I don't want to joke about. If it's about somebody else, it's fine.
    If it's about me, I think it's totally insensitive! See the link below for more info.

    #insensitive
    www.ufgop.org

    ReplyDelete
  2. Usefull post. Great material.
    Keep it up
    Thanks for sharing.

    http://wirelesscellularnetwork.blogspot.com/2017/06/wcdma-intra-frequency-handover.html

    ReplyDelete
  3. This looks absolutely perfect. All these tiny details are made with lot of background knowledge. I like it a lot. 
    Selenium training in Chennai

    Selenium training in Bangalore

    ReplyDelete
  4. Stainless steel steel oxide - Titanium Pen - Titanium Art
    Stainless steel titanium dental oxide. Stainless steel oxide is a micro touch hair trimmer corrosion resistant aluminum oxide titanium earrings shell that is made to titanium nitride bolt carrier group last a หาเงินออนไลน์ lifetime.

    ReplyDelete