• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Pool

 
rohit kuttappan
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all. I need help with connection pools. I'm developing a simple shopping cart application on webappcabaret, which uses MySql as database. I need to know wheter MySql supports connection pools and how to construct them. Please help.
Rohit
 
Arunagiri, Shanmugham
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rohit,
I think u can implement the SingleThreadedModel Interface for using shared resource i.e., it will create an instance of connection by itself on each request, so that u will not get the problem of connection used already by 1 request.
Another way is to code the servlet program to handle connection pooling with thread. This program of handling connection pooling is also available in Jasen Hunter's Java Servlet book.

Hope this helps u a little.
Arun
Sun Certified Programmer for Java 2 Platform.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic