/** * Create instance of Connection Pool * * @return */ public static JDBCDataSource getInstance() { if (datasource == null) { ResourceBundle rb = ResourceBundle.getBundle("in.co.sunrays.bundle.system"); datasource = new JDBCDataSource(); datasource.cpds = new ComboPooledDataSource(); try { datasource.cpds.setDriverClass(rb.getString("driver")); } catch (Exception e) { e.printStackTrace(); } datasource.cpds.setJdbcUrl(rb.getString("url")); datasource.cpds.setUser(rb.getString("username")); datasource.cpds.setPassword(rb.getString("password")); datasource.cpds.setInitialPoolSize(new Integer((String) rb.getString("initialPoolSize"))); datasource.cpds.setAcquireIncrement(new Integer((String) rb.getString("acquireIncrement"))); datasource.cpds.setMaxPoolSize(new Integer((String) rb.getString("maxPoolSize"))); datasource.cpds.setMaxIdleTime(DataUtility.getInt(rb.getString("timeout"))); datasource.cpds.setMinPoolSize(new Integer((String) rb.getString("minPoolSize"))); } return datasource; }