Example usage for org.hibernate.type StringType INSTANCE

Introduction

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

Prototype

StringType INSTANCE

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

Click Source Link

Usage

From source file:com.marvinformatics.hibernate.json.PostgreSQL93Dialect.java

License:Apache License

public PostgreSQL93Dialect() {
    super();//from  w  ww  .  j  a v  a2s  .co  m
    registerColumnType(Types.JAVA_OBJECT, "json");

    registerFunction("json_text", new SQLFunctionTemplate(StringType.INSTANCE, "?1 ->> ?2"));
}

---

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 w  w w .  j a  v a2s .c  om*/
}

---

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 ww w .  j  a v a  2  s . c  o 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.environment.hibernate.ProcessTaskRegistryImplementation.java

License:Apache License

@Override
protected Criteria entityToCriteria(Session session, ProcessTask entityTemplate) {
    Criteria criteria = super.entityToCriteria(session, entityTemplate);

    if (entityTemplate.getLongName() != null)
        criteria.add(Restrictions.eq("longName", entityTemplate.getLongName()));

    if (entityTemplate.getVersion() != null)
        criteria.add(Restrictions.eq("version", entityTemplate.getVersion()));

    if (entityTemplate.getDescription() != null)
        criteria.add(Restrictions.eq("description", entityTemplate.getDescription()));

    if (entityTemplate.getContact() != null)
        criteria.add(Restrictions.eq("contact", entityTemplate.getContact()));

    if (entityTemplate.getContactEmail() != null)
        criteria.add(Restrictions.eq("contactEmail", entityTemplate.getContactEmail()));

    for (Entry<String, String> swimlane : entityTemplate.getSwimlaneData().entrySet()) {
        criteria.add(Restrictions.sqlRestriction(
                "exists (select psl.* from PROCESS_SWIMLANES psl where {alias}.STC_ID = psl.PRO_ID and psl.SWIMLANE = ? and psl.PRO_CODE = ?)",
                new String[] { swimlane.getValue(), swimlane.getKey() },
                new Type[] { StringType.INSTANCE, StringType.INSTANCE }));
    }/* w w  w . ja v a  2  s .c  o  m*/

    for (Tuple<String, String> transition : entityTemplate.getTransitionData()) {
        criteria.add(Restrictions.sqlRestriction(
                "exists (select pst.* from PROCESS_TRANSITIONS pst where {alias}.STC_ID = pst.PRO_ID and pst.FROM_PRO_CODE = ? and pst.TO_PRO_CODE = ?)",
                new String[] { transition.getA(), transition.getB() },
                new Type[] { StringType.INSTANCE, StringType.INSTANCE }));
    }

    criteria.setCacheable(true);

    return criteria;
}

---

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  ww  .  j a va 2  s . co  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();//from w ww. j a va  2  s .  c  o  m
    return results;
}

---

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

@Override
public List<TicketHeader> findFinish() throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy FROM   tblTicketsH  WHERE (TicketsFinished = 'F')\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("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();/*  w  w w  . j a  v a 2  s . c o m*/
    return results;
}

---

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

@Override
public List<TicketHeader> findFinish(String area) throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy \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 (tblTicketsH.TicketsFinished = 'F')\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("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();/*from   ww w  .  ja v a 2 s. 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();/*from  w ww  .  jav  a2 s  . c o  m*/
    return results;

}

---

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/*from   w w  w .ja va2s  . co  m*/
                namedQuery.setParameter("param" + i, arg);
        }
    }
    return (List) namedQuery.list();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• »