aspose file tools*
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
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: 36514
    
  16
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: 36514
    
  16
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
Data Type Mappings
updatable recordsets in SYBASE
wrapper class
Does ResultSet close when connection closes?
Static Final Variables Query