Create connection pools in JDBC

[jith87]

Can u tell me how to create connection pools in JDBC ????
Ths type of creating is said to have reduced the processing time spent during connecting and disconnecting to the databases.

Pls help me........

Thanx n regards............

[JosAH]

Can u tell me how to create connection pools in JDBC ????
Ths type of creating is said to have reduced the processing time spent during connecting and disconnecting to the databases.

Pls help me........

Thanx n regards............

Go to the Apache commons project; they have nice connection pool implementations.
It's the DBCP component.

kind regards,

Jos

[henrymania]

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;


Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/HRMS");
con = ds.getConnection();

[henrymania]

type ur database name in the lookup