Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ResultSet constants

 
MaheshS Kumbhar
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wanted to know the difference between two ResultSet constants. ResultSet.TYPE_SCROLL_INSENSITIVE and ResultSet.TYPE_SCROLL_SENSITIVE. Because what I read about these two constants seem to be doing the same thing.
Please let me know if I have gotten this wrong.
 
Campbell Ritchie
Marshal
Posts: 53094
124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, there is a difference: look at this and this.
 
MaheshS Kumbhar
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Campbell.
So does that mean we don't need to provide "ResultSet.CONCUR_READ_ONLY" parameter to createStatement method if we don't want the data in ResultSet to be changed.
 
Campbell Ritchie
Marshal
Posts: 53094
124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
don't know.
 
Ronin Demarco
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So does that mean we don't need to provide "ResultSet.CONCUR_READ_ONLY" parameter to createStatement method if we don't want the data in ResultSet to be changed


Its mentioned on the below link that "A ResultSet should only be made updateable if the functionality is going to be used, otherwise the option CONCUR_READ_ONLY should be used"

http://developer.mimer.com/documentation/html_91/Mimer_SQL_Engine_DocSet/JDBC_API11.html

Many Thanks
D
 
MaheshS Kumbhar
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does it actually mean by ResultSet read-only and ResultSet updateable then?
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!