aspose file tools
The moose likes JDBC and the fly likes Regarding CachedRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26141
    
  66

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding CachedRowSet
 
Similar Threads
MySQL Connection Pooling
BasicDataSource Connection Pool Exception
Creating connection pool for MySql-Tomcat combination -- Code given
Which connection pool is recommended ?
What is Connection pool?