org.hibernate.Query.executeUpdate() - java examples

Here are the examples of the java api org.hibernate.Query.executeUpdate() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

155 Examples 7

19 View Complete Implementation : ActionDAOimpl.java
Copyright Apache License 2.0
Author : HsingPeng
@Override
public void cutFollower(int eid) {
    try {
        Session s = HibernateSessionFactory.getSession();
        String hql = "update EventVo vo set vo.followerscount=vo.followerscount - 1 where vo.eid=:eid";
        Query query = s.createQuery(hql);
        query.setParameter("eid", eid);
        query.executeUpdate();
        Transaction t = s.beginTransaction();
        t.commit();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

19 View Complete Implementation : PortDao.java
Copyright MIT License
Author : sensepost
public void deletePortFromIp(String ipAddress, int portNumber, int footprintId) {
    String hql = "delete from Port where portNumber = :portNumber and ipAddress.address = :ipAddress and footprint.id = :footprintId";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("portNumber", portNumber);
    query.setParameter("ipAddress", ipAddress);
    query.setParameter("footprintId", footprintId);
    query.executeUpdate();
}

19 View Complete Implementation : AddInstitutionFileWarningColumn.java
Copyright Apache License 2.0
Author : openequella
@Override
protected void executeDataMigration(HibernateMigrationHelper helper, MigrationResult result, Session session) throws Exception {
    Query q = session.createQuery("UPDATE Insreplacedution SET quota = :value");
    q.setParameter("value", 0.0);
    q.executeUpdate();
}

19 View Complete Implementation : AttachDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void deleteByToId(long toId) {
    Query query = createQuery("delete from AttachPO where to_id = :toId");
    query.setLong("toId", toId);
    query.executeUpdate();
}

19 View Complete Implementation : MessageDao.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public void delete(SmIdAndTaskIdPair smIdAndTaskIdPair) {
    Query query = currentSession().createQuery("delete from ScheduledMessage where stateMachineId = :smId and taskId = :taskId");
    query.setString("smId", smIdAndTaskIdPair.getSmId());
    query.setLong("taskId", smIdAndTaskIdPair.getTaskId());
    query.executeUpdate();
}

19 View Complete Implementation : UserDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void idenreplacedyComment(List<Long> userIds, boolean idenreplacedy) {
    String substm = "+ 1";
    if (!idenreplacedy) {
        substm = "- 1";
    }
    Query query = createSQLQuery("update mto_users set comments = comments " + substm + " where id in (:ids)");
    query.setParameterList("ids", userIds);
    query.executeUpdate();
}

19 View Complete Implementation : ActionDAOimpl.java
Copyright Apache License 2.0
Author : HsingPeng
@Override
public void countComment(int eid) {
    try {
        Session s = HibernateSessionFactory.getSession();
        String hql = "update EventVo vo set vo.commentscount=vo.commentscount + 1 where vo.eid=:eid";
        Query query = s.createQuery(hql);
        query.setParameter("eid", eid);
        query.executeUpdate();
        Transaction t = s.beginTransaction();
        t.commit();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

19 View Complete Implementation : AddLastActionDate.java
Copyright Apache License 2.0
Author : openequella
@Override
protected void executeDataMigration(HibernateMigrationHelper helper, MigrationResult result, Session session) {
    Query query = session.createQuery("select i.id, i.moderation.id from Item i where moderating = true or status = 'rejected'");
    ScrollableResults results = query.scroll();
    while (results.next()) {
        Query upQuery = session.createQuery("update ModerationStatus m set lastAction = " + "(select max(h.date) from Item i join i.history h where i.id = ? and h.type in ('approved','rejected', 'comment') group by i.id) " + "where m.id = ?");
        upQuery.setParameter(0, results.get(0));
        upQuery.setParameter(1, results.get(1));
        upQuery.executeUpdate();
    }
}

19 View Complete Implementation : HostDao.java
Copyright MIT License
Author : sensepost
public void deleteHost(String hostName, int footprintId) {
    String hql = "delete from Host where name = :hostName and footprint.id = :footprintId";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("hostName", hostName);
    query.setParameter("footprintId", footprintId);
    query.executeUpdate();
}

19 View Complete Implementation : MessageDao.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public int bulkInsertOrUpdate(List<ScheduledMessage> messages) {
    StringBuilder query = new StringBuilder("insert into ScheduledMessages ( stateMachineId , taskId , " + "scheduledTime )  values ");
    messages.forEach(scheduledMessage -> {
        query.append("( \'").append(scheduledMessage.getStateMachineId()).append("\' , ");
        query.append(scheduledMessage.getTaskId()).append(" , ");
        query.append(scheduledMessage.getScheduledTime()).append("), ");
    });
    query.deleteCharAt(query.length() - 1);
    query.setCharAt(query.length() - 1, ' ');
    query.append("on duplicate key update scheduledTime = values(scheduledTime)");
    // created native SQL query, required full table name.
    final Query insertOrUpdateQuery = currentSession().createSQLQuery(query.toString());
    return insertOrUpdateQuery.executeUpdate();
}

19 View Complete Implementation : CommentDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public int deleteByIds(Collection<Long> ids) {
    Query query = createQuery("delete from CommentPO where id in (:ids)");
    query.setParameterList("ids", ids);
    return query.executeUpdate();
}

19 View Complete Implementation : StatesDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Override
@Transactional
@SelectDataSource(type = DataSourceType.READ_WRITE, storage = Storage.SHARDED)
public void incrementRetryCount(String stateMachineId, Long stateId) {
    Query query = currentSession().createQuery("update State set attemptedNoOfRetries = attemptedNoOfRetries + 1 where id = :stateId and stateMachineId = :stateMachineId");
    query.setLong("stateId", stateId);
    query.setString("stateMachineId", stateMachineId);
    query.executeUpdate();
}

19 View Complete Implementation : MessageDao.java
Copyright Apache License 2.0
Author : flipkart-incubator
/**
 * Deletes the corresponding {@link ScheduledMessage}s from ScheduledMessages table in one shot.
 *
 * @param messageIdsToDelete List of {@link ScheduledMessage} Ids
 */
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public int deleteInBatch(List<SmIdAndTaskIdPair> messageIdsToDelete) {
    StringBuilder queryBuilder = new StringBuilder();
    queryBuilder.append("delete from ScheduledMessage where (stateMachineId,taskId) in (");
    messageIdsToDelete.forEach(smIdAndTaskIdPair -> {
        queryBuilder.append("(\'").append(smIdAndTaskIdPair.getSmId()).append("\',\'").append(smIdAndTaskIdPair.getTaskId()).append("\'),");
    });
    queryBuilder.setCharAt(queryBuilder.length() - 1, ')');
    final Query deleteQuery = currentSession().createQuery(queryBuilder.toString());
    return deleteQuery.executeUpdate();
}

19 View Complete Implementation : TopicReadOnlyTest.java
Copyright Apache License 2.0
Author : hazelcast
@Test(expected = UnsupportedOperationException.clreplaced)
public void testUpdateEnreplacediesAndProperties() {
    insertDummyEnreplacedies(1, 10);
    Session session = null;
    Transaction txn = null;
    try {
        session = sf.openSession();
        txn = session.beginTransaction();
        Query query = session.createQuery("update DummyEnreplacedy set name = 'updated-name' where id < 2");
        query.setCacheable(true);
        query.executeUpdate();
        Query query2 = session.createQuery("update DummyProperty set version = version + 1");
        query2.setCacheable(true);
        query2.executeUpdate();
        txn.commit();
    } catch (RuntimeException e) {
        txn.rollback();
        e.printStackTrace();
        throw e;
    } finally {
        session.close();
    }
}

19 View Complete Implementation : UserConfigDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Update user config profile
 */
public static void updateProfile(String ucUser, int upId) throws DatabaseException {
    log.debug("updateProfile({}, {})", ucUser, upId);
    String qs = "update UserConfig uc set uc.profile=:profile where uc.user=:user";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setEnreplacedy("profile", ProfileDAO.findByPk(upId));
        q.setString("user", ucUser);
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("updateProfile: void");
}

19 View Complete Implementation : UnreadDAOimpl.java
Copyright Apache License 2.0
Author : HsingPeng
// 标记消息为已读
public boolean updateUnread(int remindid) {
    boolean flag = false;
    try {
        Session session = HibernateSessionFactory.getSession();
        session.clear();
        String hql = "update UnreadVo as vo set vo.isread=true where vo.remindid=:remindid";
        Query query = session.createQuery(hql);
        query.setParameter("remindid", remindid);
        query.executeUpdate();
        flag = true;
    } catch (Exception e) {
        e.printStackTrace();
    }
    return flag;
}

19 View Complete Implementation : UserDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void idenreplacedyFavors(List<Long> userIds, boolean idenreplacedy) {
    String substm = "+ 1";
    if (!idenreplacedy) {
        substm = "- 1";
    }
    Query query = createSQLQuery("update mto_users set favors = favors " + substm + " where id in (:ids)");
    query.setParameterList("ids", userIds);
    query.executeUpdate();
}

19 View Complete Implementation : DomainAttributeDao.java
Copyright MIT License
Author : sensepost
public void deleteDomainAtrribute(String domainName, String key, String value) {
    String hql = "delete from DomainAttribute where domain.name = :domainName and key = : key and value = :value";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("domainName", domainName);
    query.setParameter("key", key);
    query.setParameter("value", value);
    query.executeUpdate();
}

19 View Complete Implementation : DashboardDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Delete visited nodes
 */
public static void deleteVisitedNodes(String user, String source) throws DatabaseException {
    log.debug("deleteVisitedNodes({}, {})", user, source);
    String qs = "delete from Dashboard db where db.user=:user and db.source=:source";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setString("user", user);
        q.setString("source", source);
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("deleteVisitedNodes: void");
}

19 View Complete Implementation : DomainDao.java
Copyright MIT License
Author : sensepost
public void deleteDomain(String domainName, int footprintId) {
    String hql = "delete from Domain where name = :domainName and footprint.id = :footprintId";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("domainName", domainName);
    query.setParameter("footprintId", footprintId);
    query.executeUpdate();
}

19 View Complete Implementation : AddAlwaysLatestToBookmark.java
Copyright Apache License 2.0
Author : openequella
@Override
protected void executeDataMigration(HibernateMigrationHelper helper, MigrationResult result, Session session) {
    Query query = session.createQuery("UPDATE Bookmark SET always_latest = :value");
    query.setParameter("value", false);
    query.executeUpdate();
}

19 View Complete Implementation : AddThumbColumnMigration.java
Copyright Apache License 2.0
Author : openequella
@Override
protected void executeDataMigration(HibernateMigrationHelper helper, MigrationResult result, Session session) {
    Query query = session.createQuery("UPDATE Item SET thumb = :value");
    query.setParameter("value", "initial");
    query.executeUpdate();
}

19 View Complete Implementation : BookmarkDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Remove bookmarks by parent node
 */
public static void purgeBookmarksByNode(String nodeUuid) throws DatabaseException {
    log.debug("purgeBookmarksByNode({})", nodeUuid);
    String qs = "delete from Bookmark bm where bm.node=:uuid";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setString("uuid", nodeUuid);
        q.executeUpdate();
        HibernateUtil.commit(tx);
        log.debug("purgeBookmarksByNode: void");
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
}

19 View Complete Implementation : EventSchedulerDao.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public void delete(String correlationId, String eventName) {
    final Query deleteQuery = currentSession().createQuery("delete ScheduledEvent s where s.correlationId=:correlationId " + "and s.eventName=:eventName");
    deleteQuery.setString("correlationId", correlationId);
    deleteQuery.setString("eventName", eventName);
    deleteQuery.executeUpdate();
}

19 View Complete Implementation : ClientElbDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
/**
 * Delete Client Elb entry from DB
 */
@Override
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public void delete(String id) {
    Query deleteQuery = currentSession().createQuery("delete ClientElb c where c.id=:id");
    deleteQuery.setString("id", id);
    deleteQuery.executeUpdate();
}

19 View Complete Implementation : TopicReadWriteTest.java
Copyright Apache License 2.0
Author : hazelcast
@Test
public void testUpdateOneEnreplacedyAndProperties() {
    insertDummyEnreplacedies(1, 10);
    Session session = null;
    Transaction txn = null;
    try {
        session = sf.openSession();
        txn = session.beginTransaction();
        Query query = session.createQuery("update DummyEnreplacedy set name = 'updated-name' where id = 0");
        query.setCacheable(true);
        query.executeUpdate();
        Query query2 = session.createQuery("update DummyProperty set version = version + 1");
        query2.setCacheable(true);
        query2.executeUpdate();
        txn.commit();
    } catch (RuntimeException e) {
        txn.rollback();
        e.printStackTrace();
        throw e;
    } finally {
        session.close();
    }
    replacedertTopicNotifications(1, CACHE_ENreplacedY);
    replacedertTopicNotifications(1, CACHE_ENreplacedY_PROPERTIES);
    replacedertTopicNotifications(1, CACHE_PROPERTY);
    replacedertTopicNotifications(17, getTimestampsRegionName());
}

19 View Complete Implementation : StateMachinesDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Override
@Transactional
@SelectDataSource(type = DataSourceType.READ_WRITE, storage = Storage.SHARDED)
public void updateStatus(String stateMachineId, StateMachineStatus status) {
    Query query = currentSession().createQuery("update StateMachine set status = :status where id = :stateMachineId");
    query.setString("status", status != null ? status.toString() : null);
    query.setString("stateMachineId", stateMachineId);
    query.executeUpdate();
}

19 View Complete Implementation : ClientElbDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
/**
 * Updates Elb Url of a client in DB
 */
@Override
@Transactional
@SelectDataSource(storage = Storage.SCHEDULER)
public void updateElbUrl(String clientElbId, String clientElbUrl) {
    Query updateQuery = currentSession().createQuery("update ClientElb set elbUrl = :clientElbUrl where id = :clientElbId");
    updateQuery.setString("clientElbUrl", clientElbUrl.toString());
    updateQuery.setString("clientElbId", clientElbId);
    updateQuery.executeUpdate();
}

19 View Complete Implementation : NotifyDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void readed4Me(long ownId) {
    Query query = createQuery("update NotifyPO set status = :s1 where status = :s2 and ownId = :ownId");
    query.setInteger("s1", Consts.READED);
    query.setInteger("s2", Consts.UNREAD);
    query.setLong("ownId", ownId);
    query.executeUpdate();
}

19 View Complete Implementation : UserConfigDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Set user home
 */
public static void setHome(UserConfig uc) throws DatabaseException {
    log.info("setHome({})", uc);
    String qs = "update UserConfig uc set uc.homePath=:path, uc.homeNode=:node, " + "uc.homeType=:type where uc.user=:user";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setString("path", uc.getHomePath());
        q.setString("node", uc.getHomeNode());
        q.setString("type", uc.getHomeType());
        q.setString("user", uc.getUser());
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("setHome: void");
}

19 View Complete Implementation : TopicReadWriteTest.java
Copyright Apache License 2.0
Author : hazelcast
@Test
public void testUpdateEnreplacediesAndProperties() {
    insertDummyEnreplacedies(1, 10);
    Session session = null;
    Transaction txn = null;
    try {
        session = sf.openSession();
        txn = session.beginTransaction();
        Query query = session.createQuery("update DummyEnreplacedy set name = 'updated-name' where id < 2");
        query.setCacheable(true);
        query.executeUpdate();
        Query query2 = session.createQuery("update DummyProperty set version = version + 1");
        query2.setCacheable(true);
        query2.executeUpdate();
        txn.commit();
    } catch (RuntimeException e) {
        txn.rollback();
        e.printStackTrace();
        throw e;
    } finally {
        session.close();
    }
    replacedertTopicNotifications(1, CACHE_ENreplacedY);
    replacedertTopicNotifications(1, CACHE_ENreplacedY_PROPERTIES);
    replacedertTopicNotifications(1, CACHE_PROPERTY);
    replacedertTopicNotifications(17, getTimestampsRegionName());
}

19 View Complete Implementation : UserDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void idenreplacedyFans(List<Long> userIds, boolean idenreplacedy) {
    String substm = "+ 1";
    if (!idenreplacedy) {
        substm = "- 1";
    }
    Query query = createSQLQuery("update mto_users set fans = fans " + substm + " where id in (:ids)");
    query.setParameterList("ids", userIds);
    query.executeUpdate();
}

19 View Complete Implementation : TopicReadOnlyTest.java
Copyright Apache License 2.0
Author : hazelcast
@Test(expected = UnsupportedOperationException.clreplaced)
public void testUpdateOneEnreplacedyAndProperties() {
    insertDummyEnreplacedies(1, 10);
    Session session = null;
    Transaction txn = null;
    try {
        session = sf.openSession();
        txn = session.beginTransaction();
        Query query = session.createQuery("update DummyEnreplacedy set name = 'updated-name' where id = 0");
        query.setCacheable(true);
        query.executeUpdate();
        Query query2 = session.createQuery("update DummyProperty set version = version + 1");
        query2.setCacheable(true);
        query2.executeUpdate();
        txn.commit();
    } catch (RuntimeException e) {
        txn.rollback();
        e.printStackTrace();
        throw e;
    } finally {
        session.close();
    }
}

19 View Complete Implementation : DashboardActivityDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Purge one month old activity
 */
public static synchronized void purge() throws DatabaseException {
    log.debug("purge()");
    String qs = "delete DashboardActivity da where da.date < :date";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        Calendar cal = Calendar.getInstance();
        cal.add(Calendar.MONTH, -1);
        q.setCalendar("date", cal);
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("purge: void");
}

19 View Complete Implementation : UpdateUserDetailDAOimpl.java
Copyright Apache License 2.0
Author : HsingPeng
@Override
public UserDataVo updateUserDetail(int uid, int usex, String ubirthday, String uaddress, String usatement) {
    try {
        Session s = HibernateSessionFactory.getSession();
        String hql = "update UserDataVo vo set vo.ubirthday=:ubirthday , vo.usex=:usex , vo.uaddress=:uaddress , vo.usatement=:usatement where vo.uid=:uid";
        Query query = s.createQuery(hql);
        query.setParameter("uid", uid);
        query.setParameter("usex", usex);
        query.setParameter("uaddress", uaddress);
        query.setParameter("usatement", usatement);
        query.setParameter("ubirthday", ubirthday);
        query.executeUpdate();
        Transaction t = s.beginTransaction();
        t.commit();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    UserDataDAO dao = new LogDAOimpl();
    return dao.getUserData(uid);
}

19 View Complete Implementation : UserDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void idenreplacedyFollow(List<Long> userIds, boolean idenreplacedy) {
    String substm = "+ 1";
    if (!idenreplacedy) {
        substm = "- 1";
    }
    Query query = createSQLQuery("update mto_users set follows = follows " + substm + " where id in (:ids)");
    query.setParameterList("ids", userIds);
    query.executeUpdate();
}

19 View Complete Implementation : ActionDAOimpl.java
Copyright Apache License 2.0
Author : HsingPeng
@Override
public void countFollower(int eid) {
    try {
        Session s = HibernateSessionFactory.getSession();
        String hql = "update EventVo vo set vo.followerscount=vo.followerscount + 1 where vo.eid=:eid";
        Query query = s.createQuery(hql);
        query.setParameter("eid", eid);
        query.executeUpdate();
        Transaction t = s.beginTransaction();
        t.commit();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

19 View Complete Implementation : UserInfoBackupDaoImpl.java
Copyright Apache License 2.0
Author : openequella
@Transactional(propagation = Propagation.MANDATORY)
@Override
public void deleteAllInfo() {
    getHibernateTemplate().execute(session -> {
        Query query = session.createQuery("delete from UserInfoBackup where insreplacedution_id = :insreplacedutionId");
        query.setParameter("insreplacedutionId", CurrentInsreplacedution.get().getUniqueId());
        query.executeUpdate();
        return null;
    });
}

19 View Complete Implementation : HostAttributeDao.java
Copyright MIT License
Author : sensepost
public void deleteHostAtrribute(String hostName, String key, String value, int footprintId) {
    String hql = "delete from HostAttribute where host.name = :hostName and key = : key and value = :value and footprint.id = :footprintId";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("hostName", hostName);
    query.setParameter("key", key);
    query.setParameter("value", value);
    query.setParameter("footprintId", footprintId);
    query.executeUpdate();
}

19 View Complete Implementation : UserDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public void idenreplacedyPost(List<Long> userIds, boolean idenreplacedy) {
    String substm = "+ 1";
    if (!idenreplacedy) {
        substm = "- 1";
    }
    Query query = createSQLQuery("update mto_users set posts = posts " + substm + " where id in (:ids)");
    query.setParameterList("ids", userIds);
    query.executeUpdate();
}

19 View Complete Implementation : IpAddressDao.java
Copyright MIT License
Author : sensepost
public void deleteIpAddressFromFootprint(String ipAddress, int footprintId) {
    String hql = "delete from IpAddress where address = :ipAddress and footprint.id = :footprintId";
    Query query = HibernateUtil.getSession().createQuery(hql);
    query.setParameter("ipAddress", ipAddress);
    query.setParameter("footprintId", footprintId);
    query.executeUpdate();
}

19 View Complete Implementation : WikiPageDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Remove wiki pages by parent node
 */
public static void purgeWikiPagesByNode(String nodeUuid) throws DatabaseException {
    log.debug("purgeWikiPagesByNode({})", nodeUuid);
    String qs = "delete from WikiPage wp where wp.node=:uuid";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setString("uuid", nodeUuid);
        q.executeUpdate();
        HibernateUtil.commit(tx);
        log.debug("purgeWikiPagesByNode: void");
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
}

19 View Complete Implementation : OperationalDataTestUtil.java
Copyright MIT License
Author : ria-ee
static void prepareDatabase() throws Exception {
    System.setProperty(SystemProperties.DATABASE_PROPERTIES, "src/test/resources/hibernate.properties");
    doInTransaction(session -> {
        Query q = session.createSQLQuery(// Completely wipe out the database. replaceduming that HSQLDB
        // is used for testing.
        "TRUNCATE SCHEMA public AND COMMIT");
        q.executeUpdate();
        return null;
    });
}

19 View Complete Implementation : AddExtraRemoteRepoColumns.java
Copyright Apache License 2.0
Author : openequella
@Override
protected void executeDataMigration(HibernateMigrationHelper helper, MigrationResult result, Session session) {
    Query setDenyQuery = session.createQuery("UPDATE ItemDefinition SET denyDirectContribution = :value");
    setDenyQuery.setParameter("value", false);
    Query setDisabledQuery = session.createQuery("UPDATE FederatedSearch SET disabled = :value");
    setDisabledQuery.setParameter("value", false);
    setDenyQuery.executeUpdate();
    setDisabledQuery.executeUpdate();
}

19 View Complete Implementation : StatesDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Override
@Transactional
@SelectDataSource(type = DataSourceType.READ_WRITE, storage = Storage.SHARDED)
public void updateStatus(String stateMachineId, Long stateId, Status status) {
    Query query = currentSession().createQuery("update State set status = :status where id = :stateId and stateMachineId = :stateMachineId");
    query.setString("status", status != null ? status.toString() : null);
    query.setLong("stateId", stateId);
    query.setString("stateMachineId", stateMachineId);
    query.executeUpdate();
}

19 View Complete Implementation : MailAccountDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Update preplacedword
 */
public static void updatePreplacedword(long maId, String mailPreplacedword) throws DatabaseException {
    log.debug("updatePreplacedword({}, {})", maId, mailPreplacedword);
    String qs = "update MailAccount ma set ma.mailPreplacedword=:mailPreplacedword where ma.id=:id";
    Session session = null;
    Transaction tx = null;
    try {
        if (mailPreplacedword != null && mailPreplacedword.trim().length() > 0) {
            session = HibernateUtil.getSessionFactory().openSession();
            tx = session.beginTransaction();
            Query q = session.createQuery(qs);
            q.setString("mailPreplacedword", mailPreplacedword);
            q.setLong("id", maId);
            q.executeUpdate();
            HibernateUtil.commit(tx);
        }
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("updatePreplacedword: void");
}

19 View Complete Implementation : ProfilingDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Clear table
 */
public static void clear() throws DatabaseException {
    String qs = "delete Profiling";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
}

19 View Complete Implementation : DashboardDAO.java
Copyright GNU General Public License v2.0
Author : openkm
/**
 * Delete old visited node
 */
public static void purgeOldVisitedNode(String user, String source, String node, Calendar date) throws DatabaseException {
    log.debug("purgeOldVisitedNode({}, {}, {}, {})", new Object[] { user, source, node, date });
    String qs = "delete from Dashboard db where db.user=:user and db.source=:source " + "and db.node=:node and db.date=:date";
    Session session = null;
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Query q = session.createQuery(qs);
        q.setString("user", user);
        q.setString("source", source);
        q.setString("node", node);
        q.setCalendar("date", date);
        q.executeUpdate();
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }
    log.debug("purgeOldVisitedNode: void");
}

19 View Complete Implementation : StatesDAOImpl.java
Copyright Apache License 2.0
Author : flipkart-incubator
@Override
@Transactional
@SelectDataSource(type = DataSourceType.READ_WRITE, storage = Storage.SHARDED)
public void updateRollbackStatus(String stateMachineId, Long stateId, Status rollbackStatus) {
    Query query = currentSession().createQuery("update State set rollbackStatus = :rollbackStatus where id = :stateId and stateMachineId = :stateMachineId");
    query.setString("rollbackStatus", rollbackStatus != null ? rollbackStatus.toString() : null);
    query.setLong("stateId", stateId);
    query.setString("stateMachineId", stateMachineId);
    query.executeUpdate();
}

19 View Complete Implementation : FollowDaoImpl.java
Copyright Apache License 2.0
Author : Anstoner
@Override
public int unfollow(long userId, long followId) {
    Query q = createSQLQuery("delete from mto_follows where user_id = :userId and follow_id = :followId");
    q.setLong("userId", userId);
    q.setLong("followId", followId);
    return q.executeUpdate();
}