how to configure connection pooling in tomcat server?

[Abhishek Reddy]

can anyone tell me how to configure connection pooling settings in tomcat server?

[Ulf Dittmer]

Look for "DBCP" in the Tomcat DatasSource docs.

[Abhishek Reddy]

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.