*
The moose likes JDBC and the fly likes Aree scrollable result sets blocks connections? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Aree scrollable result sets blocks connections?" Watch "Aree scrollable result sets blocks connections?" New topic
Author

Aree scrollable result sets blocks connections?

Manohar Karamballi
Ranch Hand

Joined: Jul 17, 2001
Posts: 227
Hi all,

When we use Scrollable result sets for browsing result sets is this going to block my DB connections?
Say I have only 5 conenctions in My DBConnection Pool and 5 users Simultaneously issued search requests which resulted in creation 5 scrollable result sets and users are happily browsing their search result sets.
Now if some other request required DB connection is that request have to wait till @least one of those scrollable result sets are closed?
Also pls let me know Pros and Cons of using Scrollable result sets.
TIA
Manohar
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Aree scrollable result sets blocks connections?