Java ColumnType.BLOB属性代码示例

@Override
public String rewriteColumnType(ColumnType columnType, Integer columnSize) {
    if (columnType == ColumnType.BLOB) {
        return "bytea";
    }
    if (columnType == ColumnType.BIT) {
        return "BOOLEAN";
    }
    if (columnType == ColumnType.DOUBLE) {
        return "double precision";
    }
    if (columnType == ColumnType.MAP) {
        return "jsonb";
    }
    return super.rewriteColumnType(columnType, columnSize);
}
 

@SuppressWarnings("unchecked")
@Override
public Class<? extends Object> getDataType() {
    final ColumnType type = _column.getType();
    if (type == null) {
        return null;
    } else if (type == ColumnType.CLOB) {
        return String.class;
    } else if (type == ColumnType.BLOB) {
        return byte[].class;
    }
    return (Class<Object>) type.getJavaEquivalentClass();
}
 

@SuppressWarnings("unchecked")
@Override
public Class<? extends Object> getDataType() {
    ColumnType type = _column.getType();
    if (type == null) {
        return null;
    } else if (type == ColumnType.CLOB) {
        return String.class;
    } else if (type == ColumnType.BLOB) {
        return byte[].class;
    }
    return (Class<Object>) type.getJavaEquivalentClass();
}
 

@Override
public String rewriteColumnType(ColumnType columnType, Integer columnSize) {
    if (columnType == ColumnType.BIT) {
        return "BOOLEAN";
    }
    if (columnType == ColumnType.BLOB) {
        return "LONGVARBINARY";
    }
    return super.rewriteColumnType(columnType, columnSize);
}
 

private void loadColumns(JdbcTable table, DatabaseMetaData metaData) {
    final boolean convertLobs = isLobConversionEnabled();
    final Schema schema = table.getSchema();

    try (ResultSet rs = metaData.getColumns(getCatalogName(schema), getJdbcSchemaName(schema), table.getName(),
            null)) {
        if (logger.isDebugEnabled()) {
            logger.debug("Querying for columns in table: " + table.getName());
        }
        int columnNumber = -1;

        while (rs.next()) {
            columnNumber++;
            final String columnName = rs.getString(4);
            if (_identifierQuoteString == null && new StringTokenizer(columnName).countTokens() > 1) {
                logger.warn("column name contains whitespace: \"" + columnName + "\".");
            }

            final int jdbcType = rs.getInt(5);
            final String nativeType = rs.getString(6);
            final Integer columnSize = rs.getInt(7);

            if (logger.isDebugEnabled()) {
                logger.debug("Found column: table=" + table.getName() + ",columnName=" + columnName + ",nativeType="
                        + nativeType + ",columnSize=" + columnSize);
            }

            ColumnType columnType = _dataContext.getQueryRewriter().getColumnType(jdbcType, nativeType, columnSize);
            if (convertLobs) {
                if (columnType == ColumnType.CLOB || columnType == ColumnType.NCLOB) {
                    columnType = JdbcDataContext.COLUMN_TYPE_CLOB_AS_STRING;
                } else if (columnType == ColumnType.BLOB) {
                    columnType = JdbcDataContext.COLUMN_TYPE_BLOB_AS_BYTES;
                }
            }

            final int jdbcNullable = rs.getInt(11);
            final Boolean nullable;
            if (jdbcNullable == DatabaseMetaData.columnNullable) {
                nullable = true;
            } else if (jdbcNullable == DatabaseMetaData.columnNoNulls) {
                nullable = false;
            } else {
                nullable = null;
            }

            final String remarks = rs.getString(12);

            final JdbcColumn column = new JdbcColumn(columnName, columnType, table, columnNumber, nullable);
            column.setRemarks(remarks);
            column.setNativeType(nativeType);
            column.setColumnSize(columnSize);
            column.setQuote(_identifierQuoteString);
            table.addColumn(column);
        }

        final int columnsReturned = columnNumber + 1;
        if (columnsReturned == 0) {
            logger.info("No column metadata records returned for table '{}' in schema '{}'", table.getName(), schema
                    .getName());
        } else {
            logger.debug("Returned {} column metadata records for table '{}' in schema '{}'", columnsReturned, table
                    .getName(), schema.getName());
        }
    } catch (SQLException e) {
        throw JdbcUtils.wrapException(e, "retrieve table metadata for " + table.getName(), JdbcActionType.METADATA);
    }
}
 

private static ColumnType getColumnTypeFromMetaDataField(DataType.Name metaDataName) {
    switch (metaDataName) {
    case BIGINT:
    case COUNTER:
        return ColumnType.BIGINT;
    case BLOB:
        return ColumnType.BLOB;
    case BOOLEAN:
        return ColumnType.BOOLEAN;
    case DECIMAL:
        return ColumnType.DECIMAL;
    case DOUBLE:
        return ColumnType.DOUBLE;
    case FLOAT:
        return ColumnType.FLOAT;
    case INT:
        return ColumnType.INTEGER;
    case TEXT:
        return ColumnType.STRING;
    case TIMESTAMP:
        return ColumnType.TIMESTAMP;
    case UUID:
        return ColumnType.UUID;
    case VARCHAR:
        return ColumnType.VARCHAR;
    case VARINT:
        return ColumnType.BIGINT;
    case LIST:
        return ColumnType.LIST;
    case MAP:
        return ColumnType.MAP;
    case CUSTOM:
        return ColumnType.OTHER;
    case INET:
        return ColumnType.INET;
    case SET:
        return ColumnType.SET;
    default:
        return ColumnType.STRING;
    }
}