• Post Reply Bookmark Topic Watch Topic
  • New Topic

connection pools  RSS feed

 
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
Sheriff
Posts: 37255
519
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!