Package org.hibernate

Examples of org.hibernate.SQLQuery.addScalar()

106
107
108
109
110
111
112
113
114
115
116
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        query.addScalar("description",Hibernate.STRING);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(result);
        return result;
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        query.addScalar("description",Hibernate.STRING);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(result);
        return result;
      }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
  public Object doInHibernate(Session session) throws HibernateException, SQLException {

    SQLQuery sqlQuery = session.createSQLQuery(queryDaEseguire);

    for (Entry<String, Type> entry : mappingCampi.entrySet()) {
      sqlQuery = sqlQuery.addScalar(entry.getKey(), entry.getValue());
    }

    Query query = sqlQuery.setResultTransformer(Transformers.aliasToBean(class1));
    if(searchCriteria!=null){
      for (SearchCriteria sc : searchCriteria) {
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
    public List<VolumeManagement> getStatefulCandidates(final VirtualDatacenter vdc)
    {

        SQLQuery query = getSession().createSQLQuery(SQL_VOLUME_MANAGEMENT_GET_STATEFUL_CANDIDATES);
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
    public List<VolumeManagement> getStatefulCandidates(final VirtualDatacenter vdc)
    {

        SQLQuery query = getSession().createSQLQuery(SQL_VOLUME_MANAGEMENT_GET_STATEFUL_CANDIDATES);
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
    {

        SQLQuery query = getSession().createSQLQuery(SQL_VOLUME_MANAGEMENT_GET_STATEFUL_CANDIDATES);
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
        query.addScalar("tier");
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
        SQLQuery query = getSession().createSQLQuery(SQL_VOLUME_MANAGEMENT_GET_STATEFUL_CANDIDATES);
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
        query.addScalar("tier");
        Map<String, Object> params = new HashMap<String, Object>();
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
        SQLQuery query = getSession().createSQLQuery(SQL_VOLUME_MANAGEMENT_GET_STATEFUL_CANDIDATES);
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
        query.addScalar("tier");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id_vdc", vdc.getId());
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
        query.addScalar("idman");
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
        query.addScalar("tier");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id_vdc", vdc.getId());
        params.put("state", VolumeState.DETACHED.name());
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
        query.addScalar("vdcname");
        query.addScalar("SIZE");
        query.addScalar("available");
        query.addScalar("used");
        query.addScalar("elementname");
        query.addScalar("STATE");
        query.addScalar("tier");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id_vdc", vdc.getId());
        params.put("state", VolumeState.DETACHED.name());
        params.put("storage_tecnology", "GENERIC_ISCSI");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.