Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection pools

 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am fixing a web application which uses mostly jsp. I am inserting an applet to replace much of the broken function of one specific page. The page makes numerous database calls and, when implemented several people might be on the page at one time (several being maybe a dozen)
I had the crazy thought of implementing a connection pool (I have never done this before) I found some example and followed along but my question is this. If my connection pool class is called when the user hits the page then that is great for user 1 (and a bit of overkill) but once I have a dozen people on-don�t I now have a dozen connection pools and therefore made things worse?
Am I just wasting time anyway given such limited use?

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Pat,
Is this connection pool on the server? If so, the server may already provide one.

Or is it in the applet? If this is the case, the connection pool won't help. Each applet would have it's own and nothing would be pooled.
 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, that was the clarification I was looking for.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic