wood burning stoves 2.0*
The moose likes JDBC and the fly likes ResultSet constants Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSet constants" Watch "ResultSet constants" New topic
Author

ResultSet constants

MaheshS Kumbhar
Ranch Hand

Joined: Sep 24, 2009
Posts: 188
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.


I am slow but sure
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38057
    
  22
No, there is a difference: look at this and this.
MaheshS Kumbhar
Ranch Hand

Joined: Sep 24, 2009
Posts: 188
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
Sheriff

Joined: Oct 13, 2005
Posts: 38057
    
  22
don't know.
Ronin Demarco
Greenhorn

Joined: Mar 15, 2010
Posts: 2
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

Joined: Sep 24, 2009
Posts: 188
What does it actually mean by ResultSet read-only and ResultSet updateable then?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ResultSet constants
 
Similar Threads
Does ResultSet close when connection closes?
Data Type Mappings
Static Final Variables Query
updatable recordsets in SYBASE
wrapper class