Examples of SqlQuery

Examples of org.hibernate.SQLQuery

117
118
119
120
121
122
123
124
125
126
127
  }

  public Query createNativeQuery(String sqlString) {
    //adjustFlushMode();
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      return new QueryImpl( q, this );
    }
    catch (HibernateException he) {
      throwPersistenceException( he );
      return null;
View Full Code Here

Examples of org.hibernate.SQLQuery

129
130
131
132
133
134
135
136
137
138
139
140
  }

  public Query createNativeQuery(String sqlString, Class resultClass) {
    //adjustFlushMode();
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      q.addEntity( "alias1", resultClass.getName(), LockMode.READ );
      return new QueryImpl( q, this );
    }
    catch (HibernateException he) {
      throwPersistenceException( he );
      return null;
View Full Code Here

Examples of org.hibernate.SQLQuery

142
143
144
145
146
147
148
149
150
151
152
153
  }

  public Query createNativeQuery(String sqlString, String resultSetMapping) {
    //adjustFlushMode();
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      q.setResultSetMapping( resultSetMapping );
      return new QueryImpl( q, this );
    }
    catch (HibernateException he) {
      throwPersistenceException( he );
      return null;
View Full Code Here

Examples of org.hibernate.SQLQuery

708
709
710
711
712
713
714
715
716
717
718
          );
  }

  public Query createNativeQuery(String sqlString) {
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      return new QueryImpl( q, this );
    }
    catch ( HibernateException he ) {
      throw convert( he );
    }
View Full Code Here

Examples of org.hibernate.SQLQuery

718
719
720
721
722
723
724
725
726
727
728
729
    }
  }

  public Query createNativeQuery(String sqlString, Class resultClass) {
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      q.addEntity( "alias1", resultClass.getName(), LockMode.READ );
      return new QueryImpl( q, this );
    }
    catch ( HibernateException he ) {
      throw convert( he );
    }
View Full Code Here

Examples of org.hibernate.SQLQuery

729
730
731
732
733
734
735
736
737
738
739
740
    }
  }

  public Query createNativeQuery(String sqlString, String resultSetMapping) {
    try {
      SQLQuery q = getSession().createSQLQuery( sqlString );
      q.setResultSetMapping( resultSetMapping );
      return new QueryImpl( q, this );
    }
    catch ( HibernateException he ) {
      throw convert( he );
    }
View Full Code Here

Examples of org.hibernate.SQLQuery

468
469
470
471
472
473
474
475
476
477
478
479
      // this need only exists for native SQL queries, not JPQL or Criteria queries (both of which do
      // partial auto flushing already).
      return;
    }

    final SQLQuery sqlQuery = (SQLQuery) query;
    if ( sqlQuery.getSynchronizedQuerySpaces() != null && ! sqlQuery.getSynchronizedQuerySpaces().isEmpty() ) {
      // The application defined query spaces on the Hibernate native SQLQuery which means the query will already
      // perform a partial flush according to the defined query spaces, no need to do a full flush.
      return;
    }
View Full Code Here

Examples of org.hibernate.SQLQuery

101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
    String natSQL = new SQLStorage(this.timeFilterFrom, this.timeFilterTo,
        this.timeGrouping, IDlist).getSQL();

    Session session = Helper.getHibernateSession();

    SQLQuery query = session.createSQLQuery(natSQL);

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

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

    DataTable dtbl = new DataTable(StatisticsMode.getByClassName(
        this.getClass()).getTitle() + " "
        + Helper.getTranslation("_inGB"));
View Full Code Here

Examples of org.hibernate.SQLQuery

365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
      String stepName = step.getTitle();
      headerRow.setName("header - delete again");
      headerRow.addValue(stepName, Double.parseDouble("0"));
    }

    SQLQuery query = session.createSQLQuery(natSQL);

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

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

    DataTable dtbl = new DataTable("");

    // if headerRow is set then add it to the DataTable to set columns
    // needs to be removed later
View Full Code Here

Examples of org.hibernate.SQLQuery

112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
        getTimeUnit(), IDlist).getSQL(HistoryEventType.stepError, null,
        false, false);

    Session session = Helper.getHibernateSession();

    SQLQuery query = session.createSQLQuery(natSQL);

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

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

    DataTable dtbl = new DataTable(StatisticsMode.getByClassName(
        this.getClass()).getTitle()
        + Helper.getTranslation("_(number)"));
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.