Only 44 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Connection Pool  RSS feed

 
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!