List of usage examples for org.hibernate.type FloatType INSTANCE
FloatType INSTANCE
To view the source code for org.hibernate.type FloatType INSTANCE.
Click Source Link
From source file:com.manydesigns.portofino.persistence.hibernate.HibernateConfig.java
License:Open Source License
public boolean setHibernateType(@Nullable SimpleValue value, com.manydesigns.portofino.model.database.Column column, Class javaType, final int jdbcType) { String typeName;/*from w ww. j a va 2 s. com*/ Properties typeParams = null; if (javaType == null) { return false; } if (javaType == Long.class) { typeName = LongType.INSTANCE.getName(); } else if (javaType == Short.class) { typeName = ShortType.INSTANCE.getName(); } else if (javaType == Integer.class) { typeName = IntegerType.INSTANCE.getName(); } else if (javaType == Byte.class) { typeName = ByteType.INSTANCE.getName(); } else if (javaType == Float.class) { typeName = FloatType.INSTANCE.getName(); } else if (javaType == Double.class) { typeName = DoubleType.INSTANCE.getName(); } else if (javaType == Character.class) { typeName = CharacterType.INSTANCE.getName(); } else if (javaType == String.class) { typeName = StringType.INSTANCE.getName(); } else if (java.util.Date.class.isAssignableFrom(javaType)) { switch (jdbcType) { case Types.DATE: typeName = DateType.INSTANCE.getName(); break; case Types.TIME: typeName = TimeType.INSTANCE.getName(); break; case Types.TIMESTAMP: typeName = TimestampType.INSTANCE.getName(); break; default: typeName = null; } } else if (javaType == Boolean.class) { if (jdbcType == Types.BIT || jdbcType == Types.BOOLEAN) { typeName = BooleanType.INSTANCE.getName(); } else if (jdbcType == Types.NUMERIC || jdbcType == Types.DECIMAL || jdbcType == Types.INTEGER || jdbcType == Types.SMALLINT || jdbcType == Types.TINYINT || jdbcType == Types.BIGINT) { typeName = NumericBooleanType.INSTANCE.getName(); } else if (jdbcType == Types.CHAR || jdbcType == Types.VARCHAR) { typeName = StringBooleanType.class.getName(); typeParams = new Properties(); typeParams.setProperty("true", trueString != null ? trueString : StringBooleanType.NULL); typeParams.setProperty("false", falseString != null ? falseString : StringBooleanType.NULL); typeParams.setProperty("sqlType", String.valueOf(jdbcType)); } else { typeName = null; } } else if (javaType == BigDecimal.class) { typeName = BigDecimalType.INSTANCE.getName(); } else if (javaType == BigInteger.class) { typeName = BigIntegerType.INSTANCE.getName(); } else if (javaType == byte[].class) { typeName = BlobType.INSTANCE.getName(); } else { typeName = null; } if (typeName == null) { logger.error("Unsupported type (java type: {}, jdbc type: {}) " + "for column '{}'.", new Object[] { javaType, jdbcType, column.getColumnName() }); return false; } if (value != null) { value.setTypeName(typeName); if (typeParams != null) { value.setTypeParameters(typeParams); } } return true; }
From source file:com.mercatis.lighthouse3.persistence.commons.hibernate.ValueObjectUserType.java
License:Apache License
public Type[] getPropertyTypes() { return new Type[] { BooleanType.INSTANCE, IntegerType.INSTANCE, LongType.INSTANCE, FloatType.INSTANCE, DoubleType.INSTANCE, TimestampType.INSTANCE, BlobType.INSTANCE, StringType.INSTANCE, ClobType.INSTANCE };/* w ww . j av a 2 s . c o m*/ }
From source file:com.mercatis.lighthouse3.persistence.commons.hibernate.ValueObjectUserType.java
License:Apache License
public void nullSafeSet(PreparedStatement statement, Object value, int index, SessionImplementor session) throws HibernateException, SQLException { Dialect d = session.getFactory().getDialect(); boolean isSqlServer = d instanceof org.hibernate.dialect.SQLServerDialect || d instanceof org.hibernate.dialect.SQLServer2008Dialect || d instanceof org.hibernate.dialect.SQLServer2008Dialect; @SuppressWarnings("deprecation") boolean isOracle = d instanceof org.hibernate.dialect.OracleDialect || d instanceof org.hibernate.dialect.Oracle8iDialect || d instanceof org.hibernate.dialect.Oracle9Dialect || d instanceof org.hibernate.dialect.Oracle9iDialect || d instanceof org.hibernate.dialect.Oracle10gDialect; if (value instanceof Boolean) statement.setBoolean(index, (Boolean) value); else/*from w w w .j ava2s . co m*/ statement.setNull(index, BooleanType.INSTANCE.sqlType()); if (value instanceof Integer) statement.setInt(index + 1, (Integer) value); else statement.setNull(index + 1, IntegerType.INSTANCE.sqlType()); if (value instanceof Long) statement.setLong(index + 2, (Long) value); else statement.setNull(index + 2, LongType.INSTANCE.sqlType()); if (value instanceof Float) statement.setFloat(index + 3, (Float) value); else statement.setNull(index + 3, FloatType.INSTANCE.sqlType()); if (value instanceof Double) statement.setDouble(index + 4, (Double) value); else statement.setNull(index + 4, DoubleType.INSTANCE.sqlType()); if (value instanceof java.sql.Timestamp) statement.setTimestamp(index + 5, (java.sql.Timestamp) value); else if (value instanceof java.util.Date) statement.setTimestamp(index + 5, new java.sql.Timestamp(((java.util.Date) value).getTime())); else statement.setNull(index + 5, TimestampType.INSTANCE.sqlType()); if (value instanceof byte[] && isOracle) statement.setObject(index + 6, (byte[]) value); else if (value instanceof byte[]) statement.setBlob(index + 6, new SerialBlob((byte[]) value)); else statement.setNull(index + 6, java.sql.Types.BLOB); if (value instanceof String) statement.setString(index + 7, (String) value); else statement.setNull(index + 7, StringType.INSTANCE.sqlType()); if (value instanceof char[] && (isOracle || isSqlServer)) statement.setObject(index + 8, new String((char[]) value).getBytes()); else if (value instanceof char[]) statement.setClob(index + 8, new SerialClob((char[]) value)); else statement.setNull(index + 8, java.sql.Types.CLOB); }
From source file:com.mercatis.lighthouse3.persistence.events.hibernate.EventRegistryImplementation.java
License:Apache License
/** * This method generates criteria for a given event template that also * contain an ordering clause on the date of occurrence. * /*from w w w . j a v a 2 s. c o m*/ * @param session * the Hibernate session to use for criteria generation * @param entityTemplate * the template for which to generate the criteria * @param descending * <code>true</code> if descending order is wanted (the default) * or <code>false</code> for ascending order. * @return */ public Criteria generateOrderingCriteria(Session session, Event entityTemplate, boolean descending) { Criteria criteria = super.entityToCriteria(session, entityTemplate); if (entityTemplate.getContext() != null) { if (!Ranger.isEnumerationRange(entityTemplate.getContext())) criteria.add(Restrictions.eq("context", entityTemplate.getContext())); else criteria.add(Restrictions.in("context", Ranger.castToEnumerationRange(entityTemplate.getContext()).getEnumeration())); } if (entityTemplate.getCode() != null) { if (!Ranger.isEnumerationRange(entityTemplate.getCode())) criteria.add(Restrictions.eq("code", entityTemplate.getCode())); else criteria.add(Restrictions.in("code", Ranger.castToEnumerationRange(entityTemplate.getCode()).getEnumeration())); } if (entityTemplate.getLevel() != null) { if (!Ranger.isEnumerationRange(entityTemplate.getLevel())) criteria.add(Restrictions.eq("level", entityTemplate.getLevel())); else criteria.add(Restrictions.in("level", Ranger.castToEnumerationRange(entityTemplate.getLevel()).getEnumeration())); } if (entityTemplate.getMachineOfOrigin() != null) criteria.add(Restrictions.eq("machineOfOrigin", entityTemplate.getMachineOfOrigin())); if (entityTemplate.getMessage() != null) { criteria.add(Restrictions.ilike("message", "%" + entityTemplate.getMessage() + "%")); } if (entityTemplate.getStackTrace() != null) { if (this.unitOfWork.getSqlDialect() instanceof org.hibernate.dialect.MySQL5InnoDBDialect) criteria.add(Restrictions.sqlRestriction("match ({alias}.STACK_TRACE) against (?)", entityTemplate.getStackTrace(), StringType.INSTANCE)); else criteria.add(Restrictions.ilike("stackTrace", "%" + entityTemplate.getStackTrace() + "%")); } if (entityTemplate.getDateOfOccurrence() != null) { if (!Ranger.isIntervalRange(entityTemplate.getDateOfOccurrence())) { criteria.add(Restrictions.eq("dateOfOccurrence", entityTemplate.getDateOfOccurrence())); } else { Date lowerBound = Ranger.castToIntervalRange(entityTemplate.getDateOfOccurrence()).getLowerBound(); Date upperBound = Ranger.castToIntervalRange(entityTemplate.getDateOfOccurrence()).getUpperBound(); if ((lowerBound == null) && (upperBound != null)) criteria.add(Restrictions.le("dateOfOccurrence", upperBound)); else if ((lowerBound != null) && (upperBound == null)) criteria.add(Restrictions.ge("dateOfOccurrence", lowerBound)); else if ((lowerBound != null) && (upperBound != null)) { criteria.add(Restrictions.le("dateOfOccurrence", upperBound)); criteria.add(Restrictions.ge("dateOfOccurrence", lowerBound)); } } } if (!entityTemplate.getTransactionIds().isEmpty()) { Set<Criterion> transactionRestrictions = new HashSet<Criterion>(); for (String transactionId : entityTemplate.getTransactionIds()) transactionRestrictions.add(Restrictions.sqlRestriction( "exists (select lti.* from EVENT_TRANSACTION_IDS lti where {alias}.EVT_ID = lti.EVT_ID and lti.TRANSACTION_ID = ?)", transactionId, StringType.INSTANCE)); if (transactionRestrictions.size() == 1) { criteria.add(transactionRestrictions.iterator().next()); } else { Iterator<Criterion> restrictions = transactionRestrictions.iterator(); Criterion orCriterion = restrictions.next(); while (restrictions.hasNext()) { orCriterion = Restrictions.or(orCriterion, restrictions.next()); } criteria.add(orCriterion); } } for (String tag : entityTemplate.getTags()) criteria.add(Restrictions.sqlRestriction( "exists (select lt.* from EVENT_TAGS lt where {alias}.EVT_ID = lt.EVT_ID and lt.TAG = ?)", tag, StringType.INSTANCE)); for (String udf : entityTemplate.getUdfs().keySet()) { Object value = entityTemplate.getUdf(udf); if (udf.equals("eventRESTResourceLimitRestriction")) { criteria.setMaxResults((Integer) value); break; } String columnName = ""; Type valueType = StringType.INSTANCE; if (value instanceof Boolean) { columnName = "BOOLEAN_VAL"; valueType = BooleanType.INSTANCE; } if (value instanceof Integer) { columnName = "INTEGER_VAL"; valueType = IntegerType.INSTANCE; } if (value instanceof Long) { columnName = "LONG_VAL"; valueType = LongType.INSTANCE; } if (value instanceof Float) { columnName = "FLOAT_VAL"; valueType = FloatType.INSTANCE; } if (value instanceof Double) { columnName = "DOUBLE_VAL"; valueType = DoubleType.INSTANCE; } if (value instanceof Date) { columnName = "DATE_VAL"; valueType = DateType.INSTANCE; } if (value instanceof byte[]) { columnName = "BINARY_VAL"; valueType = BlobType.INSTANCE; } if (value instanceof String) { columnName = "STRING_VAL"; valueType = StringType.INSTANCE; } criteria.add(Restrictions.sqlRestriction( "exists (select lu.* from EVENT_UDFS lu where {alias}.EVT_ID = lu.EVT_ID and lu.UDF = ? and lu." + columnName + " = ?)", new Object[] { udf, value }, new Type[] { StringType.INSTANCE, valueType })); } if (descending) criteria.addOrder(Order.desc("dateOfOccurrence")); else criteria.addOrder(Order.asc("dateOfOccurrence")); return criteria; }
From source file:com.soft.primerproyecto.Dao.BaseDaoHibernate.java
@Override public List<T> executeNamedQuery(final Method method, final Object[] queryArgs) { final String queryName = queryNameFromMethod(method); final Query namedQuery = getSessionFactory().getCurrentSession().getNamedQuery(queryName); //String[] namedParameters = namedQuery.getNamedParameters(); if (queryArgs != null) { for (int i = 0; i < queryArgs.length; i++) { Object arg = queryArgs[i]; if (arg instanceof String) namedQuery.setParameter("param" + i, arg, StringType.INSTANCE); else if (arg instanceof Integer) namedQuery.setParameter("param" + i, arg, IntegerType.INSTANCE); else if (arg instanceof Date) namedQuery.setParameter("param" + i, arg, TimestampType.INSTANCE); else if (arg instanceof Long) namedQuery.setParameter("param" + i, arg, LongType.INSTANCE); else if (arg instanceof Float) namedQuery.setParameter("param" + i, arg, FloatType.INSTANCE); else// w w w . ja v a 2 s.c o m namedQuery.setParameter("param" + i, arg); } } return (List) namedQuery.list(); }
From source file:com.timesoft.kaitoo.ws.common.CoreContent.java
public static void fildHibernateParameter(final SQLQuery sqlQuery, final Map<String, Object> paramMap) throws HibernateException { Set<String> set = paramMap.keySet(); for (Iterator<String> iter = set.iterator(); iter.hasNext();) { String paramName = iter.next(); Object paramValue = paramMap.get(paramName); if (paramValue != null) { if (paramValue instanceof java.lang.String) { sqlQuery.setParameter(paramName, paramValue.toString().trim(), StringType.INSTANCE); } else if (paramValue instanceof java.lang.Character) { sqlQuery.setParameter(paramName, paramValue, CharacterType.INSTANCE); } else if (paramValue instanceof java.lang.Integer) { sqlQuery.setParameter(paramName, paramValue, IntegerType.INSTANCE); } else if (paramValue instanceof java.util.Date) { sqlQuery.setParameter(paramName, paramValue, DateType.INSTANCE); } else if (paramValue instanceof java.lang.Long) { sqlQuery.setParameter(paramName, paramValue, LongType.INSTANCE); } else if (paramValue instanceof java.sql.Timestamp) { sqlQuery.setParameter(paramName, paramValue, TimestampType.INSTANCE); } else if (paramValue instanceof java.lang.Boolean) { sqlQuery.setParameter(paramName, paramValue, BooleanType.INSTANCE); } else if (paramValue instanceof java.lang.Float) { sqlQuery.setParameter(paramName, paramValue, FloatType.INSTANCE); } else if (paramValue instanceof java.lang.Double) { sqlQuery.setParameter(paramName, paramValue, DoubleType.INSTANCE); } else if (paramValue instanceof java.lang.Byte) { sqlQuery.setParameter(paramName, paramValue, ByteType.INSTANCE); } else if (paramValue instanceof java.util.Calendar) { sqlQuery.setParameter(paramName, paramValue, CalendarType.INSTANCE); }/*from w ww .j a v a 2s. c om*/ } } }
From source file:org.babyfish.hibernate.cfg.Configuration.java
License:Open Source License
@SuppressWarnings("unchecked") private void addNativeFunctions() { Map<String, SQLFunction> map = this.getSqlFunctions(); map.put("nativeInteger", new AbstractNativeFunction() { @Override/*from w ww . ja v a2 s . com*/ public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return IntegerType.INSTANCE; } }); map.put("nativeLong", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return LongType.INSTANCE; } }); map.put("nativeFloat", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return FloatType.INSTANCE; } }); map.put("nativeDouble", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return DoubleType.INSTANCE; } }); map.put("nativeBigInteger", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return BigIntegerType.INSTANCE; } }); map.put("nativeBigDecimal", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return BigDecimalType.INSTANCE; } }); map.put("nativeString", new AbstractNativeFunction() { @Override public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException { return StringType.INSTANCE; } }); //TODO: more types, all the derived types of org.hibernate.type.AbstractSingleColumnStandardBasicType }
From source file:org.yamj.core.database.dao.ApiDao.java
License:Open Source License
/** * Get a list of the files associated with a video ID. * * @param type/*from ww w.ja v a 2s . c om*/ * @param id * @return */ private List<ApiFileDTO> getFilesForId(MetaDataType type, Long id) { // Build the SQL statement StringBuilder sbSQL = new StringBuilder(); sbSQL.append( "SELECT mf.id as id, mf.extra as extra, mf.part as part, mf.part_title as partTitle, mf.movie_version as version, "); sbSQL.append( "mf.container as container, mf.codec as codec, mf.codec_format as codecFormat, mf.codec_profile as codecProfile, "); sbSQL.append("mf.bitrate as bitrate, mf.overall_bitrate as overallBitrate, mf.fps as fps, "); sbSQL.append( "mf.width as width, mf.height as height, mf.aspect_ratio as aspectRatio, mf.runtime as runtime, mf.video_source as videoSource, "); sbSQL.append( "sf.id as fileId, sf.full_path as fileName, sf.file_date as fileDate, sf.file_size as fileSize, "); if (type == MetaDataType.MOVIE) { sbSQL.append("null as season, null as episode "); sbSQL.append("FROM mediafile_videodata mv, mediafile mf, stage_file sf "); sbSQL.append("WHERE mv.videodata_id=:id "); } else if (type == MetaDataType.SERIES) { sbSQL.append("sea.season, vd.episode "); sbSQL.append("FROM mediafile_videodata mv, mediafile mf, stage_file sf, season sea, videodata vd "); sbSQL.append("WHERE sea.series_id=:id "); sbSQL.append("and vd.season_id=sea.id "); sbSQL.append("and mv.videodata_id=vd.id "); } else if (type == MetaDataType.SEASON) { sbSQL.append("sea.season, vd.episode "); sbSQL.append("FROM mediafile_videodata mv, mediafile mf, stage_file sf, season sea, videodata vd "); sbSQL.append("WHERE sea.id=:id "); sbSQL.append("and vd.season_id=sea.id "); sbSQL.append("and mv.videodata_id=vd.id "); } else if (type == MetaDataType.EPISODE) { sbSQL.append("sea.season, vd.episode "); sbSQL.append("FROM mediafile_videodata mv, mediafile mf, stage_file sf, season sea, videodata vd "); sbSQL.append("WHERE vd.id=:id "); sbSQL.append("and vd.season_id=sea.id "); sbSQL.append("and mv.videodata_id=vd.id "); } sbSQL.append("and mv.mediafile_id=mf.id "); sbSQL.append("and sf.mediafile_id=mf.id "); sbSQL.append("and sf.file_type='"); sbSQL.append(FileType.VIDEO.toString()); sbSQL.append("' and sf.status not in ('"); sbSQL.append(StatusType.DUPLICATE.toString()); sbSQL.append("','"); sbSQL.append(StatusType.DELETED.toString()); sbSQL.append("') "); if (type == MetaDataType.SERIES || type == MetaDataType.SEASON) { sbSQL.append("ORDER BY sea.season ASC, vd.episode ASC"); } SqlScalars sqlScalars = new SqlScalars(sbSQL); sqlScalars.addScalar(ID, LongType.INSTANCE); sqlScalars.addScalar("extra", BooleanType.INSTANCE); sqlScalars.addScalar("part", IntegerType.INSTANCE); sqlScalars.addScalar("partTitle", StringType.INSTANCE); sqlScalars.addScalar("version", StringType.INSTANCE); sqlScalars.addScalar("container", StringType.INSTANCE); sqlScalars.addScalar("codec", StringType.INSTANCE); sqlScalars.addScalar("codecFormat", StringType.INSTANCE); sqlScalars.addScalar("codecProfile", StringType.INSTANCE); sqlScalars.addScalar("bitrate", IntegerType.INSTANCE); sqlScalars.addScalar("overallBitrate", IntegerType.INSTANCE); sqlScalars.addScalar("fps", FloatType.INSTANCE); sqlScalars.addScalar("width", IntegerType.INSTANCE); sqlScalars.addScalar("height", IntegerType.INSTANCE); sqlScalars.addScalar("aspectRatio", StringType.INSTANCE); sqlScalars.addScalar("runtime", IntegerType.INSTANCE); sqlScalars.addScalar("videoSource", StringType.INSTANCE); sqlScalars.addScalar("fileId", LongType.INSTANCE); sqlScalars.addScalar("fileName", StringType.INSTANCE); sqlScalars.addScalar("fileDate", TimestampType.INSTANCE); sqlScalars.addScalar("fileSize", LongType.INSTANCE); sqlScalars.addScalar(SEASON, LongType.INSTANCE); sqlScalars.addScalar(EPISODE, LongType.INSTANCE); sqlScalars.addParameter(ID, id); List<ApiFileDTO> results = executeQueryWithTransform(ApiFileDTO.class, sqlScalars, null); if (CollectionUtils.isNotEmpty(results)) { for (ApiFileDTO file : results) { file.setAudioCodecs(this.getAudioCodecs(file.getId())); file.setSubtitles(this.getSubtitles(file.getId())); } } return results; }
From source file:ru.caramel.juniperbot.core.common.persistence.support.PostgreSQLToRankCDFunction.java
License:Open Source License
@Override public Type getReturnType(Type columnType, Mapping mapping) throws QueryException { return FloatType.INSTANCE; }