Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases 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


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?