/** * Lookup java.sql.Types type, and return more detailed information, * including the mapped Java class. * * @param typeName * java.sql.Types type name * @return JavaSqlType type */ public JavaSqlType getFromJavaSqlTypeName(final String typeName) { JavaSqlType sqlDataType = JavaSqlType.UNKNOWN; if (isBlank(typeName)) { return sqlDataType; } for (final JavaSqlType javaSqlType: javaSqlTypeMap.values()) { if (typeName.equals(javaSqlType.getName())) { sqlDataType = javaSqlType; break; } } return sqlDataType; }
public JavaSqlTypes() { // Load default type mappings final TypeMap typeMap = new TypeMap(); javaSqlTypeMap = new HashMap<>(); for (final SQLType sqlType: JDBCType.values()) { final Integer sqlTypeInt = sqlType.getVendorTypeNumber(); final JavaSqlTypeGroup sqlTypeGroup = JavaSqlTypeGroup .valueOf(sqlTypeInt); final Class<?> mappedClass = typeMap.get(sqlType.getName()); final JavaSqlType javaSqlType = new JavaSqlType(sqlType, mappedClass, sqlTypeGroup); javaSqlTypeMap.put(sqlTypeInt, javaSqlType); } }
private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
MutableColumnDataType lookupColumnDataTypeByType(final int type) { final SchemaReference systemSchema = new SchemaReference(); MutableColumnDataType columnDataType = null; for (final MutableColumnDataType currentColumnDataType: columnDataTypes) { if (type == currentColumnDataType.getJavaSqlType().getVendorTypeNumber()) { columnDataType = currentColumnDataType; if (columnDataType.getSchema().equals(systemSchema)) { break; } } } return columnDataType; }
MutableColumnDataType lookupColumnDataTypeByType(final int type) { final SchemaReference systemSchema = new SchemaReference(); MutableColumnDataType columnDataType = null; for (final MutableColumnDataType currentColumnDataType: this) { if (type == currentColumnDataType.getJavaSqlType().getJavaSqlType()) { columnDataType = currentColumnDataType; if (columnDataType.getSchema().equals(systemSchema)) { break; } } } return columnDataType; }
/** * Lookup java.sql.Types type, and return more detailed information, * including the mapped Java class. * * @param typeName * java.sql.Types type name * @return JavaSqlType type */ public JavaSqlType getFromJavaSqlTypeName(final String typeName) { JavaSqlType sqlDataType = JavaSqlType.UNKNOWN; if (Utility.isBlank(typeName)) { return sqlDataType; } for (final JavaSqlType javaSqlType: javaSqlTypeMap.values()) { if (typeName.equals(javaSqlType.getJavaSqlTypeName())) { sqlDataType = javaSqlType; break; } } return sqlDataType; }
MutableColumnDataType lookupColumnDataTypeByType(final int type) { final SchemaReference systemSchema = new SchemaReference(); MutableColumnDataType columnDataType = null; for (final MutableColumnDataType currentColumnDataType: columnDataTypes) { if (type == currentColumnDataType.getJavaSqlType().getVendorTypeNumber()) { columnDataType = currentColumnDataType; if (columnDataType.getSchema().equals(systemSchema)) { break; } } } return columnDataType; }
protected JdbcType getNodeJdbcType(Column column) { switch(column.getColumnDataType().getJavaSqlType().getJavaSqlType()) { case Types.VARCHAR: return JdbcType.VARCHAR; case Types.INTEGER: return JdbcType.INT; case Types.BIGINT: return JdbcType.BIGINT; case Types.CHAR: return JdbcType.CHAR; case Types.DATE: return JdbcType.DATE; case Types.TIMESTAMP: return JdbcType.TIMESTAMP; case Types.DECIMAL: return JdbcType.DECIMAL; case Types.NUMERIC: return JdbcType.DECIMAL; case Types.SMALLINT: return JdbcType.SMALLINT; case Types.BIT: return JdbcType.SMALLINT; case Types.BLOB: return JdbcType.BLOB; case Types.CLOB: return JdbcType.CLOB; case 2147483647: { JdbcType jt = getJdbcTypeForUnknownJavaSqlType(column); if (jt != null) { return jt; } } } throw new IllegalArgumentException("Unsupported column type " + column.getColumnDataType().getJavaSqlType() + " (" + column.getColumnDataType().getJavaSqlType().getJavaSqlType() + ")"); }
/** * Lookup java.sql.Types type, and return more detailed information, * including the mapped Java class. * * @param typeName * java.sql.Types type name * @return JavaSqlType type */ public JavaSqlType getFromJavaSqlTypeName(final String typeName) { JavaSqlType sqlDataType = JavaSqlType.UNKNOWN; if (isBlank(typeName)) { return sqlDataType; } for (final JavaSqlType javaSqlType: javaSqlTypeMap.values()) { if (typeName.equals(javaSqlType.getName())) { sqlDataType = javaSqlType; break; } } return sqlDataType; }
.getJavaSqlType().getVendorTypeNumber(); Object columnData; if (javaSqlType == Types.CLOB)
public JavaSqlTypes() { // Load default type mappings final TypeMap typeMap = new TypeMap(); javaSqlTypeMap = new HashMap<>(); for (final SQLType sqlType: JDBCType.values()) { final Integer sqlTypeInt = sqlType.getVendorTypeNumber(); final JavaSqlTypeGroup sqlTypeGroup = JavaSqlTypeGroup .valueOf(sqlTypeInt); final Class<?> mappedClass = typeMap.get(sqlType.getName()); final JavaSqlType javaSqlType = new JavaSqlType(sqlType, mappedClass, sqlTypeGroup); javaSqlTypeMap.put(sqlTypeInt, javaSqlType); } }
private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
.getJavaSqlType().getJavaSqlType(); Object columnData; if (javaSqlType == Types.CLOB)
if (pkColumnType != null && fkColumnType != null && fkColumnType.getJavaSqlType().getJavaSqlTypeName() == pkColumnType .getJavaSqlType().getJavaSqlTypeName())
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType().getName();
MutableColumnDataType lookupColumnDataTypeByType(final int type) { final SchemaReference systemSchema = new SchemaReference(); MutableColumnDataType columnDataType = null; for (final MutableColumnDataType currentColumnDataType: columnDataTypes) { if (type == currentColumnDataType.getJavaSqlType().getVendorTypeNumber()) { columnDataType = currentColumnDataType; if (columnDataType.getSchema().equals(systemSchema)) { break; } } } return columnDataType; }
private static Map<Integer, JavaSqlType> mapJavaSqlTypes() { final Map<String, Integer> javaSqlTypesMap = createJavaSqlTypesMap(); final Map<Integer, JavaSqlType> javaSqlTypes = new HashMap<>(); for (final Entry<String, Integer> javaSqlTypesEntry: javaSqlTypesMap .entrySet()) { if (javaSqlTypesEntry.getKey() != null && javaSqlTypesEntry.getValue() != null) { final Integer javaSqlTypeInt = javaSqlTypesEntry.getValue(); final String javaSqlTypeName = javaSqlTypesEntry.getKey(); final JavaSqlTypeGroup javaSqlTypeGroup = groupJavaSqlType(javaSqlTypeInt); final JavaSqlType javaSqlType = new JavaSqlType(javaSqlTypeInt, javaSqlTypeName, javaSqlTypeGroup); javaSqlTypes.put(javaSqlTypeInt, javaSqlType); } } return javaSqlTypes; }
private static String getColumnsListAsString(final List<Column> columns, boolean omitLargeObjectColumns) { final StringBuilder buffer = new StringBuilder(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && javaSqlTypeGroup == JavaSqlTypeGroup.large_object)) { if (i > 0) { buffer.append(", "); } buffer.append(column.getName()); } } return buffer.toString(); }
.getJavaSqlTypeName(); final String userDefined = negate(columnDataType.isUserDefined(), "user defined");