public static BasicDataSource getDataSource(DBConnectionInfo dci) {
BasicDataSource ds = null;
try {
ds = (BasicDataSource) GSNContext.getMainContext().lookup(Integer.toString(dci.hashCode()));
if (ds == null) {
ds = new BasicDataSource();
ds.setDriverClassName(dci.getDriverClass());
ds.setUsername(dci.getUserName());
ds.setPassword(dci.getPassword());
ds.setUrl(dci.getUrl());
// ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
// ds.setAccessToUnderlyingConnectionAllowed(true);
GSNContext.getMainContext().bind(Integer.toString(dci.hashCode()), ds);
logger.warn("Created a DataSource to: " + ds.getUrl());
}
} catch (NamingException e) {
logger.error(e.getMessage(), e);
}
return ds;
}
