public static DataSource getDS(KPIGenProperties p) throws SQLException, IOException {
if ("DB2".equalsIgnoreCase(p.get("DB"))) {
DB2SimpleDataSource ds = new DB2SimpleDataSource();
ds.setDriverType(4);
ds.setLoginTimeout(5); // sec
ds.setServerName(p.get("ServerName"));
ds.setPortNumber(Integer.parseInt(p.get("PortNumber")));
ds.setDatabaseName(p.get("DatabaseName"));
ds.setUser(p.get("User"));
ds.setPassword(p.get("Password"));
return ds;
} else {
OracleDataSource ds = new OracleDataSource();
ds.setDriverType("thin");
ds.setServerName(p.get("ServerName"));
ds.setPortNumber(Integer.parseInt(p.get("PortNumber")));
ds.setDatabaseName(p.get("DatabaseName"));
ds.setUser(p.get("User"));
ds.setPassword(p.get("Password"));
return ds;
}
}
