Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Regarding CachedRowSet

 
Vasudhaiv Naresh
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 35977
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Naresh,
Are you closing the connection when done?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!