Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

difference between sensitive and insensitive of resultset

 
subbareddy meruva
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can anyone tell me the exact difference between resultset sensitive and insensitive in jdbc applications.......please help me
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Qussay Najjar
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic