@Before public void setup() { value = new ColumnData(COLUMN_NAME, VALUE, DATA_TYPE.getVendorTypeNumber()); }
@Test public void hasCorrectDataType() { assertThat(value.getDataType()).isSameAs(DATA_TYPE.getVendorTypeNumber()); }
/** Returns an JDBC SQL type * @see java.sql.Types */ public int getSqlType() { return sqlType.getVendorTypeNumber(); }
/** Compatibility with a method {@link java.sql.JDBCType#getVendorTypeNumber() } * @deprecated Use the method {@link #getSqlType()} rather. */ @Deprecated public int getVendorTypeNumber() { return sqlType.getVendorTypeNumber(); }
public static void setDoubleParameter (PreparedStatement statement, int oneBasedIndex, double value) throws SQLException { if (value == DOUBLE_MISSING) statement.setNull(oneBasedIndex, JDBCType.DOUBLE.getVendorTypeNumber()); else statement.setDouble(oneBasedIndex, value); }
public static void setIntParameter (PreparedStatement statement, int oneBasedIndex, int value) throws SQLException { if (value == INT_MISSING) statement.setNull(oneBasedIndex, JDBCType.INTEGER.getVendorTypeNumber()); else statement.setInt(oneBasedIndex, value); }
private static JDBCType getJDBCType(int val) { if (TYPE_NUMBER_MAP.isEmpty()) { synchronized(TYPE_NUMBER_MAP) { if (TYPE_NUMBER_MAP.isEmpty()) { for(java.sql.JDBCType jdbcType:java.sql.JDBCType.values()) { TYPE_NUMBER_MAP.put(jdbcType.getVendorTypeNumber(), jdbcType); } } } } return TYPE_NUMBER_MAP.get(val); }
@SuppressWarnings("unchecked") @Override public void setObject(PreparedStatement stmt, int parameterIndex , Object x) throws SQLException{ if (x==null){ stmt.setNull(parameterIndex, jdbcType.getVendorTypeNumber()); return; } String val=this.statementConverter.convertString(x); stmt.setObject(parameterIndex, val, jdbcType); } }
private static void setQueryParams(PreparedStatement statement, QueryParam[] params) throws SQLException { for (int i = 0; i < params.length; ++i) { QueryParam param = params[i]; statement.setObject(toSqlIndex(i), param.value, param.type.getVendorTypeNumber()); } }
public static String sqlTypeToHiveType(JDBCType jdbcType) { if (jdbcType != null) { Integer type = jdbcType.getVendorTypeNumber(); return sqlTypeToHiveType(type); } return null; }
private static void setQueryParams(PreparedStatement statement, QueryParam[] params) throws SQLException { for (int i = 0; i < params.length; ++i) { QueryParam param = params[i]; statement.setObject(toSqlIndex(i), param.value, param.type.getVendorTypeNumber()); } }
static int getJDBCTypeCode(Type type) { return getJDBCType(type).getVendorTypeNumber(); }
/** * PreparedStatementへの値の設定 * * @param stmt * @param parameterIndex * @param x * @throws SQLException */ @Override public void setObject(PreparedStatement stmt, int parameterIndex, Object x) throws SQLException { if (x == null) { stmt.setNull(parameterIndex, jdbcType.getVendorTypeNumber()); } else { stmt.setObject(parameterIndex, statementConverter.convertObject(x, stmt.getConnection()), jdbcType); } }
/** * {@link java.sql.Types} の値を {@link java.sql.SQLType} に変換する * @param sqlType {@link java.sql.Types} の値 * @return {@link java.sql.SQLType} の値 */ private SQLType toSqlType(final int sqlType) { for (JDBCType type : JDBCType.values()) { if (type.getVendorTypeNumber().intValue() == sqlType) { return type; } } //下位互換のため、念のため生成して返す return new SQLType() { @Override public Integer getVendorTypeNumber() { return sqlType; } @Override public String getVendor() { return "unknown"; } @Override public String getName() { return "unknown name:" + sqlType; } }; }
@Override public void setObject(PreparedStatement stmt, int parameterIndex, Object x) throws SQLException { if (x == null) { stmt.setNull(parameterIndex, java.sql.JDBCType.TIMESTAMP.getVendorTypeNumber()); return; } java.util.Date val = cast(this.statementConverter.convertObject(x)); stmt.setObject(parameterIndex, truncateMilisecond(val), java.sql.JDBCType.TIMESTAMP); } }
public static void bindValue(PreparedStatement statement, JDBCType type, Object value, int index) throws SQLException { if (value == null) { statement.setNull(index, type.getVendorTypeNumber()); return; } switch (type) { case BOOLEAN: statement.setBoolean(index, (boolean) value); return; case INTEGER: statement.setInt(index, ((Number) value).intValue()); return; case BIGINT: statement.setLong(index, ((Number) value).longValue()); return; case DOUBLE: statement.setDouble(index, ((Number) value).doubleValue()); return; case VARBINARY: statement.setBytes(index, truncateIndexValue((Slice) value).getBytes()); return; } throw new PrestoException(GENERIC_INTERNAL_ERROR, "Unhandled type: " + type); } }
public static void bindValue(PreparedStatement statement, JDBCType type, Object value, int index) throws SQLException { if (value == null) { statement.setNull(index, type.getVendorTypeNumber()); return; } switch (type) { case BOOLEAN: statement.setBoolean(index, (boolean) value); return; case INTEGER: statement.setInt(index, ((Number) value).intValue()); return; case BIGINT: statement.setLong(index, ((Number) value).longValue()); return; case DOUBLE: statement.setDouble(index, ((Number) value).doubleValue()); return; case VARBINARY: statement.setBytes(index, truncateIndexValue((Slice) value).getBytes()); return; } throw new PrestoException(GENERIC_INTERNAL_ERROR, "Unhandled type: " + type); } }
int type = types.get(column.getColumnId()).getVendorTypeNumber(); statement.setNull(index, type); statement.setNull(index + 1, type);
when(result.getString("COLUMN_NAME")).thenReturn("A"); when(result.getInt("COLUMN_TYPE")).thenReturn(ColumnMode.IN.ordinal()); when(result.getInt("DATA_TYPE")).thenReturn(JDBCType.INTEGER.getVendorTypeNumber());
when(result.getString("COLUMN_NAME")).thenReturn("A"); when(result.getInt("COLUMN_TYPE")).thenReturn(ColumnMode.IN.ordinal()); when(result.getInt("DATA_TYPE")).thenReturn(JDBCType.INTEGER.getVendorTypeNumber());