public static int updateNaturalOrderForPipeline(Session session, Long pipelineId, double naturalOrder) { String sql = "UPDATE pipelines SET naturalOrder = :naturalOrder WHERE id = :pipelineId"; SQLQuery query = session.createSQLQuery(sql); query.setLong("pipelineId", pipelineId); query.setDouble("naturalOrder", naturalOrder); return query.executeUpdate(); }
public void store(Cargo cargo) { getSession().saveOrUpdate(cargo); // Delete-orphan does not seem to work correctly when the parent is a component getSession().createSQLQuery("delete from Leg where cargo_id = null").executeUpdate(); }
counter++; response += query.executeUpdate();
counter++; response += query.executeUpdate();
public int executeSql(String sql) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); return sqlQuery.executeUpdate(); }
public static void createViewUnreadPostsInBranch() { session.createSQLQuery("CREATE VIEW COUNT_POSTS_TOPICS_VIEW AS SELECT tp.TOPIC_ID, tp.BRANCH_ID," + " MAX(POST_DATE) as LAST_POST_DATE FROM TOPIC tp join POST p ON p.TOPIC_ID=tp.TOPIC_ID group by tp.TOPIC_ID") .executeUpdate(); }
SQLQuery sqlQuery = session.createSQLQuery("ALTER SESSION SET NLS_COMP = 'BINARY'"); sqlQuery.addSynchronizedQuerySpace(""); /* * Only the empty query space "" will be invalidated. * So no cache will be invalidated, because no table with an empty name exists */ int updatedEntities = sqlQuery.executeUpdate();
@Override public int execute(String queryString, Map<String, Object> where) { int result = this.getQuery(queryString, where, false).executeUpdate(); return result; }
/** * Used in manual rollback */ public static void deleteViewUnreadPostsInBranch() { session.createSQLQuery("DROP VIEW COUNT_POSTS_TOPICS_VIEW") .executeUpdate(); }
SQLQuery sqlQuery = session.createSQLQuery("ALTER SESSION SET NLS_COMP = 'BINARY'"); sqlQuery.addSynchronizedQuerySpace(""); int updatedEntities = sqlQuery.executeUpdate();
public void deleteByColumn(String schemaName, String tableName, String columnName, Object columnValue) { StringBuffer query = new StringBuffer(); query.append("DELETE FROM ").append(getFromClause(schemaName, tableName)).append(" WHERE ").append(columnName) .append("=").append("'").append(columnValue).append("'"); s = getStatelessSession(); Transaction tx = s.beginTransaction(); s.createSQLQuery(query.toString()).executeUpdate(); tx.commit(); }
Session s = factory.withOptions().openSession(); Transaction tx = s.beginTransaction(); SQLQuery query = s.createSQLQuery(sql); int res = query.executeUpdate(); tx.commit();
public int executeBySql(String sql) { int result; SQLQuery query = this.getSession().createSQLQuery(sql); result = query.executeUpdate(); return result; }
@Override public void executeUpdateSql(String sql) { getCurrentSession().createSQLQuery(sql).executeUpdate(); } }
public int updateSomeParameter(String tableName, String idColumnName, int id, String parameterColumnName, Object newParameterValue) { String sql = "UPDATE " + tableName + " SET " + parameterColumnName + " = :new_value WHERE " + idColumnName + " = :id"; SQLQuery query = session.createSQLQuery(sql); query.setInteger("id", id); query.setParameter("new_value", newParameterValue); return query.executeUpdate(); }
SQLQuery query = session.createSQLQuery(hql); query.setParameter(0, "asd"); ... query.setParameter(26, "asd2"); Integer result = query.executeUpdate();
SQLQuery query = session.createSQLQuery(sql); query.setDate(1, acctPeriod); query.setDate(2, geoScheme.getId()); recordCount = query.executeUpdate();
Session session = (Session) getEm().getDelegate(); Transaction tx = session.beginTransaction(); String sql ="Delete from xyz where id=:id" ; SQLQuery query = session.createSQLQuery(sql); query.setParameter("id", "1"); int flg = query.executeUpdate(); tx.commit();
private void createTable(final String createSQL) { try { HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(createSQL); sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }
private void insertRole(final String role) { try { final int nextId = getNextId("role"); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_ROLE]); sq.setInteger(0, nextId); sq.setString(1, role); sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }