package com.csc.library.database; import java.sql.Connection; import javax.naming.Context; import javax.sql.DataSource; import com.csc.library.session.InitialEnvironment; import com.csc.library.session.MyContext; import com.csc.library.utilities.MyLog; public class ConnectionPoolManager { /** * Method Pool create a new connection pool */ public ConnectionPoolManager() { System.err.println("DBUtil instance created."); } /** * Method getConnection. * @return Connection New connection from the pool */ public Connection getConnection(String dbName) { Connection conn = null; String dsName = new InitialEnvironment(dbName).getValue("datasource-name"); try { Context ic = new MyContext().getInitialContext(); DataSource ds = (DataSource) ic.lookup(dsName); conn=ds.getConnection(); } catch (Exception e) { MyLog.error(this, e); } return conn; } }