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
Joined: Jan 23, 2001
Posts: 46
posted
0
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.
0
