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