Java Code Examples for java.sql.Types#TINYINT

The following examples show how to use java.sql.Types#TINYINT . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: EnumType.java From lams with GNU General Public License v2.0

6 votes

private boolean isNumericType(int jdbcTypeCode) {
	switch ( jdbcTypeCode ) {
		case Types.INTEGER:
		case Types.NUMERIC:
		case Types.SMALLINT:
		case Types.TINYINT:
		case Types.BIGINT:
		case Types.DECIMAL:
		case Types.DOUBLE:
		case Types.FLOAT: {
			return true;
		}
		default:
			return false;
	}
}

Example 2

Source File: TypesTranslator.java From sql-layer with GNU Affero General Public License v3.0

6 votes

/** Does this type represent a signed numeric type? */
public boolean isTypeSigned(TInstance type) {
    TClass tclass = TInstance.tClass(type);
    if (tclass == null)
        return false;
    switch (tclass.jdbcType()) {
    case Types.BIGINT:
    case Types.DECIMAL:
    case Types.DOUBLE:
    case Types.FLOAT:
    case Types.INTEGER:
    case Types.NUMERIC:
    case Types.REAL:
    case Types.SMALLINT:
    case Types.TINYINT:
        return true;
    default:
        return false;
    }
}

Example 3

Source File: DataTypeDescriptor.java From sql-parser with Eclipse Public License 1.0

6 votes

public static boolean isNumericType(int jdbcType) {

        switch (jdbcType) {
        case Types.BIT:
        case Types.BOOLEAN:
        case Types.TINYINT:
        case Types.SMALLINT:
        case Types.INTEGER:
        case Types.BIGINT:
        case Types.REAL:
        case Types.FLOAT:
        case Types.DOUBLE:
        case Types.DECIMAL:
        case Types.NUMERIC:
            return true;
        default:
            return false;
        }
    }

Example 4

Source File: PreparedStatement.java From Komondor with GNU General Public License v3.0

6 votes

public Object getObject(int parameterIndex) throws SQLException {
    checkBounds(parameterIndex, 0);

    if (this.parameterIsNull[parameterIndex - 1]) {
        return null;
    }

    // we can't rely on the default mapping for JDBC's ResultSet.getObject() for numerics, they're not one-to-one with PreparedStatement.setObject

    switch (PreparedStatement.this.parameterTypes[parameterIndex - 1]) {
        case Types.TINYINT:
            return Byte.valueOf(getByte(parameterIndex));
        case Types.SMALLINT:
            return Short.valueOf(getShort(parameterIndex));
        case Types.INTEGER:
            return Integer.valueOf(getInt(parameterIndex));
        case Types.BIGINT:
            return Long.valueOf(getLong(parameterIndex));
        case Types.FLOAT:
            return Float.valueOf(getFloat(parameterIndex));
        case Types.DOUBLE:
            return Double.valueOf(getDouble(parameterIndex));
        default:
            return this.bindingsAsRs.getObject(parameterIndex);
    }
}

Example 5

Source File: GrantRevokeTest.java From spliceengine with GNU Affero General Public License v3.0

5 votes

/**
 * Append a particular SQL datatype value to the given StringBuffer
 * 
 * @param sb the StringBuffer to append the value
 * @param type the java.sql.Types value to append
 */
static void appendColumnValue(StringBuffer sb, int type)
{
    switch(type)
    {
    case Types.BIGINT:
    case Types.DECIMAL:
    case Types.DOUBLE:
    case Types.FLOAT:
    case Types.INTEGER:
    case Types.NUMERIC:
    case Types.REAL:
    case Types.SMALLINT:
    case Types.TINYINT:
        sb.append("0");
        break;

    case Types.CHAR:
    case Types.VARCHAR:
        sb.append("' '");
        break;

    case Types.DATE:
        sb.append("CURRENT_DATE");
        break;

    case Types.TIME:
        sb.append("CURRENT_TIME");
        break;

    case Types.TIMESTAMP:
        sb.append("CURRENT_TIMESTAMP");
        break;

    default:
        sb.append("null");
        break;
    }
}

Example 6

Source File: JdbcPipelineResult.java From Quicksql with MIT License

5 votes

private void fillWithDisplaySize(int[] type, int[] colCounts) {
    for (int i = 0; i < type.length; i++) {
        switch (type[i]) {
            case Types.BOOLEAN:
            case Types.TINYINT:
            case Types.SMALLINT:
                colCounts[i] = 4;
                break;
            case Types.INTEGER:
            case Types.BIGINT:
            case Types.REAL:
            case Types.FLOAT:
            case Types.DOUBLE:
                colCounts[i] = 8;
                break;
            case Types.CHAR:
            case Types.VARCHAR:
                colCounts[i] = 20;
                break;
            case Types.DATE:
            case Types.TIME:
            case Types.TIMESTAMP:
                colCounts[i] = 20;
                break;
            default:
                colCounts[i] = 20;
        }
    }
}

Example 7

Source File: TableEnv.java From marble with Apache License 2.0

5 votes

protected SqlTypeName getSqlTypeNameForJdbcType(int jdbcType) {
  //FIX Calcite jdbc type converting bug
  SqlTypeName typeName = SqlTypeName.getNameForJdbcType(jdbcType);
  if (jdbcType == Types.LONGVARCHAR) {
    typeName = SqlTypeName.VARCHAR;
  }
  if (jdbcType == Types.SMALLINT || jdbcType == Types.TINYINT) {
    //the type of jdbc value is INTEGER when jdbcType is SMALLINT or TINYINT
    typeName = SqlTypeName.INTEGER;
  }
  return typeName;
}

Example 8

Source File: DataTypeUtilities.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Is the data type signed.
 * 
 * @param dtd
 *          data type descriptor
 */
public static boolean isSigned(DataTypeDescriptor dtd) {
  int typeId = dtd.getTypeId().getJDBCTypeId();

  return (typeId == Types.INTEGER || typeId == Types.FLOAT
      || typeId == Types.DECIMAL || typeId == Types.SMALLINT
      || typeId == Types.BIGINT || typeId == Types.TINYINT
      || typeId == Types.NUMERIC || typeId == Types.REAL || typeId == Types.DOUBLE);
}

Example 9

Source File: JsonOutputFormat.java From sqlline with BSD 3-Clause "New" or "Revised" License

5 votes

private void setJsonValue(StringBuilder sb, String value, int columnTypeId) {
  if (value == null) {
    sb.append(value);
    return;
  }
  switch (columnTypeId) {
  case Types.TINYINT:
  case Types.SMALLINT:
  case Types.INTEGER:
  case Types.BIGINT:
  case Types.REAL:
  case Types.FLOAT:
  case Types.DOUBLE:
  case Types.DECIMAL:
  case Types.NUMERIC:
  case Types.NULL:
    sb.append(value);
    return;
  case Types.BOOLEAN:
    // JSON requires true and false, not TRUE and FALSE
    sb.append(value.equalsIgnoreCase("TRUE"));
    return;
  }
  sb.append("\"");
  for (int i = 0; i < value.length(); i++) {
    if (Rows.ESCAPING_MAP.get(value.charAt(i)) != null) {
      sb.append(Rows.ESCAPING_MAP.get(value.charAt(i)));
    } else {
      sb.append(value.charAt(i));
    }
  }
  sb.append("\"");
}

Example 10

Source File: HiveTypes.java From aliyun-maxcompute-data-collectors with Apache License 2.0

5 votes

/**
 * Given JDBC SQL types coming from another database, what is the best
 * mapping to a Hive-specific type?
 */
public static String toHiveType(int sqlType) {

    switch (sqlType) {
        case Types.INTEGER:
        case Types.SMALLINT:
            return "INT";
        case Types.VARCHAR:
        case Types.CHAR:
        case Types.LONGVARCHAR:
        case Types.NVARCHAR:
        case Types.NCHAR:
        case Types.LONGNVARCHAR:
        case Types.DATE:
        case Types.TIME:
        case Types.TIMESTAMP:
        case Types.CLOB:
            return "STRING";
        case Types.NUMERIC:
        case Types.DECIMAL:
        case Types.FLOAT:
        case Types.DOUBLE:
        case Types.REAL:
            return "DOUBLE";
        case Types.BIT:
        case Types.BOOLEAN:
            return "BOOLEAN";
        case Types.TINYINT:
            return "TINYINT";
        case Types.BIGINT:
            return "BIGINT";
        default:
      // TODO(aaron): Support BINARY, VARBINARY, LONGVARBINARY, DISTINCT,
      // BLOB, ARRAY, STRUCT, REF, JAVA_OBJECT.
      return null;
    }
}

Example 11

Source File: ResultSetUtil.java From incubator-tajo with Apache License 2.0

5 votes

public static int tajoTypeToSqlType(TajoDataTypes.DataType type) throws SQLException {
  switch (type.getType()) {
  case BOOLEAN:
    return Types.BOOLEAN;
  case INT1:
    return Types.TINYINT;
  case INT2:
    return Types.SMALLINT;
  case INT4:
    return Types.INTEGER;
  case INT8:
    return Types.BIGINT;
  case FLOAT4:
    return Types.FLOAT;
  case FLOAT8:
    return Types.DOUBLE;
  case DECIMAL:
    return Types.DECIMAL;
  case DATE:
    return Types.TIMESTAMP;
  case VARCHAR:
    return Types.VARCHAR;
  case TEXT:
    return Types.VARCHAR;
  default:
    throw new SQLException("Unrecognized column type: " + type);
  }
}

Example 12

Source File: JdbcTypeUtil.java From canal with Apache License 2.0

5 votes

public static Class<?> jdbcType2javaType(int jdbcType) {
    switch (jdbcType) {
        case Types.BIT:
        case Types.BOOLEAN:
            // return Boolean.class;
        case Types.TINYINT:
            return Byte.TYPE;
        case Types.SMALLINT:
            return Short.class;
        case Types.INTEGER:
            return Integer.class;
        case Types.BIGINT:
            return Long.class;
        case Types.DECIMAL:
        case Types.NUMERIC:
            return BigDecimal.class;
        case Types.REAL:
            return Float.class;
        case Types.FLOAT:
        case Types.DOUBLE:
            return Double.class;
        case Types.CHAR:
        case Types.VARCHAR:
        case Types.LONGVARCHAR:
            return String.class;
        case Types.BINARY:
        case Types.VARBINARY:
        case Types.LONGVARBINARY:
        case Types.BLOB:
            return byte[].class;
        case Types.DATE:
            return Date.class;
        case Types.TIME:
            return Time.class;
        case Types.TIMESTAMP:
            return Timestamp.class;
        default:
            return String.class;
    }
}

Example 13

Source File: DataDrivenDBInputFormat.java From hadoop with Apache License 2.0

5 votes

/**
 * @return the DBSplitter implementation to use to divide the table/query into InputSplits.
 */
protected DBSplitter getSplitter(int sqlDataType) {
  switch (sqlDataType) {
  case Types.NUMERIC:
  case Types.DECIMAL:
    return new BigDecimalSplitter();

  case Types.BIT:
  case Types.BOOLEAN:
    return new BooleanSplitter();

  case Types.INTEGER:
  case Types.TINYINT:
  case Types.SMALLINT:
  case Types.BIGINT:
    return new IntegerSplitter();

  case Types.REAL:
  case Types.FLOAT:
  case Types.DOUBLE:
    return new FloatSplitter();

  case Types.CHAR:
  case Types.VARCHAR:
  case Types.LONGVARCHAR:
    return new TextSplitter();

  case Types.DATE:
  case Types.TIME:
  case Types.TIMESTAMP:
    return new DateSplitter();

  default:
    // TODO: Support BINARY, VARBINARY, LONGVARBINARY, DISTINCT, CLOB, BLOB, ARRAY
    // STRUCT, REF, DATALINK, and JAVA_OBJECT.
    return null;
  }
}

Example 14

Source File: SqlTypeSide.java From CQL with GNU Affero General Public License v3.0

4 votes

public static int getSqlType(String s) {
	switch (s.toLowerCase()) {
	case "varbinary":
		return Types.VARBINARY;
	case "longvarbinary":
		return Types.LONGVARBINARY;
	case "binary":
		return Types.BINARY;
	case "date":
		return Types.DATE;
	case "time":
		return Types.TIME;
	case "timestamp":
		return Types.TIMESTAMP;
	case "bigint":
		return Types.BIGINT;
	case "boolean":
		return Types.BOOLEAN;
	case "char":
		return Types.CHAR;
	case "double":
		return Types.DOUBLE;
	case "doubleprecision":
		return Types.DOUBLE;
	case "numeric":
		return Types.NUMERIC;
	case "decimal":
		return Types.DECIMAL;
	case "real":
		return Types.REAL;
	case "float":
		return Types.FLOAT;
	case "integer":
		return Types.INTEGER;
	case "tinyint":
		return Types.TINYINT;
	case "bit":
		return Types.BIT;
	case "smallint":
		return Types.SMALLINT;
	case "nvarchar":
		return Types.NVARCHAR;
	case "longvarchar":
		return Types.LONGVARCHAR;
	case "text":
		return Types.VARCHAR;
	case "varchar":
		return Types.VARCHAR;
	case "string":
		return Types.VARCHAR;
	case "blob":
		return Types.BLOB;
	case "other":
		return Types.OTHER;
	case "clob":
		return Types.CLOB;
	// case "long": return Types.Lo
	}
	// Types.
	throw new RuntimeException("Unknown sql type: " + s);
}

Example 15

Source File: MemsqlPOJOOutputOperator.java From attic-apex-malhar with Apache License 2.0

4 votes

@Override
@SuppressWarnings("unchecked")
protected void setStatementParameters(PreparedStatement statement, Object tuple) throws SQLException
{
  final int size = columnDataTypes.size();
  for (int i = 0; i < size; i++) {
    final int type = columnDataTypes.get(i);
    switch (type) {
      case (Types.CHAR):
        // TODO: verify that memsql driver handles char as int
        statement.setInt(i + 1, ((GetterChar<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.VARCHAR):
        statement.setString(i + 1, ((Getter<Object, String>)getters.get(i)).get(tuple));
        break;
      case (Types.BOOLEAN):
      case (Types.TINYINT):
        statement.setBoolean(i + 1, ((GetterBoolean<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.SMALLINT):
        statement.setShort(i + 1, ((GetterShort<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.INTEGER):
        statement.setInt(i + 1, ((GetterInt<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.BIGINT):
        statement.setLong(i + 1, ((GetterLong<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.FLOAT):
        statement.setFloat(i + 1, ((GetterFloat<Object>)getters.get(i)).get(tuple));
        break;
      case (Types.DOUBLE):
        statement.setDouble(i + 1, ((GetterDouble<Object>)getters.get(i)).get(tuple));
        break;
      default:
        /*
          Types.DECIMAL
          Types.DATE
          Types.TIME
          Types.ARRAY
          Types.OTHER
         */
        statement.setObject(i + 1, ((Getter<Object, Object>)getters.get(i)).get(tuple));
        break;
    }
  }
}

Example 16

Source File: JdbcPOJOInputOperator.java From attic-apex-malhar with Apache License 2.0

4 votes

@Override
public void activate(Context.OperatorContext context)
{
  for (int i = 0; i < columnDataTypes.size(); i++) {
    final int type = columnDataTypes.get(i);
    JdbcPOJOInputOperator.ActiveFieldInfo activeFieldInfo = columnFieldSetters.get(i);
    switch (type) {
      case (Types.CHAR):
      case (Types.VARCHAR):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetter(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression(),
          String.class);
        break;

      case (Types.BOOLEAN):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterBoolean(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.TINYINT):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterByte(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.SMALLINT):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterShort(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.INTEGER):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterInt(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.BIGINT):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterLong(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.FLOAT):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterFloat(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case (Types.DOUBLE):
        activeFieldInfo.setterOrGetter = PojoUtils.createSetterDouble(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression());
        break;

      case Types.DECIMAL:
        activeFieldInfo.setterOrGetter = PojoUtils.createSetter(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression(),
            BigDecimal.class);
        break;

      case Types.TIMESTAMP:
        activeFieldInfo.setterOrGetter = PojoUtils.createSetter(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression(),Timestamp.class);
        break;

      case Types.TIME:
        activeFieldInfo.setterOrGetter = PojoUtils.createSetter(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression(),Time.class);
        break;

      case Types.DATE:
        activeFieldInfo.setterOrGetter = PojoUtils.createSetter(pojoClass,
            activeFieldInfo.fieldInfo.getPojoFieldExpression(), Date.class);
        break;

      default:
        handleUnknownDataType(type, null, activeFieldInfo);
        break;
    }
  }
}

Example 17

Source File: SQLType.java From netbeans with Apache License 2.0

4 votes

private Class getClassForNumericType(Integer precision, 
        Integer scale, boolean isNullable) {
    int precValue = ((precision == null) ? -1 : precision.intValue());
    int scaleValue = ((scale == null) ? -1 : scale.intValue());

    switch (sqlType) {
        case Types.DECIMAL:
        case Types.NUMERIC:
            // some jdbc drivers put in null or zero for a numeric
            // specified without precision or scale
            // return BigInteger in that case
            if ((precValue <= 0) && (scaleValue <= 0)){
                return BigInteger.class;
            }

            if (scaleValue > 0) {
                return BigDecimal.class;
            }
            if (precValue > 18) {
                return BigInteger.class;
            }
            if (precValue > 9) {
                return (isNullable ? Long.class : Long.TYPE);
            }
            if (precValue > 4) {
                return (isNullable ? Integer.class : Integer.TYPE);
            }
            return (isNullable ? Short.class : Short.TYPE);
        case Types.FLOAT:
        case Types.DOUBLE:
        case Types.REAL:
        case Types.BIGINT:
        case Types.INTEGER:
        case Types.SMALLINT:
        case Types.TINYINT:
        case Types.BIT:
            return typeList[isNullable ? 0 : 1];
        default:
            return null;
    }
}

Example 18

Source File: TinyIntType.java From requery with Apache License 2.0

4 votes

public TinyIntType(Class<Byte> type) {
    super(type, Types.TINYINT);
}

Example 19

Source File: AbstractStringRowIterator.java From Mycat2 with GNU General Public License v3.0

4 votes

@Override
public Object getObject(int columnIndex) {
    int columnType = mycatRowMetaData.getColumnType(columnIndex);
    switch (columnType) {
        case Types.NUMERIC: {

        }
        case Types.DECIMAL: {
            return this.getBigDecimal(columnIndex);
        }
        case Types.BIT: {
            return this.getBoolean(columnIndex);
        }
        case Types.TINYINT: {
            return this.getByte(columnIndex);
        }
        case Types.SMALLINT: {
            return this.getShort(columnIndex);
        }
        case Types.INTEGER: {
            return this.getInt(columnIndex);
        }
        case Types.BIGINT: {
            return this.getLong(columnIndex);
        }
        case Types.REAL: {
            return this.getFloat(columnIndex);
        }
        case Types.FLOAT: {

        }
        case Types.DOUBLE: {
            return this.getDouble(columnIndex);
        }
        case Types.BINARY: {

        }
        case Types.VARBINARY: {

        }
        case Types.LONGVARBINARY: {
            return this.getBytes(columnIndex);
        }
        case Types.DATE: {
            return this.getDate(columnIndex);
        }
        case Types.TIME: {
            return this.getTime(columnIndex);
        }
        case Types.TIMESTAMP: {
            return this.getTimestamp(columnIndex);
        }
        case Types.CHAR: {

        }
        case Types.VARCHAR: {

        }
        case Types.LONGVARCHAR: {
            return this.getString(columnIndex);
        }
        case Types.BLOB: {

        }
        case Types.CLOB: {
            return this.getBytes(columnIndex);
        }
        case Types.NULL: {
            return null;
        }
        default:
            throw new RuntimeException("unsupport!");
    }
}

Example 20

Source File: UpdatableResultSet.java From Komondor with GNU General Public License v3.0

4 votes

private void setParamValue(PreparedStatement ps, int psIdx, ResultSetRow row, int rsIdx, int sqlType) throws SQLException {
    byte[] val = row.getColumnValue(rsIdx);
    if (val == null) {
        ps.setNull(psIdx, Types.NULL);
        return;
    }
    switch (sqlType) {
        case Types.NULL:
            ps.setNull(psIdx, Types.NULL);
            break;
        case Types.TINYINT:
        case Types.SMALLINT:
        case Types.INTEGER:
            ps.setInt(psIdx, row.getInt(rsIdx));
            break;
        case Types.BIGINT:
            ps.setLong(psIdx, row.getLong(rsIdx));
            break;
        case Types.CHAR:
        case Types.VARCHAR:
        case Types.LONGVARCHAR:
        case Types.DECIMAL:
        case Types.NUMERIC:
            ps.setString(psIdx, row.getString(rsIdx, this.charEncoding, this.connection));
            break;
        case Types.DATE:
            ps.setDate(psIdx, row.getDateFast(rsIdx, this.connection, this, this.fastDefaultCal), this.fastDefaultCal);
            break;
        case Types.TIMESTAMP:
            ps.setTimestamp(psIdx, row.getTimestampFast(rsIdx, this.fastDefaultCal, this.connection.getDefaultTimeZone(), false, this.connection, this));
            break;
        case Types.TIME:
            ps.setTime(psIdx, row.getTimeFast(rsIdx, this.fastDefaultCal, this.connection.getDefaultTimeZone(), false, this.connection, this));
            break;
        case Types.FLOAT:
        case Types.DOUBLE:
        case Types.REAL:
        case Types.BOOLEAN:
            ps.setBytesNoEscapeNoQuotes(psIdx, val);
            break;
        /*
         * default, but also explicitly for following types:
         * case Types.BINARY:
         * case Types.BLOB:
         */
        default:
            ps.setBytes(psIdx, val);
            break;
    }

}