@Override
public ArrayList<ArrayList<String>> getSQLQueryDataForLimitedRows(DBType dbType,
String hostname, int portnumber, String username, String password,
String query, String dBorSIDName, int rowCount) throws SQLException, ClassNotFoundException {
String connectString = getConnectString(hostname, portnumber, username, password, dBorSIDName);
Connection conn = getConnection(DRIVER, connectString);
if(query.toUpperCase().indexOf("SELECT TOP") == -1) {
int idx = query.toUpperCase().indexOf("SELECT");
query = query.substring(idx+6);
query = "SELECT TOP " + rowCount + query;
}
logger.info("Execute:" + query);
Statement s = conn.createStatement();
ResultSet r = s.executeQuery(query);
if (r == null) {
s.close();
return null;
}
ArrayList<ArrayList<String>> vals = parseResultSetIntoArrayListOfRows(r);
r.close();
s.close();
return vals;
}