Package org.hibernate

Examples of org.hibernate.SQLQuery.uniqueResult()

152
153
154
155
156
157
158
159
160
161
162
    try {
      String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { name:{name}, author:'Oscar Wilde' } ) RETURN n";
      SQLQuery query = session.createNativeQuery( nativeQuery ).addEntity( OscarWildePoem.class );
      query.setParameter( "name", "Portia" );

      OscarWildePoem uniqueResult = (OscarWildePoem) query.uniqueResult();
      assertThat( uniqueResult ).isEqualTo( portia );
      transaction.commit();
    }
    finally {
      session.clear();
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
    try {
      for (String tableName : tableNames) {
        String countSql = "select count(*) as RECORD_COUNT_ from "+tableName;
        SQLQuery sqlQuery = session.createSQLQuery(countSql);
        sqlQuery.addScalar("RECORD_COUNT_", Hibernate.LONG);
        Long recordCount = (Long) sqlQuery.uniqueResult();
        if (recordCount>0L) {
          recordsLeftMsg += tableName+":"+recordCount+", ";
        }
      }
    } finally {
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
  }
 
  public Long getNextId(String sequenceName) {
    SQLQuery query = session().createSQLQuery(
        String.format("SELECT %s.nextval FROM DUAL", sequenceName));
    BigDecimal id = (BigDecimal) query.uniqueResult();
    return id.longValue();
  }

  public T getById(Long id) throws DataException {
    return (T) component.load(getDomainClass(), id);
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
        countQuery.append("select count(*) ");
        countQuery.append(original.substring(original.toLowerCase().indexOf("from")));

        SQLQuery count = getSession().createSQLQuery(countQuery.toString());
        count.setProperties(parameters);
        return (Number) count.uniqueResult();
    }

    protected Criterion filterBy(final FilterOptions filters, final String... properties)
    {
        // Search criterias
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        if (idDatacenter != -1)
        {
            sqlQuery.setParameter("idDatacenter", idDatacenter);
        }

        Object[] calculatedResources = (Object[]) sqlQuery.uniqueResult();

        if (calculatedResources != null)
        {
            Long calculatedCpu =
                calculatedResources[0] == null ? 0 : ((BigDecimal) calculatedResources[0])
View Full Code Here
741
742
743
744
745
746
747
748
749
750
751
                + "r.tipo as \"tipoRecurso\", s.nombre as "
                + "subflota, r.dispositivo as dispositivo from recursos as r join flotas s on r.flota_x_flota = s.x_flota "
                + "where r.dispositivo = :DISPOSITIVO");
    query.setInteger("DISPOSITIVO", issi);
    query.setResultTransformer(Transformers.aliasToBean(RecursoBean.class));
    RecursoBean recurso = (RecursoBean) query.uniqueResult();

    return recurso;

  }
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
        sqlQuery.setParameter("docId", textFlow.getDocument().getDocId());
        sqlQuery.setParameter("projectId", textFlow.getDocument()
                .getProjectIteration().getProject().getId());
        sqlQuery.setParameter("localeId", targetLocaleId.getId());
        sqlQuery.addEntity(HTextFlowTarget.class);
        return Optional.fromNullable((HTextFlowTarget) sqlQuery.uniqueResult());
    }

    /**
     * Look up the {@link HTextFlowTarget} for the given hLocale in hTextFlow,
     * creating a new one if none is present.
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
  public int getBpmTaskCount()
  {
    /* Build query */
    SQLQuery query = getCountQuery();
   
    Number resultsCount = (Number)query.uniqueResult();
   
    return resultsCount.intValue();
  }
 
  /** Get bpm tasks from initialized query */
 
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
  }
 
  public Long getNextId(String sequenceName) {
    SQLQuery query = session().createSQLQuery(
        String.format("SELECT NEXTVAL('%s')", sequenceName));
    BigInteger id = (BigInteger) query.uniqueResult();
    return id.longValue();
  }

  public T getById(Long id) throws DataException {
    return (T) component.load(getDomainClass(), id);
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.