thanks for the reply.. thanks for the reply, i have configured the connection pool settings in the conetext.xml file. created a class and tested it is working perfectly..
I created a class with static method, which will return the connection object. whenever i need the connection object, iam invoking the static method, once its usage is over iam closing the connection..
now tell me is it the right way of using the connection object in the web application.Will it create any problem later.
subject: how to configure connection pooling in tomcat server?