Examples of addScalar()

Examples of org.hibernate.SQLQuery.addScalar()

496
497
498
499
500
501
502
503
504
505
506
    Session session = Helper.getHibernateSession();
    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("minStep", StandardBasicTypes.DOUBLE);

    @SuppressWarnings("rawtypes")
    List list = query.list();

    if (list != null && list.size() > 0 && list.get(0) != null) {
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

123
124
125
126
127
128
129
130
131
132
133
    Session session = Helper.getHibernateSession();

    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("volumes", StandardBasicTypes.INTEGER);
    query.addScalar("pages", StandardBasicTypes.INTEGER);
    query.addScalar("intervall", StandardBasicTypes.STRING);

    @SuppressWarnings("rawtypes")
    List list = query.list();
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

124
125
126
127
128
129
130
131
132
133
134
    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("volumes", StandardBasicTypes.INTEGER);
    query.addScalar("pages", StandardBasicTypes.INTEGER);
    query.addScalar("intervall", StandardBasicTypes.STRING);

    @SuppressWarnings("rawtypes")
    List list = query.list();
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

125
126
127
128
129
130
131
132
133
134
135
    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("volumes", StandardBasicTypes.INTEGER);
    query.addScalar("pages", StandardBasicTypes.INTEGER);
    query.addScalar("intervall", StandardBasicTypes.STRING);

    @SuppressWarnings("rawtypes")
    List list = query.list();

    StringBuilder title = new StringBuilder(StatisticsMode.PRODUCTION.getTitle());
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

171
172
173
174
175
176
177
178
179
180
181
    Session session = sessionFactory.openSession();
    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+", ";
        }
      }
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

667
668
669
670
671
672
673
674
675
676
677
        .addProperty( "element.employmentId", "empId" )
        .addProperty( "element.salary" ).addColumnAlias( "VALUE" ).addColumnAlias( "CURRENCY" );
    sqlQuery.list();

    // lets try a totally different approach now and pull back scalars, first with explicit types
    sqlQuery.addScalar( "orgid", LongType.INSTANCE )
        .addScalar( "name", StringType.INSTANCE )
        .addScalar( "empid", LongType.INSTANCE )
        .addScalar( "employee", LongType.INSTANCE )
        .addScalar( "startDate", TimestampType.INSTANCE )
        .addScalar( "endDate", TimestampType.INSTANCE )
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

662
663
664
665
666
667
668
669
670
671
672
                    }
                }

                if (scalars != null) {
                    for (String key : scalars.keySet()) {
                        query.addScalar(key, scalars.get(key));
                    }
                }

                if (aliasClass != null) {
                    if (aliasClass.equals(Map.class)) {
View Full Code Here

Examples of org.hibernate.ogm.query.NoSQLQuery.addScalar()

50
51
52
53
54
55
56
57
58
59
60
    session.close();
  }

  private void assertCountQueryResult(OgmSession session, String queryString, long expectedCount) {
    NoSQLQuery query = session.createNativeQuery( queryString );
    query.addScalar( "n" );
    long actualCount = (Long) query.list().iterator().next();
    assertThat( actualCount ).describedAs( "Count query didn't yield expected result" ).isEqualTo( expectedCount );
  }

  @Override
View Full Code Here

Examples of org.hibernate.ogm.query.NoSQLQuery.addScalar()

276
277
278
279
280
281
282
283
284
285
286
    session.close();
  }

  private void assertCountQueryResult(OgmSession session, String queryString, long expectedCount) {
    NoSQLQuery query = session.createNativeQuery( queryString );
    query.addScalar( "n" );
    long actualCount = (Long) query.list().iterator().next();
    assertThat( actualCount ).describedAs( "Count query didn't yield expected result" ).isEqualTo( expectedCount );
  }

  @Override
View Full Code Here

Examples of org.hibernate.ogm.query.NoSQLQuery.addScalar()

68
69
70
71
72
73
74
75
76
77
78
    // Register the result types of the query; Currently either a number of scalar values or an entity return
    // are supported only; JP-QL would actually a combination of both, though (see OGM-514)
    if ( result.getProjection() != null ) {
      for ( String field : result.getProjection().keySet() ) {
        query.addScalar( field );
      }
    }
    else {
      query.addEntity( result.getEntityType() );
    }
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.