File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Regarding TYPE_SCROLL_SENSITIVE  ResultSets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding TYPE_SCROLL_SENSITIVE  ResultSets" Watch "Regarding TYPE_SCROLL_SENSITIVE  ResultSets" New topic
Author

Regarding TYPE_SCROLL_SENSITIVE ResultSets

Ayan Dutta
Ranch Hand

Joined: Oct 16, 2005
Posts: 94
It is said that ,a type_scroll_sensitive ResultSet object is scrollable and at the sametime it is sensitive to changes made by others(in the DB).

But if I talk about changes,what sort of changes ? it can be insert,update or delete .which one ? all of them ? (I think ,logically update can be detected,but about insert I am not sure).

Another thing is that ,how this type of resultsets become sensitive to changes made in the DB,I mean how they track it ?


Regards,
Ayan Dutta
Ayan Dutta
Ranch Hand

Joined: Oct 16, 2005
Posts: 94
My main confusion is that once you pick up all the records from DB for a query
(say the query that returns the record as SELECT * FROM A )and you put inside a ResultSet ,how you are tracking whether there are any changes in the DB(say table A)or not ?
Ayan
Ayan Dutta
Ranch Hand

Joined: Oct 16, 2005
Posts: 94
Any clue ? any body ?
Ayan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding TYPE_SCROLL_SENSITIVE ResultSets
 
Similar Threads
TYPE_SCROLL_SENSITIVE
difference between sensitive and insensitive of resultset
TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels
ResultSet.updateInt(...) generated sql
Scrolable ResultSet