Package org.hibernate

Examples of org.hibernate.SQLQuery.executeUpdate()

134
135
136
137
138
139
140
141
142
143
144
    }
    int index=0;
    for (String value : values) {
        query.setParameter(index++, value);
    }
    query.executeUpdate();
  }
 
  @SuppressWarnings({ "unchecked", "rawtypes" })
  private static void executeHqlQuery(String className, List<String> headers, List<String> values, Session session)
      throws Exception {
View Full Code Here
754
755
756
757
758
759
760
761
762
763
764
    SQLQuery query = getSession()
        .createSQLQuery(
            "update recursos set fk_historico_gps = :HISTORICO where x_recurso = :ID");
    query.setBigInteger("ID", idRecurso);
    query.setLong("HISTORICO", historicoGPS.getId());
    query.executeUpdate();
  }

  @Transactional(readOnly = true, rollbackFor = Throwable.class, propagation = Propagation.REQUIRED)
  public EstadoRecurso getEstadoRecursoByIdentificador(String identificador) {
    EstadoRecurso resultado;
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
          StringBuilder sql = new StringBuilder();
          sql.append("ALTER USER '").append(username).append(
              "' SET PASSWORD '").append(newPassword).append("'");

          SQLQuery query = session.createSQLQuery(sql.toString());
          query.executeUpdate();

          // update the current account object
          dataSource.setPassword(newPassword);
          account.setPassword(newPassword);
          account.setPasswordProtected(!newPassword.isEmpty());
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
          // SET FILES SCRIPT FORMAT {TEXT | COMPRESSED};
          // http://hsqldb.org/doc/2.0/guide/deployment-chapt.html#deploymen_modes-sect
          // COMPRESSED leads to problems with Test, therefore we go with TEXT format
          String sql = "SET FILES SCRIPT FORMAT TEXT";
          SQLQuery query = session.createSQLQuery(sql);
          query.executeUpdate();
        } catch(HibernateException hb) {
         
        }
        return null;
      }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session session) {
        try {
          String sql = "SHUTDOWN";
          SQLQuery query = session.createSQLQuery(sql);
          query.executeUpdate();
        } catch(HibernateException hb) {
        }
        return null;
      }
    });
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
    TransactionDefinition transDef = new DefaultTransactionDefinition();
    TransactionStatus transStatus = htm.getTransaction(transDef);
    SessionFactory sf = ContextManager.getSessionFactory();
    Session sess = sf.getCurrentSession();
    SQLQuery q = sess.createSQLQuery(sql);
    q.executeUpdate();
    sess.flush();
    sess.getTransaction().commit();
    sess.close();
  }
 
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
   
    //if (tbStudyID != null) {
      sqlQuery.setParameter("tbsid", tbStudyID);
    //} else {
     
    sqlQuery.executeUpdate();
  }

 
  /* (non-Javadoc)
   * @see org.cipres.treebase.domain.study.StudyHome#findByTrees(java.util.Set)
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    sql.append("ALTER USER '").append(username)
        .append("' SET PASSWORD '").append(newPassword)
        .append("'");

    SQLQuery query = sessionFactory.getCurrentSession().createSQLQuery(sql.toString());
    query.executeUpdate();
   
    dataSource.setPassword(newPassword);
    account.setPassword(newPassword);
    account.setPasswordProtected(!newPassword.isEmpty());
  }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
  }

  public void shutdown() {
    String sql = "SHUTDOWN";
    SQLQuery query = sessionFactory.getCurrentSession().createSQLQuery(sql);
    query.executeUpdate();
  }

  public void setSessionFactory(SessionFactory sessionFactory) {
    this.sessionFactory = sessionFactory;
  }
View Full Code Here
410
411
412
413
414
415
416
417
418
419
420
     
      List<?> list = session.createSQLQuery(checkIndex).list();
      if (String.valueOf(list.get(0)).equals("0")) {
        System.out.println( "Creating Index AW_INDEX_" + columnName +" ON " + tableName );
        SQLQuery sqlQuery = session.createSQLQuery(newIndex);
        sqlQuery.executeUpdate(); 
      }

    } catch (NoSuchFieldException e) {
      e.printStackTrace();
    } catch (SecurityException e) {
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.