Example usage for org.hibernate.type StandardBasicTypes INTEGER

Introduction

In this page you can find the example usage for org.hibernate.type StandardBasicTypes INTEGER.

Prototype

IntegerType INTEGER

To view the source code for org.hibernate.type StandardBasicTypes INTEGER.

Click Source Link

Document

The standard Hibernate type for mapping Integer to JDBC java.sql.Types#INTEGER INTEGER .

Usage

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//w  w  w.  j a v  a2 s .  com
public boolean allowBatchClear(Integer batchUploadId) {
    String sql = "select count(id) as rowCount from batchUploads where id = :id and statusId in (22,23,1);";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addScalar("rowCount",
            StandardBasicTypes.INTEGER);
    query.setParameter("id", batchUploadId);
    Integer rowCount = (Integer) query.list().get(0);
    if (rowCount == 0) {
        return true;
    }
    return false;
}

---

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional/*from   w  ww.j a v  a  2s.c  o  m*/
@SuppressWarnings("unchecked")
public List<transactionRecords> getFieldColAndValues(Integer batchUploadId, configurationFormFields cff) {
    String sql = ("select transactionInId as transactionId, F" + cff.getFieldNo() + "  as fieldValue, "
            + cff.getFieldNo() + " as fieldNo from transactiontranslatedIn " + " where configId = :configId "
            + " and F" + cff.getFieldNo() + " is not null "
            + " and transactionInId in (select id from transactionIn where" + " batchId = :batchUploadId"
            + " and configId = :configId and statusId not in ( :transRELId ) order by transactionInId); ");

    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("transactionId", StandardBasicTypes.INTEGER)
            .addScalar("fieldValue", StandardBasicTypes.STRING).addScalar("fieldNo", StandardBasicTypes.INTEGER)
            .setResultTransformer(Transformers.aliasToBean(transactionRecords.class))
            .setParameter("configId", cff.getconfigId()).setParameter("batchUploadId", batchUploadId)
            .setParameterList("transRELId", transRELId);

    List<transactionRecords> trs = query.list();

    return trs;
}

---

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//from   w  ww .  java 2 s  .  co m
public Integer getRecordCounts(Integer batchId, List<Integer> statusIds, boolean foroutboundProcessing,
        boolean inStatusIds) {
    String tableName = "transactionIn";
    String batchType = "batchId";
    if (foroutboundProcessing) {
        tableName = "transactionTarget";
        batchType = "batchDLId";
    }
    String sql = "select count(id) as total from " + tableName + " where " + batchType + " = :batchId ";
    if (statusIds.size() > 0) {
        sql = sql + " and statusId ";
        if (!inStatusIds) {
            sql = sql + " not ";
        }
        sql = sql + "in (:statusIds)";
    }

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addScalar("total",
                StandardBasicTypes.INTEGER);

        query.setParameter("batchId", batchId);

        if (statusIds.size() > 0) {
            query.setParameterList("statusIds", statusIds);
        }

        return (Integer) query.list().get(0);
    } catch (Exception ex) {
        System.err.println("getRecordCounts " + ex.getCause());
        return null;
    }
}

---

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional// ww w.  j a  v a2 s.  c o m
public boolean checkPermissionForBatch(User userInfo, batchUploads batchInfo) {

    try {
        String sql = ("select count(id) as idCount from configurationConnectionSenders where "
                + "connectionid in (select id from configurationConnections "
                + "where sourceConfigId = :batchConfigId) and userId = :userId");
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addScalar("idCount",
                StandardBasicTypes.INTEGER);
        query.setParameter("batchConfigId", batchInfo.getConfigId());
        query.setParameter("userId", userInfo.getId());

        Integer idCount = (Integer) query.list().get(0);

        if (idCount > 0) {
            return true;
        }
    } catch (Exception ex) {
        System.err.println("checkPermissionForBatch " + ex.getCause());
        ex.printStackTrace();
    }
    return false;
}

---

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//from  w w  w .  java2 s  .c  o m
public Integer getCountForErrorId(Integer batchId, Integer errorId) {

    String sql = "select count(id) as total from transactionInErrors where batchUploadId = :batchId and errorId = :errorId";

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addScalar("total",
                StandardBasicTypes.INTEGER);

        query.setParameter("batchId", batchId);
        query.setParameter("errorId", errorId);

        return (Integer) query.list().get(0);
    } catch (Exception ex) {
        System.err.println("getCountForErrorId " + ex.getCause());
        return null;
    }
}

---

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//from   w w  w .j  av  a  2 s .  co m
@SuppressWarnings("unchecked")
public List<transactionRecords> getFieldColAndValueByTransactionId(configurationFormFields cff,
        Integer transactionId) {
    try {
        String sql = ("select transactionInId as transactionId, F" + cff.getFieldNo() + "  as fieldValue, "
                + cff.getFieldNo() + " as fieldNo from transactiontranslatedIn "
                + " where configId = :configId " + " and F" + cff.getFieldNo() + " is not null "
                + " and transactionInId = :id");

        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .addScalar("transactionId", StandardBasicTypes.INTEGER)
                .addScalar("fieldValue", StandardBasicTypes.STRING)
                .addScalar("fieldNo", StandardBasicTypes.INTEGER)
                .setResultTransformer(Transformers.aliasToBean(transactionRecords.class))
                .setParameter("configId", cff.getconfigId()).setParameter("id", transactionId);

        List<transactionRecords> trs = query.list();

        return trs;
    } catch (Exception ex) {
        System.err.println("getFieldColAndValueByTransactionId " + ex.getCause());
        ex.printStackTrace();
        return null;
    }
}

---

From source file:com.ut.healthelink.dao.impl.transactionOutDAOImpl.java

/**
 * The 'getMaxFieldNo' function will return the max field number for the passed in configuration.
 *
 * @param configId The id of the configuration to find out how many fields it has
 *
 * @return This function will return the max field number.
 *///ww  w .  j a  va 2 s. c  om
@Override
@Transactional
public int getMaxFieldNo(int configId) throws Exception {

    String sql = "select max(fieldNo) as maxFieldNo from configurationFormFields where configId = :configId";

    /* Need to make sure no duplicates */
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addScalar("maxFieldNo",
            StandardBasicTypes.INTEGER);
    query.setParameter("configId", configId);

    return (Integer) query.list().get(0);

}

---

From source file:com.vmware.sqlfire.hibernate.SQLFireDialect.java

License:Open Source License

public SQLFireDialect() {
    super();/* w  ww .j  ava2  s.  co  m*/
    LOG.info("SQLFireDialect for Hibernate 4 initialized.");

    registerFunction("concat", new DerbyConcatFunction());
    registerFunction("trim", new AnsiTrimFunction());
    registerFunction("value", new StandardSQLFunction("coalesce"));
    registerFunction("nvl", new NvlFunction());
    registerFunction("groups", new StandardSQLFunction("GROUPS", StandardBasicTypes.STRING));
    registerFunction("dsid", new StandardSQLFunction("DSID", StandardBasicTypes.STRING));
    registerFunction("groupsintersection",
            new StandardSQLFunction("GROUPSINTERSECTION", StandardBasicTypes.STRING));
    registerFunction("groupsintersect", new StandardSQLFunction("GROUPSINTERSECT", StandardBasicTypes.BOOLEAN));
    registerFunction("groupsunion", new StandardSQLFunction("GROUPSUNION", StandardBasicTypes.STRING));
    registerFunction("longint", new StandardSQLFunction("bigint", StandardBasicTypes.LONG));
    registerFunction("int", new StandardSQLFunction("integer", StandardBasicTypes.INTEGER));
    registerFunction("pi", new StandardSQLFunction("pi", StandardBasicTypes.DOUBLE));
    registerFunction("random", new NoArgSQLFunction("random", StandardBasicTypes.DOUBLE));
    registerFunction("rand", new StandardSQLFunction("rand", StandardBasicTypes.DOUBLE));// override
    registerFunction("sinh", new StandardSQLFunction("sinh", StandardBasicTypes.DOUBLE));
    registerFunction("cosh", new StandardSQLFunction("cosh", StandardBasicTypes.DOUBLE));
    registerFunction("tanh", new StandardSQLFunction("tanh", StandardBasicTypes.DOUBLE));
    registerFunction("user", new NoArgSQLFunction("USER", StandardBasicTypes.STRING, false));
    registerFunction("current_user", new NoArgSQLFunction("CURRENT_USER", StandardBasicTypes.STRING, false));
    registerFunction("session_user", new NoArgSQLFunction("SESSION_USER", StandardBasicTypes.STRING, false));
    registerFunction("current isolation",
            new NoArgSQLFunction("CURRENT ISOLATION", StandardBasicTypes.STRING, false));
    registerFunction("current_role", new NoArgSQLFunction("CURRENT_ROLE", StandardBasicTypes.STRING, false));
    registerFunction("current schema",
            new NoArgSQLFunction("CURRENT SCHEMA", StandardBasicTypes.STRING, false));
    registerFunction("current sqlid", new NoArgSQLFunction("CURRENT SQLID", StandardBasicTypes.STRING, false));
    registerFunction("xmlexists", new StandardSQLFunction("XMLEXISTS", StandardBasicTypes.NUMERIC_BOOLEAN));
    registerFunction("xmlparse", new StandardSQLFunction("XMLPARSE", StandardBasicTypes.TEXT));
    registerFunction("xmlquery", new StandardSQLFunction("XMLQUERY", StandardBasicTypes.STRING));
    registerFunction("xmlserialize", new StandardSQLFunction("XMLSERIALIZE", StandardBasicTypes.STRING));
    registerFunction("get_current_connection",
            new NoArgSQLFunction("GET_CURRENT_CONNECTION", StandardBasicTypes.BINARY, true));
    registerFunction("identity_val_local",
            new NoArgSQLFunction("IDENTITY_VAL_LOCAL", StandardBasicTypes.BINARY, true));
}

---

From source file:com.vmware.sqlfire.hibernate.v4.v0.SQLFireDialect.java

License:Open Source License

public SQLFireDialect() {
    super();//from  w w  w.  java  2  s. com
    LOG.info("SQLFireDialect for Hibernate 4.0 initialized.");

    registerFunction("concat", new DerbyConcatFunction());
    registerFunction("trim", new AnsiTrimFunction());
    registerFunction("value", new StandardSQLFunction("coalesce"));
    registerFunction("nvl", new NvlFunction());
    registerFunction("groups", new StandardSQLFunction("GROUPS", StandardBasicTypes.STRING));
    registerFunction("dsid", new StandardSQLFunction("DSID", StandardBasicTypes.STRING));
    registerFunction("groupsintersection",
            new StandardSQLFunction("GROUPSINTERSECTION", StandardBasicTypes.STRING));
    registerFunction("groupsintersect", new StandardSQLFunction("GROUPSINTERSECT", StandardBasicTypes.BOOLEAN));
    registerFunction("groupsunion", new StandardSQLFunction("GROUPSUNION", StandardBasicTypes.STRING));
    registerFunction("longint", new StandardSQLFunction("bigint", StandardBasicTypes.LONG));
    registerFunction("int", new StandardSQLFunction("integer", StandardBasicTypes.INTEGER));
    registerFunction("pi", new StandardSQLFunction("pi", StandardBasicTypes.DOUBLE));
    registerFunction("random", new NoArgSQLFunction("random", StandardBasicTypes.DOUBLE));
    registerFunction("rand", new StandardSQLFunction("rand", StandardBasicTypes.DOUBLE));// override
    registerFunction("sinh", new StandardSQLFunction("sinh", StandardBasicTypes.DOUBLE));
    registerFunction("cosh", new StandardSQLFunction("cosh", StandardBasicTypes.DOUBLE));
    registerFunction("tanh", new StandardSQLFunction("tanh", StandardBasicTypes.DOUBLE));
    registerFunction("user", new NoArgSQLFunction("USER", StandardBasicTypes.STRING, false));
    registerFunction("current_user", new NoArgSQLFunction("CURRENT_USER", StandardBasicTypes.STRING, false));
    registerFunction("session_user", new NoArgSQLFunction("SESSION_USER", StandardBasicTypes.STRING, false));
    registerFunction("current isolation",
            new NoArgSQLFunction("CURRENT ISOLATION", StandardBasicTypes.STRING, false));
    registerFunction("current_role", new NoArgSQLFunction("CURRENT_ROLE", StandardBasicTypes.STRING, false));
    registerFunction("current schema",
            new NoArgSQLFunction("CURRENT SCHEMA", StandardBasicTypes.STRING, false));
    registerFunction("current sqlid", new NoArgSQLFunction("CURRENT SQLID", StandardBasicTypes.STRING, false));
    registerFunction("xmlexists", new StandardSQLFunction("XMLEXISTS", StandardBasicTypes.NUMERIC_BOOLEAN));
    registerFunction("xmlparse", new StandardSQLFunction("XMLPARSE", StandardBasicTypes.TEXT));
    registerFunction("xmlquery", new StandardSQLFunction("XMLQUERY", StandardBasicTypes.STRING));
    registerFunction("xmlserialize", new StandardSQLFunction("XMLSERIALIZE", StandardBasicTypes.STRING));
    registerFunction("get_current_connection",
            new NoArgSQLFunction("GET_CURRENT_CONNECTION", StandardBasicTypes.BINARY, true));
    registerFunction("identity_val_local",
            new NoArgSQLFunction("IDENTITY_VAL_LOCAL", StandardBasicTypes.BINARY, true));
}

---

From source file:dao.OperacionesDAO.java

License:GNU General Public License

/**
 * Regresa la lista de bloqueados de un Usuario. An no s para qu, pero
 * seguro resultar til/*ww w  . ja  v  a 2s  . c om*/
 * @param u - Es el usuario que desea obtener la lista de bloqueados.
 * @return Una lista con los id de los bloqueados.
 */
public List<Integer> obtenListaDeBloqueados(Usuario u) {
    Transaction tx = session().beginTransaction();
    try {
        Query q = session().createSQLQuery("select id_bloqueado from bloqueados where " + "id_bloqueador = :id")
                .addScalar("id_bloqueado", StandardBasicTypes.INTEGER);
        q.setInteger("id", u.getIdUsuario());
        /* La lista de usuarios bloqueados */
        List<Integer> lista = q.list();
        return lista;
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (!tx.wasCommitted()) {
            tx.commit();
        }
        closeSession();
    }
    return null;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »