• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Aree scrollable result sets blocks connections?

 
Manohar Karamballi
Ranch Hand
Posts: 227
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic