SchemaBrowser browser = _tool.getSchemaBrowser();
// get the expected type of the isQueue column
Table table = SchemaHelper.getTable(schema, DESTINATIONS_TABLE);
Attribute column = SchemaHelper.getAttribute(table, ISQUEUE_COLUMN);
Type expected = browser.getType(column);
// get the actual type of the isQueue column
try {
Table currentTable = browser.getTable(DESTINATIONS_TABLE);
Attribute currentColumn =
SchemaHelper.getAttribute(currentTable, ISQUEUE_COLUMN);
Type currentType = browser.getType(currentColumn);
result = (currentType.getType() != expected.getType());
} catch (InvalidTypeException exception) {
// this will only occur if the JDBC driver is buggy (its amazing
// home many are - MM.MySQL 2.0.x and Oracle are 2 examples)
// Try and perform a conversion anyway - and hope for the best...
_log.warn(exception);