aspose file tools*
The moose likes JDBC and the fly likes difference between sensitive and insensitive of resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "difference between sensitive and insensitive of resultset" Watch "difference between sensitive and insensitive of resultset" New topic
Author

difference between sensitive and insensitive of resultset

subbareddy meruva
Greenhorn

Joined: Dec 06, 2007
Posts: 1
can anyone tell me the exact difference between resultset sensitive and insensitive in jdbc applications.......please help me
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Hi subbareddy,

Welcome to Javaranch.

Please visit the URL

http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/resultset.html

and read the section 5.1.7 Types of Result Sets

if still you face problems in understanding same, there is lot of help available at ranch.

Thanks,
Shailesh Chandra


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Qussay Najjar
Ranch Hand

Joined: Jan 18, 2008
Posts: 53
Originally posted by subbareddy meruva:
can anyone tell me the exact difference between resultset sensitive and insensitive in jdbc applications.......please help me


Hi Meruva,
I totally agree with Shailesh, that Sun's Documentation is just the best way to know all details, but I can give you a brief:
Imagine that your application displayed a number of records from DB, well if any changes happens after displaying, it won't effect the records shown.
So in order to make your ResultSet sensitive to changes made by others, just declare it as (TYPE_SCROLL_SENSITIVE).
And the opposite is (TYPE_SCROLL_INSENSITIVE).



Qussay NAJJAR
 
Don't get me started about those stupid light bulbs.
 
subject: difference between sensitive and insensitive of resultset