List of usage examples for java.sql Types TINYINT
int TINYINT
To view the source code for java.sql Types TINYINT.
Click Source Link
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT
.
From source file:com.mirth.connect.donkey.model.channel.MetaDataColumnType.java
public static MetaDataColumnType fromSqlType(int sqlType) { switch (sqlType) { case Types.VARCHAR: case Types.NVARCHAR: case Types.LONGVARCHAR: case Types.LONGNVARCHAR: case Types.CLOB: case Types.NCLOB: return STRING; case Types.BIGINT: case Types.INTEGER: case Types.SMALLINT: case Types.TINYINT: case Types.DECIMAL: case Types.DOUBLE: case Types.FLOAT: case Types.NUMERIC: case Types.REAL: return NUMBER; case Types.BOOLEAN: case Types.BIT: case Types.CHAR: return BOOLEAN; case Types.TIMESTAMP: case Types.TIME: case Types.DATE: return TIMESTAMP; }/*from www . j ava2s . c o m*/ return null; }
From source file:org.apache.hadoop.hive.ql.dataImport.HiveTypes.java
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: case Types.OTHER: 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:/*from w w w . j a v a2 s. c om*/ return null; } }
From source file:Main.java
/** * Gets the name of the type to be used with the internal dbms * /*from w w w. j ava2 s.co m*/ * @param type * java.sql.Types constant * * @return String * * @throws RuntimeException * If the Type is not recognized */ public static String getTypeString(int type) { switch (type) { case Types.BIGINT: return "BIGINT"; case Types.BIT: case Types.BOOLEAN: return "BOOLEAN"; case Types.CHAR: case Types.VARCHAR: case Types.LONGVARCHAR: return "VARCHAR"; case Types.DATE: return "DATE"; case Types.DECIMAL: case Types.NUMERIC: case Types.FLOAT: case Types.DOUBLE: case Types.REAL: return "DOUBLE"; case Types.INTEGER: return "INTEGER"; case Types.SMALLINT: return "SHORT"; case Types.TINYINT: return "BYTE"; case Types.BINARY: case Types.VARBINARY: case Types.LONGVARBINARY: return "BINARY"; case Types.TIMESTAMP: return "TIMESTAMP"; case Types.TIME: return "TIME"; default: throw new RuntimeException("Cannot edit the type: " + type); } }
From source file:org.apache.sqoop.hive.HiveTypesORC.java
/** * Given JDBC SQL types coming from another database, what is the best * mapping to a Hive-specific type?//from w w w . ja va 2 s .c om */ 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.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"; case Types.DECIMAL: return "DECIMAL"; default: // TODO(aaron): Support BINARY, VARBINARY, LONGVARBINARY, DISTINCT, // BLOB, ARRAY, STRUCT, REF, JAVA_OBJECT. return null; } }
From source file:org.apache.sqoop.hive.HiveTypes.java
/** * Given JDBC SQL types coming from another database, what is the best * mapping to a Hive-specific type?/*from w w w . j a v a 2 s . c o m*/ */ 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; } }
From source file:com.cloudera.sqoop.hive.HiveTypes.java
/** * Given JDBC SQL types coming from another database, what is the best * mapping to a Hive-specific type?//from w ww.ja va 2s . co m */ public static String toHiveType(int sqlType) { if (sqlType == Types.INTEGER) { return "INT"; } else if (sqlType == Types.VARCHAR) { return "STRING"; } else if (sqlType == Types.CHAR) { return "STRING"; } else if (sqlType == Types.LONGVARCHAR) { return "STRING"; } else if (sqlType == Types.NUMERIC) { // Per suggestion on hive-user, this is converted to DOUBLE for now. return "DOUBLE"; } else if (sqlType == Types.DECIMAL) { // Per suggestion on hive-user, this is converted to DOUBLE for now. return "DOUBLE"; } else if (sqlType == Types.BIT) { return "BOOLEAN"; } else if (sqlType == Types.BOOLEAN) { return "BOOLEAN"; } else if (sqlType == Types.TINYINT) { return "TINYINT"; } else if (sqlType == Types.SMALLINT) { return "INT"; } else if (sqlType == Types.BIGINT) { return "BIGINT"; } else if (sqlType == Types.REAL) { return "DOUBLE"; } else if (sqlType == Types.FLOAT) { return "DOUBLE"; } else if (sqlType == Types.DOUBLE) { return "DOUBLE"; } else if (sqlType == Types.DATE) { // unfortunate type coercion return "STRING"; } else if (sqlType == Types.TIME) { // unfortunate type coercion return "STRING"; } else if (sqlType == Types.TIMESTAMP) { // unfortunate type coercion return "STRING"; } else if (sqlType == Types.CLOB) { return "STRING"; } else { // TODO(aaron): Support BINARY, VARBINARY, LONGVARBINARY, DISTINCT, // BLOB, ARRAY, STRUCT, REF, JAVA_OBJECT. return null; } }
From source file:org.talend.dataquality.record.linkage.ui.composite.table.SortComparator.java
public static ISortComparator getSortComparator(int javaDataType) throws ParseException { switch (javaDataType) { case Types.DATE: case Types.TIME: return new SortComparator() { @Override/* w ww .j av a 2s .c o m*/ public int compareNotNull(Object value1, Object value2) throws ParseException { return java.sql.Date.valueOf(value1.toString()) .compareTo(java.sql.Date.valueOf(value2.toString())); } }; case Types.TIMESTAMP: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return Timestamp.valueOf(value1.toString()).compareTo(Timestamp.valueOf(value2.toString())); } }; case Types.DOUBLE: case Types.REAL: case Types.FLOAT: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return Double.valueOf(value1.toString()).compareTo(Double.valueOf(value2.toString())); } }; case Types.INTEGER: case Types.TINYINT: case Types.SMALLINT: case Types.NUMERIC: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return Integer.valueOf(value1.toString()).compareTo(Integer.valueOf(value2.toString())); } }; case Types.BIGINT: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return Long.valueOf(value1.toString()).compareTo(Long.valueOf(value2.toString())); } }; case Types.DECIMAL: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { if (value1 instanceof BigDecimal) { return ((BigDecimal) value1).compareTo((BigDecimal) value2); } BigDecimal b1 = new BigDecimal(value1.toString()); BigDecimal b2 = new BigDecimal(value2.toString()); return b1.compareTo(b2); } }; case Types.BOOLEAN: case Types.BIT: return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return Boolean.valueOf(value1.toString()).compareTo(Boolean.valueOf(value2.toString())); } }; default:// String return new SortComparator() { @Override public int compareNotNull(Object value1, Object value2) throws ParseException { return value1.toString().compareTo(value2.toString()); } }; } }
From source file:com.nabla.wapp.server.json.SqlColumn.java
public SqlColumn(String label, int type, int length) { this.label = label; this.type = (type == Types.TINYINT) ? (length == 1 ? Types.BOOLEAN : type) : type; if (log.isDebugEnabled()) { String s;/*from w ww. ja va 2 s . c om*/ switch (this.type) { case Types.BIGINT: case Types.INTEGER: case Types.SMALLINT: case Types.TINYINT: s = "INTEGER"; break; case Types.BOOLEAN: case Types.BIT: s = "BOOLEAN"; break; case Types.DATE: s = "DATE"; break; case Types.TIMESTAMP: s = "TIMESTAMP"; break; case Types.DOUBLE: s = "DOUBLE"; break; case Types.FLOAT: s = "FLOAT"; break; case Types.NULL: s = "NULL"; break; default: s = "STRING"; break; } log.debug("column '" + this.label + "' " + s); } }
From source file:com.espertech.esper.util.TestSQLTypeMapUtil.java
public void testMapping() { Map<Integer, Class> testData = new HashMap<Integer, Class>(); testData.put(Types.CHAR, String.class); testData.put(Types.VARCHAR, String.class); testData.put(Types.LONGVARCHAR, String.class); testData.put(Types.NUMERIC, BigDecimal.class); testData.put(Types.DECIMAL, BigDecimal.class); testData.put(Types.BIT, Boolean.class); testData.put(Types.BOOLEAN, Boolean.class); testData.put(Types.TINYINT, Byte.class); testData.put(Types.SMALLINT, Short.class); testData.put(Types.INTEGER, Integer.class); testData.put(Types.BIGINT, Long.class); testData.put(Types.REAL, Float.class); testData.put(Types.FLOAT, Double.class); testData.put(Types.DOUBLE, Double.class); testData.put(Types.BINARY, byte[].class); testData.put(Types.VARBINARY, byte[].class); testData.put(Types.LONGVARBINARY, byte[].class); testData.put(Types.DATE, java.sql.Date.class); testData.put(Types.TIMESTAMP, java.sql.Timestamp.class); testData.put(Types.TIME, java.sql.Time.class); testData.put(Types.CLOB, java.sql.Clob.class); testData.put(Types.BLOB, java.sql.Blob.class); testData.put(Types.ARRAY, java.sql.Array.class); testData.put(Types.STRUCT, java.sql.Struct.class); testData.put(Types.REF, java.sql.Ref.class); testData.put(Types.DATALINK, java.net.URL.class); for (int type : testData.keySet()) { Class result = SQLTypeMapUtil.sqlTypeToClass(type, null); log.debug(".testMapping Mapping " + type + " to " + result.getSimpleName()); assertEquals(testData.get(type), result); }// w w w. ja v a 2s .c o m assertEquals(String.class, SQLTypeMapUtil.sqlTypeToClass(Types.JAVA_OBJECT, "java.lang.String")); assertEquals(String.class, SQLTypeMapUtil.sqlTypeToClass(Types.DISTINCT, "java.lang.String")); }
From source file:RowSetModel.java
public Class getColumnClass(int column) { String cname;/*from w ww . j a va2 s .c o m*/ int type; try { ResultSetMetaData meta = rowSet.getMetaData(); if (meta == null) { return null; } type = meta.getColumnType(column + 1); } catch (SQLException e) { e.printStackTrace(); return super.getColumnClass(column); } switch (type) { case Types.BIT: { cname = "java.lang.Boolean"; break; } case Types.TINYINT: { cname = "java.lang.Byte"; break; } case Types.SMALLINT: { cname = "java.lang.Short"; break; } case Types.INTEGER: { cname = "java.lang.Integer"; break; } case Types.BIGINT: { cname = "java.lang.Long"; break; } case Types.FLOAT: case Types.REAL: { cname = "java.lang.Float"; break; } case Types.DOUBLE: { cname = "java.lang.Double"; break; } case Types.NUMERIC: { cname = "java.lang.Number"; break; } case Types.DECIMAL: { cname = "java.math.BigDecimal"; break; } case Types.CHAR: case Types.VARCHAR: case Types.LONGVARCHAR: { cname = "java.lang.String"; break; } case Types.DATE: { cname = "java.sql.Date"; break; } case Types.TIME: { cname = "java.sql.Time"; break; } case Types.TIMESTAMP: { cname = "java.sql.Timestamp"; break; } case Types.BINARY: case Types.VARBINARY: case Types.LONGVARBINARY: { cname = "byte[]"; break; } case Types.OTHER: case Types.JAVA_OBJECT: { cname = "java.lang.Object"; break; } case Types.CLOB: { cname = "java.sql.Clob"; break; } case Types.BLOB: { cname = "java.ssql.Blob"; break; } case Types.REF: { cname = "java.sql.Ref"; break; } case Types.STRUCT: { cname = "java.sql.Struct"; break; } default: { return super.getColumnClass(column); } } try { return Class.forName(cname); } catch (Exception e) { e.printStackTrace(); return super.getColumnClass(column); } }