Friday, July 23, 2010

Java Connection Pooling With Data Sources

public static DataSource setupDataSource(String connectURI,String uName,String pass) {
        ObjectPool connectionPool = new GenericObjectPool(null);
        ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectURI,uName, pass);
        PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,connectionPool,null,null,false,true);
        PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
        return dataSource;
}


This will create Connection Pooling with DataSources
you can call this method as 


 DataSource dataSource = setupDataSource("jdbc:mysql://localhost:3306/testdb","root","root");
Connection conn =  dataSource.getConnection();
// any db operation;
conn.Close();


and perform any database operation, one thing must keep in your mind i.e. you must have to close connection which will return your connection to current data sources connection pool.

No comments:

Post a Comment