aspose file tools*
The moose likes JDBC and the fly likes Regarding CachedRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding CachedRowSet" Watch "Regarding CachedRowSet" New topic
Author

Regarding CachedRowSet

Vasudhaiv Naresh
Ranch Hand

Joined: May 13, 2005
Posts: 57
hi all!
we are working on an web application which requires to interact with huge amounts of data.
We've tried to use CachedRowSet for this purpose and have configured the Tomcat Server to maintain a connection pool of 4 active connections.
We have found that, the connection pool is getting exhausted even for a single user accessing the same page more than four times.
Please suggest a solution for this. Is there any better way to deal with large amounts of data in web applications.

Development Environment :
Tomcat 5.x
MySql
MySql JDBC Thin Driver

Regards,
Naresh
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30764
    
156

Naresh,
Are you closing the connection when done?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Regarding CachedRowSet