Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Regarding CachedRowSet  RSS feed

 
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
 
author & internet detective
Marshal
Posts: 37693
575
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Naresh,
Are you closing the connection when done?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!