}
resultSet = statement.executeQuery();
while (resultSet.next())
{
AssertionStatusItem item = new AssertionStatusItem();
item.setFromKey(resultSet.getString(1)); //("FROM_KEY"));
item.setToKey(resultSet.getString(2)); //("TO_KEY"));
// construct and set the KeyedReference instance
KeyedReference keyedRef = new KeyedReference();
keyedRef.setTModelKey(resultSet.getString(3)); //("TMODEL_KEY"));
keyedRef.setKeyName(resultSet.getString(4)); //("KEY_NAME"));
keyedRef.setKeyValue(resultSet.getString(5)); //("KEY_VALUE"));
item.setKeyedReference(keyedRef);
// construct and set the KeysOwned instance
KeysOwned keysOwned = new KeysOwned();
keysOwned.setFromKey(item.getFromKey());
keysOwned.setToKey(null);
item.setKeysOwned(keysOwned);
// determine and set the assertions 'completionStatus'
CompletionStatus status = null;
boolean fromCheck =
new Boolean(resultSet.getString(6)).booleanValue();//("FROM_CHECK")
boolean toCheck =
new Boolean(resultSet.getString(7)).booleanValue();//("TO_CHECK")
if ((fromCheck) && (toCheck))
status = new CompletionStatus(CompletionStatus.COMPLETE);
else if ((fromCheck) && (!toCheck))
status = new CompletionStatus(CompletionStatus.TOKEY_INCOMPLETE);
else if ((!fromCheck) && (toCheck))
status = new CompletionStatus(CompletionStatus.FROMKEY_INCOMPLETE);
item.setCompletionStatus(status);
// add the assertionStatusItem
itemList.addElement(item);
}