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
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Aree scrollable result sets blocks connections?