/** * 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; }
/** * 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; }
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType().getName();
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
+ columnDataType.getJavaSqlType().getName();
mappedClass = typeMap.get(javaSqlType.getName());
mappedClass = typeMap.get(javaSqlType.getName());
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType().getName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, new StringFormat("Error outputting routine column: %s", e.getMessage()), e); } return jsonColumn; }
.getDatabaseSpecificTypeName()); out.println(" type: " + column.getColumnDataType().getJavaSqlType().getName());
out .println(" type: " + column.getColumnDataType().getJavaSqlType().getName());
/** * 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; }
/** * 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; }
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType().getName();
column.getColumnDataType().getJavaSqlType().getName()); jsonColumn .put("databaseSpecificType",
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType().getName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, new StringFormat("Error outputting routine column: %s", e.getMessage()), e); } return jsonColumn; }
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType().getName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, new StringFormat("Error outputting routine column: %s", e.getMessage()), e); } return jsonColumn; }
column.getColumnDataType().getJavaSqlType().getName()); jsonColumn .put("databaseSpecificType",