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 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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Aree scrollable result sets blocks connections?