• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

difference between sensitive and insensitive of resultset  RSS feed

 
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
 
Ranch Hand
Posts: 1085
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
 
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).

 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!