This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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