Example usage for org.hibernate.type BooleanType INSTANCE

List of usage examples for org.hibernate.type BooleanType INSTANCE

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.type.*
  5. BooleanType
  6. INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type BooleanType INSTANCE.

Prototype

BooleanType INSTANCE

To view the source code for org.hibernate.type BooleanType INSTANCE.

Click Source Link

Usage

From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java

public boolean qtHazmatCodeExit(String fileId) throws Exception {
    StringBuilder sb = new StringBuilder();
    sb.append("SELECT ");
    sb.append("  IF(");
    sb.append("    (SELECT ");
    sb.append("      hazrds ");
    sb.append("    FROM ");
    sb.append(dataBaseName).append(".ldgins");
    sb.append("    WHERE loadcd = SUBSTRING_INDEX(lq.code, '/', 1)) = 'y',");
    sb.append("    TRUE,");
    sb.append("    FALSE");
    sb.append("  ) AS hazStatus ");
    sb.append(" FROM");
    sb.append("  lcl_quote_hot_code lq ");
    sb.append("  JOIN genericcode_dup gd ");
    sb.append("    ON gd.code = SUBSTRING_INDEX(lq.code, '/', 1) ");
    sb.append("    AND gd.Codetypeid = ");
    sb.append("    (SELECT ");
    sb.append("      codetypeid ");
    sb.append("    FROM");
    sb.append("      codetype ");
    sb.append("    WHERE description = 'Hot Codes') ");
    sb.append("    AND gd.Field1 = 'Y' ");
    sb.append(" WHERE lq.file_number_id = :fileId");
    SQLQuery queryObject = getCurrentSession().createSQLQuery(sb.toString());
    queryObject.setParameter("fileId", fileId);
    queryObject.addScalar("hazStatus", BooleanType.INSTANCE);
    return (Boolean) (queryObject.uniqueResult() != null ? queryObject.uniqueResult() : Boolean.FALSE);
}

From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java

public boolean isHotCodeExistsForConsolidateFile(String fileId, String hotCode) throws Exception {
    StringBuilder queryBuilder = new StringBuilder();
    queryBuilder.append(" SELECT IF(COUNT(*)>0,'true','false') as result FROM lcl_booking_hot_code hc  ");
    queryBuilder.append(" JOIN lcl_file_number fn ON fn.id=hc.file_number_id WHERE  ");
    queryBuilder.append(//from   w  w w. j  ava 2  s  .  c o m
            " fn.id IN (SELECT lcl_file_number_id_a FROM `lcl_consolidation` WHERE lcl_file_number_id_b = ");
    queryBuilder.append(
            " (SELECT lcl_file_number_id_b FROM `lcl_consolidation` WHERE lcl_file_number_id_a =:fileId)) ");
    queryBuilder.append(" AND hc.`code` =:hotCode ");
    SQLQuery query = getCurrentSession().createSQLQuery(queryBuilder.toString());
    query.setParameter("fileId", fileId);
    query.setParameter("hotCode", hotCode);
    return (boolean) query.addScalar("result", BooleanType.INSTANCE).uniqueResult();
}

From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingSegregationDao.java

public Boolean isCheckedSegregationDr(Long fileId) throws Exception {
    StringBuilder queryStr = new StringBuilder();
    queryStr.append("SELECT IF(COUNT(*)>0,true,false) as result FROM lcl_booking_segregation");
    queryStr.append(" WHERE child_file_number_id=:fileId");
    SQLQuery query = getCurrentSession().createSQLQuery(queryStr.toString());
    query.setParameter("fileId", fileId);
    query.addScalar("result", BooleanType.INSTANCE);
    return (Boolean) query.setMaxResults(1).uniqueResult();
}

From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclQuoteHotCodeDAO.java

public boolean isHotCodeExist(String Code, String fileId) throws Exception {
    SQLQuery query = getCurrentSession()
            .createSQLQuery("select if(count(*)<1,true,false) as result from lcl_quote_hot_code "
                    + " where code=:code and file_number_id=:fileId");
    query.setParameter("fileId", fileId);
    query.setParameter("code", Code);
    query.addScalar("result", BooleanType.INSTANCE);
    return (Boolean) query.uniqueResult();
}

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 ww  w .ja  v a 2 s . c  om*/
    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 };//from  www  . j  av  a2s. co 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//  w ww  . j  a v  a  2s.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.
 * //w w w  . j  a v  a  2s. 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.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYear(int month, int year, String division) throws Exception {

    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished FROM tblTicketsH "
            + "WHERE (YEAR(ApplicationDate) = :paramYear) AND (MONTH(ApplicationDate) = :paramMonth) AND (DivisionCode = :division) AND (TicketsFinished != 'D')"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();//  www  .  j a  v  a 2s  .c  o  m
    return results;
}

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYearArea(int month, int year, String division, String area)
        throws Exception {
    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished, paidByAdmin, adminBy \n"
            + "FROM APP_USER LEFT OUTER JOIN\n"
            + "tblMaster_Branch ON APP_USER.branchId = tblMaster_Branch.BranchID RIGHT OUTER JOIN\n"
            + "tblTicketsH ON APP_USER.SSO_ID = tblTicketsH.ApplicationName\n"
            + "WHERE (tblMaster_Branch.Area = '" + area
            + "') AND (YEAR(tblTicketsH.ApplicationDate) = :paramYear) AND (MONTH(tblTicketsH.ApplicationDate) = :paramMonth) AND (tblTicketsH.DivisionCode = :division) AND (tblTicketsH.TicketsFinished != 'D')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE).addScalar("paidByAdmin", BigDecimalType.INSTANCE)
            .addScalar("adminBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();/*w  w  w  .java2  s  .  c o  m*/
    return results;

}