connection pooling

[Rohitash sharma]

Can anyone Explain step by step how to use connection pooling.

[Rajesh Kumar Raj]

Hi,

Can you please tell me in which application server you want to create connection pool?

[Rohitash sharma]

Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/dtoregistrationform", "root", "cdn123");

[Rohitash sharma]

Tomcat 6.0.16

[Joe Ess]

For step-by-step instructions, have a look at the Tomcat Documentation: JNDI Resources (scroll down to "JDBC Data Sources").
There are examples for specific databases in the Datasource How-To