How to use

getColumns

method

in

org.apache.ddlutils.platform.DatabaseMetaDataWrapper

private static List<Column> readColumns(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException {
  ResultSet columnData = null;
  try {
    columnData = metaData.getColumns(tableName, null);
    List<Column> columns = new ArrayList<Column>();
    Map<String, Object> values;
    for (; columnData.next(); columns.add(readColumn(metaData, values))) {
      Map<String, Object> tmp = readColumns(columnData, initColumnsForColumn());
      if (tableName.equalsIgnoreCase((String) tmp.get("TABLE_NAME"))) {
        values = tmp;
      } else {
        break;
      }
    }
    return columns;
  } finally {
    JdbcUtils.closeResultSet(columnData);
  }
}

private static List<Column> generateColumns(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException {
  ResultSet columnsResultSet = null;
  try {
    columnsResultSet = metaData.getColumns(tableName, null);
    List<Column> columns = new ArrayList<>();
    Map<String, Object> values;
    for (; columnsResultSet.next(); columns.add(generateOneColumn(metaData, values))) {
      Map<String, Object> tmp = readColumns(columnsResultSet, getDescriptorsForColumn());
      if (tableName.equalsIgnoreCase((String) tmp.get("TABLE_NAME"))) {
        values = tmp;
      } else {
        break;
      }
    }
    return columns;
  } finally {
    JdbcUtils.closeResultSet(columnsResultSet);
  }
}

columnData = metaData.getColumns(tableName, null);

/**
 * Reads the column definitions for the indicated table.
 * 
 * @param metaData  The database meta data
 * @param tableName The name of the table
 * @return The columns
 */
protected Collection readColumns(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
  ResultSet columnData = null;
  try
  {
    columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
    List columns = new ArrayList();
    while (columnData.next())
    {
      Map values = readColumns(columnData, getColumnsForColumn());
      columns.add(readColumn(metaData, values));
    }
    return columns;
  }
  finally
  {
    closeResultSet(columnData);
  }
}

columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());

columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());

columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());

columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
found      = true;

columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());