This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin for Android App Development and have Peter Sommerhoff on-line!
See this thread for details.
Win a copy of Kotlin for Android App Development this week in the Kotlin forum!
  • 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:
  • Campbell Ritchie
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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).

 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!