Example usage for org.hibernate SQLQuery addScalar

Introduction

In this page you can find the example usage for org.hibernate SQLQuery addScalar.

Prototype

SQLQuery<T> addScalar(String columnAlias);

Source Link

Document

Declare a scalar query result.

Usage

From source file:ubic.gemma.persistence.service.expression.designElement.CompositeSequenceDaoImpl.java

License:Apache License

@SuppressWarnings("unchecked")
@Override//from  w w w .  j av a 2  s .  c  om
public Collection<Object[]> getRawSummary(ArrayDesign arrayDesign, Integer numResults) {
    if (arrayDesign == null || arrayDesign.getId() == null) {
        throw new IllegalArgumentException();
    }

    if (numResults <= 0) {
        // get all probes. Uses a light-weight version of this query that omits as much as possible.
        final String queryString = CompositeSequenceDaoImpl.nativeBaseSummaryShorterQueryString
                + " where ad.id = " + arrayDesign.getId();
        try {
            org.hibernate.SQLQuery queryObject = this.getSessionFactory().getCurrentSession()
                    .createSQLQuery(queryString);
            queryObject.addScalar("deID").addScalar("deName").addScalar("bsName").addScalar("bsdbacc")
                    .addScalar("ssrid").addScalar("gId").addScalar("gSymbol");
            queryObject.setMaxResults(CompositeSequenceDaoImpl.MAX_CS_RECORDS);
            return queryObject.list();
        } catch (org.hibernate.HibernateException ex) {
            throw SessionFactoryUtils.convertHibernateAccessException(ex);
        }

    }
    // just a chunk but get the full set of results.
    //language=HQL
    final String queryString = "select cs from CompositeSequence as cs inner join cs.arrayDesign as ar where ar = :ar";
    this.getHibernateTemplate().setMaxResults(numResults);
    List<?> cs = this.getHibernateTemplate().findByNamedParam(queryString, "ar", arrayDesign);
    this.getHibernateTemplate().setMaxResults(0);
    return this.getRawSummary((Collection<CompositeSequence>) cs);

}

From source file:uk.chromis.utils.DataLogicKitchen.java

License:Open Source License

public List<String> readDistinctOrders() {
    if (Boolean.valueOf(AppConfig.getInstance().getProperty("screen.allorders"))) {
        sql_query = "SELECT DISTINCT ORDERID, ORDERTIME FROM ORDERS ORDER BY ORDERTIME ";
    } else {/*from   w ww  .j a va  2 s  . c  o m*/
        sql_query = "SELECT DISTINCT ORDERID, ORDERTIME FROM ORDERS WHERE DISPLAYID = "
                + Integer.parseInt(AppConfig.getInstance().getProperty("screen.displaynumber"))
                + " ORDER BY ORDERTIME";
    }
    SQLQuery query = HibernateUtil.getSessionFactory().openSession().createSQLQuery(sql_query);
    query.addScalar("ORDERID");
    List results = query.list();
    results = new ArrayList<String>(new LinkedHashSet<String>(results));
    return results;
}