This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
Have you checked out Aspose?
 
subject: Regarding TYPE_SCROLL_SENSITIVE ResultSets
 
It's not a secret anymore!