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