List of usage examples for java.sql Types FLOAT
int FLOAT
To view the source code for java.sql Types FLOAT.
Click Source Link
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
From source file:net.riezebos.thoth.configuration.persistence.dbs.DDLExecuter.java
private void initDialect(DatabaseIdiom idiom) { databaseIdiom = idiom;/*w w w . java2 s. c o m*/ try { addTranslation("bigint", idiom.getTypeName(Types.BIGINT)); addTranslation("binary", idiom.getTypeName(Types.BINARY)); addTranslation("bit", idiom.getTypeName(Types.BIT)); addTranslation("blob", idiom.getTypeName(Types.BLOB)); addTranslation("boolean", idiom.getTypeName(Types.BOOLEAN)); addTranslation("char", idiom.getTypeName(Types.CHAR)); addTranslation("clob", idiom.getTypeName(Types.CLOB)); addTranslation("date", idiom.getTypeName(Types.DATE)); addTranslation("decimal", idiom.getTypeName(Types.DECIMAL)); addTranslation("double", idiom.getTypeName(Types.DOUBLE)); addTranslation("float", idiom.getTypeName(Types.FLOAT)); addTranslation("integer", idiom.getTypeName(Types.INTEGER)); addTranslation("longnvarchar", idiom.getTypeName(Types.LONGNVARCHAR)); addTranslation("longvarbinary", idiom.getTypeName(Types.LONGVARBINARY)); addTranslation("longvarchar", idiom.getTypeName(Types.LONGVARCHAR)); addTranslation("nchar", idiom.getTypeName(Types.NCHAR)); addTranslation("nclob", idiom.getTypeName(Types.NCLOB)); addTranslation("numeric", idiom.getTypeName(Types.NUMERIC)); addTranslation("nvarchar", idiom.getTypeName(Types.NVARCHAR)); addTranslation("real", idiom.getTypeName(Types.REAL)); addTranslation("smallint", idiom.getTypeName(Types.SMALLINT)); addTranslation("time", idiom.getTypeName(Types.TIME)); addTranslation("timestamp", idiom.getTypeName(Types.TIMESTAMP)); addTranslation("tinyint", idiom.getTypeName(Types.TINYINT)); addTranslation("varbinary", idiom.getTypeName(Types.VARBINARY)); databaseIdiom.initDialect(translations, workarounds); // Ignore autogenerated ID's addWorkaround("generated always as identity", ""); } catch (Exception e) { throw new IllegalArgumentException(e); } }
From source file:org.apache.cassandra.cql3.subquery.SubQueryProcessor.java
public String execute(String queryString, ConsistencyLevel cLevel, ThriftClientState cState) throws UnavailableException, TimedOutException, InvalidRequestException { List<TypedColumn> values = new ArrayList<TypedColumn>(); String valueString = ""; try {//from w w w .ja v a 2 s . c o m // Execute query CqlResult cr = cState.getCQLQueryHandler() .process(queryString, cState.getQueryState(), QueryOptions.fromProtocolV2( ThriftConversion.fromThrift(cLevel), Collections.<ByteBuffer>emptyList())) .toThriftResult(); Iterator<CqlRow> rowsIterator = cr.getRowsIterator(); populateColumns(rowsIterator, values, cr.schema, queryString); AbstractJdbcType absJdbcType; int typeNo; for (TypedColumn tc : values) { absJdbcType = tc.getValueType(); typeNo = absJdbcType.getJdbcType(); if (typeNo == Types.INTEGER || typeNo == Types.BIGINT || typeNo == Types.DECIMAL || typeNo == Types.FLOAT || typeNo == Types.NUMERIC || typeNo == Types.DOUBLE) { valueString = valueString + tc.getValueString() + ","; } else { /** * Values apart from Integer,Decimal,Float are need to be wrapped with single quotes(' ')[This is * from the assumption that, the column type of parent query is same as reference column selected by * child query] **/ valueString = valueString + "'" + tc.getValueString() + "',"; } } if (valueString.contains(",")) { valueString = valueString.substring(0, valueString.lastIndexOf(',')); } else { // Return error with query string if no value returned throw new InvalidRequestException("SubQuery is not returning any values" + " for the query [" + queryString.toUpperCase() + "] "); } } catch (RequestExecutionException e) { ThriftConversion.rethrow(e); return null; } catch (RequestValidationException e) { // Return error with query string throw new InvalidRequestException( e.getMessage() + " for the query [" + queryString.toUpperCase() + "] "); } catch (CharacterCodingException e) { throw new InvalidRequestException( e.getMessage() + " for the query [" + queryString.toUpperCase() + "] "); } return valueString; }
From source file:org.dashbuilder.dataprovider.sql.JDBCUtils.java
public static ColumnType calculateType(int sqlDataType) { switch (sqlDataType) { // Category-like columns. case Types.CHAR: case Types.VARCHAR: case Types.NCHAR: case Types.NVARCHAR: case Types.BIT: case Types.BOOLEAN: { return ColumnType.LABEL; }//from w ww.j ava 2s .c o m // Text-like columns. case Types.LONGVARCHAR: case Types.LONGNVARCHAR: { return ColumnType.TEXT; } // Number-like columns. case Types.TINYINT: case Types.BIGINT: case Types.INTEGER: case Types.DECIMAL: case Types.DOUBLE: case Types.FLOAT: case Types.NUMERIC: case Types.REAL: case Types.SMALLINT: { return ColumnType.NUMBER; } // Date-like columns. case Types.DATE: case Types.TIME: case Types.TIMESTAMP: { return ColumnType.DATE; } // Unsupported default: { return null; } } }
From source file:CreateNewType.java
private static Vector getDataTypes(Connection con, String typeToCreate) throws SQLException { String structName = null, distinctName = null, javaName = null; // create a vector of class DataType initialized with // the SQL code, the SQL type name, and two null entries // for the local type name and the creation parameter(s) Vector dataTypes = new Vector(); dataTypes.add(new DataType(java.sql.Types.BIT, "BIT")); dataTypes.add(new DataType(java.sql.Types.TINYINT, "TINYINT")); dataTypes.add(new DataType(java.sql.Types.SMALLINT, "SMALLINT")); dataTypes.add(new DataType(java.sql.Types.INTEGER, "INTEGER")); dataTypes.add(new DataType(java.sql.Types.BIGINT, "BIGINT")); dataTypes.add(new DataType(java.sql.Types.FLOAT, "FLOAT")); dataTypes.add(new DataType(java.sql.Types.REAL, "REAL")); dataTypes.add(new DataType(java.sql.Types.DOUBLE, "DOUBLE")); dataTypes.add(new DataType(java.sql.Types.NUMERIC, "NUMERIC")); dataTypes.add(new DataType(java.sql.Types.DECIMAL, "DECIMAL")); dataTypes.add(new DataType(java.sql.Types.CHAR, "CHAR")); dataTypes.add(new DataType(java.sql.Types.VARCHAR, "VARCHAR")); dataTypes.add(new DataType(java.sql.Types.LONGVARCHAR, "LONGVARCHAR")); dataTypes.add(new DataType(java.sql.Types.DATE, "DATE")); dataTypes.add(new DataType(java.sql.Types.TIME, "TIME")); dataTypes.add(new DataType(java.sql.Types.TIMESTAMP, "TIMESTAMP")); dataTypes.add(new DataType(java.sql.Types.BINARY, "BINARY")); dataTypes.add(new DataType(java.sql.Types.VARBINARY, "VARBINARY")); dataTypes.add(new DataType(java.sql.Types.LONGVARBINARY, "LONGVARBINARY")); dataTypes.add(new DataType(java.sql.Types.NULL, "NULL")); dataTypes.add(new DataType(java.sql.Types.OTHER, "OTHER")); dataTypes.add(new DataType(java.sql.Types.BLOB, "BLOB")); dataTypes.add(new DataType(java.sql.Types.CLOB, "CLOB")); DatabaseMetaData dbmd = con.getMetaData(); ResultSet rs = dbmd.getTypeInfo(); while (rs.next()) { int codeNumber = rs.getInt("DATA_TYPE"); String dbmsName = rs.getString("TYPE_NAME"); String createParams = rs.getString("CREATE_PARAMS"); if (codeNumber == Types.STRUCT && structName == null) structName = dbmsName;// ww w . j av a 2 s .c om else if (codeNumber == Types.DISTINCT && distinctName == null) distinctName = dbmsName; else if (codeNumber == Types.JAVA_OBJECT && javaName == null) javaName = dbmsName; else { for (int i = 0; i < dataTypes.size(); i++) { // find entry that matches the SQL code, // and if local type and params are not already set, // set them DataType type = (DataType) dataTypes.get(i); if (type.getCode() == codeNumber) { type.setLocalTypeAndParams(dbmsName, createParams); } } } } if (typeToCreate.equals("s")) { int[] types = { Types.STRUCT, Types.DISTINCT, Types.JAVA_OBJECT }; rs = dbmd.getUDTs(null, "%", "%", types); while (rs.next()) { String typeName = null; DataType dataType = null; if (dbmd.isCatalogAtStart()) typeName = rs.getString(1) + dbmd.getCatalogSeparator() + rs.getString(2) + "." + rs.getString(3); else typeName = rs.getString(2) + "." + rs.getString(3) + dbmd.getCatalogSeparator() + rs.getString(1); switch (rs.getInt(5)) { case Types.STRUCT: dataType = new DataType(Types.STRUCT, typeName); dataType.setLocalTypeAndParams(structName, null); break; case Types.DISTINCT: dataType = new DataType(Types.DISTINCT, typeName); dataType.setLocalTypeAndParams(distinctName, null); break; case Types.JAVA_OBJECT: dataType = new DataType(Types.JAVA_OBJECT, typeName); dataType.setLocalTypeAndParams(javaName, null); break; } dataTypes.add(dataType); } } return dataTypes; }
From source file:org.cloudgraph.rdb.service.RDBDataConverter.java
private int convertToSqlType(Property property, Object value) { int result;/*from w w w .ja v a 2 s .c om*/ if (!property.getType().isDataType()) throw new IllegalArgumentException("expected data type property, not " + property.toString()); DataType dataType = DataType.valueOf(property.getType().getName()); switch (dataType) { case String: case URI: case Month: case MonthDay: case Day: case Time: case Year: case YearMonth: case YearMonthDay: case Duration: case Strings: result = java.sql.Types.VARCHAR; break; case Date: // Plasma SDO allows more precision than just month/day/year // in an SDO date datatype, and using java.sql.Date will // truncate // here so use java.sql.Timestamp. result = java.sql.Types.TIMESTAMP; break; case DateTime: result = java.sql.Types.TIMESTAMP; // FIXME: so what SDO datatype maps to a SQL timestamp?? break; case Decimal: result = java.sql.Types.DECIMAL; break; case Bytes: // FIXME: how do we know whether a Blob here result = java.sql.Types.VARBINARY; break; case Byte: result = java.sql.Types.VARBINARY; break; case Boolean: result = java.sql.Types.BOOLEAN; break; case Character: result = java.sql.Types.CHAR; break; case Double: result = java.sql.Types.DOUBLE; break; case Float: result = java.sql.Types.FLOAT; break; case Int: result = java.sql.Types.INTEGER; break; case Integer: result = java.sql.Types.BIGINT; break; case Long: result = java.sql.Types.INTEGER; // FIXME: no JDBC long?? break; case Short: result = java.sql.Types.SMALLINT; break; case Object: default: result = java.sql.Types.VARCHAR; break; } return result; }
From source file:org.jasig.ssp.util.importer.job.validation.map.metadata.database.MapColumnMetadata.java
public Object convertValueToType(String columnValue, MapReference mapReference, DatabaseConstraintMapValidationContext validation) { Object propertyValue = null;// w ww .j a v a 2 s.c o m String typeAsString = ""; if (columnValue != null) { try { switch (javaSqlType) { case Types.BIGINT: typeAsString = "BIGINT"; propertyValue = Long.parseLong(columnValue); break; case Types.INTEGER: typeAsString = "INTEGER"; propertyValue = Integer.parseInt(columnValue); break; case Types.DECIMAL: typeAsString = "DECIMAL"; case Types.DOUBLE: typeAsString = "DOUBLE"; case Types.FLOAT: typeAsString = "FLOAT"; case Types.NUMERIC: typeAsString = "NUMERIC"; propertyValue = new BigDecimal(columnValue); break; case Types.DATE: typeAsString = "DATE"; propertyValue = DateUtils.parseDateStrictly(columnValue, DATE_PATTERNS); break; case Types.TIMESTAMP: typeAsString = "TIMESTAMP"; propertyValue = new java.sql.Timestamp(Long.getLong(columnValue)); break; case Types.TIME: typeAsString = "TIME"; propertyValue = new Time(DateUtils.parseDateStrictly(columnValue, TIME_PATTERNS).getTime()); break; default: typeAsString = javaSqlType.toString(); propertyValue = columnValue; break; } } catch (Exception exception) { validation.addViolation(new UnableToParseMapViolation(mapReference, columnValue, typeAsString)); propertyValue = columnValue; } } return propertyValue; }
From source file:net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt.java
/** * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#getMaxPrecision(int) *//* w w w. j a v a 2s . c om*/ public int getMaxPrecision(int dataType) { if (dataType == Types.DOUBLE || dataType == Types.FLOAT) { return 53; } else { return 31; } }
From source file:org.executequery.gui.resultset.ResultSetTableModel.java
public void createTable(ResultSet resultSet) { if (!isOpenAndValid(resultSet)) { clearData();/*w w w . j av a 2 s .com*/ return; } try { resetMetaData(); ResultSetMetaData rsmd = resultSet.getMetaData(); columnHeaders.clear(); visibleColumnHeaders.clear(); tableData.clear(); int zeroBaseIndex = 0; int count = rsmd.getColumnCount(); for (int i = 1; i <= count; i++) { zeroBaseIndex = i - 1; columnHeaders.add(new ResultSetColumnHeader(zeroBaseIndex, rsmd.getColumnLabel(i), rsmd.getColumnName(i), rsmd.getColumnType(i), rsmd.getColumnTypeName(i))); } int recordCount = 0; interrupted = false; if (holdMetaData) { setMetaDataVectors(rsmd); } List<RecordDataItem> rowData; long time = System.currentTimeMillis(); while (resultSet.next()) { if (interrupted || Thread.interrupted()) { throw new InterruptedException(); } recordCount++; rowData = new ArrayList<RecordDataItem>(count); for (int i = 1; i <= count; i++) { zeroBaseIndex = i - 1; ResultSetColumnHeader header = columnHeaders.get(zeroBaseIndex); RecordDataItem value = recordDataItemFactory.create(header); try { int dataType = header.getDataType(); switch (dataType) { // some drivers (informix for example) // was noticed to return the hashcode from // getObject for -1 data types (eg. longvarchar). // force string for these - others stick with // getObject() for default value formatting case Types.CHAR: case Types.VARCHAR: value.setValue(resultSet.getString(i)); break; case Types.DATE: value.setValue(resultSet.getDate(i)); break; case Types.TIME: value.setValue(resultSet.getTime(i)); break; case Types.TIMESTAMP: value.setValue(resultSet.getTimestamp(i)); break; case Types.LONGVARCHAR: case Types.CLOB: value.setValue(resultSet.getClob(i)); break; case Types.LONGVARBINARY: case Types.VARBINARY: case Types.BINARY: value.setValue(resultSet.getBytes(i)); break; case Types.BLOB: value.setValue(resultSet.getBlob(i)); break; case Types.BIT: case Types.TINYINT: case Types.SMALLINT: case Types.INTEGER: case Types.BIGINT: case Types.FLOAT: case Types.REAL: case Types.DOUBLE: case Types.NUMERIC: case Types.DECIMAL: case Types.NULL: case Types.OTHER: case Types.JAVA_OBJECT: case Types.DISTINCT: case Types.STRUCT: case Types.ARRAY: case Types.REF: case Types.DATALINK: case Types.BOOLEAN: case Types.ROWID: case Types.NCHAR: case Types.NVARCHAR: case Types.LONGNVARCHAR: case Types.NCLOB: case Types.SQLXML: // use getObject for all other known types value.setValue(resultSet.getObject(i)); break; default: // otherwise try as string asStringOrObject(value, resultSet, i); break; } } catch (Exception e) { try { // ... and on dump, resort to string value.setValue(resultSet.getString(i)); } catch (SQLException sqlException) { // catch-all SQLException - yes, this is hideous // noticed with invalid date formatted values in mysql value.setValue("<Error - " + sqlException.getMessage() + ">"); } } if (resultSet.wasNull()) { value.setNull(); } rowData.add(value); } tableData.add(rowData); if (recordCount == maxRecords) { break; } } if (Log.isTraceEnabled()) { Log.trace("Finished populating table model - " + recordCount + " rows - [ " + MiscUtils.formatDuration(System.currentTimeMillis() - time) + "]"); } fireTableStructureChanged(); } catch (SQLException e) { System.err.println("SQL error populating table model at: " + e.getMessage()); Log.debug("Table model error - " + e.getMessage(), e); } catch (Exception e) { if (e instanceof InterruptedException) { Log.debug("ResultSet generation interrupted.", e); } else { String message = e.getMessage(); if (StringUtils.isBlank(message)) { System.err.println("Exception populating table model."); } else { System.err.println("Exception populating table model at: " + message); } Log.debug("Table model error - ", e); } } finally { if (resultSet != null) { try { resultSet.close(); Statement statement = resultSet.getStatement(); if (statement != null) { statement.close(); } } catch (SQLException e) { } } } }
From source file:org.apache.ddlutils.platform.interbase.InterbaseModelReader.java
/** * Adjusts the columns in the table by fixing types and default values. * //from w w w .j a va2s.c o m * @param table The table */ protected void adjustColumns(Table table) { Column[] columns = table.getColumns(); for (int idx = 0; idx < columns.length; idx++) { if (columns[idx].getTypeCode() == Types.FLOAT) { columns[idx].setTypeCode(Types.REAL); } else if ((columns[idx].getTypeCode() == Types.NUMERIC) || (columns[idx].getTypeCode() == Types.DECIMAL)) { if ((columns[idx].getTypeCode() == Types.NUMERIC) && (columns[idx].getSizeAsInt() == 18) && (columns[idx].getScale() == 0)) { columns[idx].setTypeCode(Types.BIGINT); } } else if (TypeMap.isTextType(columns[idx].getTypeCode())) { columns[idx].setDefaultValue(unescape(columns[idx].getDefaultValue(), "'", "''")); } } }
From source file:net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt.java
/** * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#getMaxScale(int) */// ww w . jav a 2 s.co m public int getMaxScale(int dataType) { if (dataType == Types.DOUBLE || dataType == Types.FLOAT) { // double and float have no scale - that is DECIMAL_DIGITS is null. // Assume that is because it's variable - "floating" point. return 0; } else { return getMaxPrecision(dataType); } }