Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android 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?
 
Similar Threads
Hibernate session per database user
how to make a ResultSet scrollable
Efficiency of a Search Function as a Web Service
java/MYSQL Serious speed problem.
DatasourceRealm connection pool exhausting