Win a copy of Design for the Mind this week in the Design 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
Marshal
Posts: 34178
340
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