try {
results = TestResultSetUtil.compareThrowable(
actualException, sql, expectedResultsFile, false);
} catch (Throwable e) {
QueryTestFailedException t = new QueryTestFailedException(
e.getMessage());
t.initCause(e);
throw t;
}
if (results != null && results.size() > 0) {
return results;
}
return null;
}
// update sql or procedure(with no results) has no results set
if (!resultFromQuery) {
if (SqlUtil.isUpdateSql(sql)) {
if (updateCnt == 0 && expectedResultsFile.length() > 0) {
throw new QueryTestFailedException("Update cnt was zero: " + expectedResultsFile.getName());
}
if (updateCnt > 0 && expectedResultsFile.length() == 0) {
throw new QueryTestFailedException(
"Update cnt was greater than zero, but didnt expected any updates");
}
} else {
if (expectedResultsFile.length() > 0) {
throw new QueryTestFailedException("No results from query, but expected results");
}
}
} else {
try {
if (expectedResultsFile.length() == 0) {
// if the expectedResult file is empty
// and the result doesnt have a first row-meaning its empty
// then this is good
if (!resultSet.first()) {
throw new QueryTestFailedException(
"Expected results is empty, but query produced results");
}
return results;
}
resultSet.beforeFirst();
results = TestResultSetUtil.writeAndCompareResultSet(resultSet, sql,
MAX_COL_WIDTH, false, null, expectedResultsFile, false);
} catch (QueryTestFailedException qe) {
throw qe;
} catch (Throwable e) {
QueryTestFailedException t = new QueryTestFailedException(
e.getMessage());
t.initCause(e);
throw t;
}
if (results != null && results.size() > 0) {