Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

156
157
158
159
160
161
162
163
164
165
166
      txn.begin();

      String name = em.getMetamodel().entity(config.getEntityClass())
          .getName();
      Query query = em.createQuery("DELETE FROM " + name);
      query.executeUpdate();

      txn.commit();
    } catch (Exception e) {
      if (txn != null && txn.isActive())
        txn.rollback();
View Full Code Here
367
368
369
370
371
372
373
374
375
376
377
                user.getDevices().remove(device);
                device.setLatestPosition(null);
                entityManager.flush();
                Query query = entityManager.createQuery("DELETE FROM Position x WHERE x.device = :device");
                query.setParameter("device", device);
                query.executeUpdate();
                entityManager.remove(device);
                entityManager.getTransaction().commit();
                return device;
            } catch (RuntimeException e) {
                entityManager.getTransaction().rollback();
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
      for(String key: params.keySet()){
        logger.debug("{}) [{}] : {}", new Object[]{i++, key, params.get(key)});
        query.setParameter(key, params.get(key));
      }
    }
    return query.executeUpdate();
  }
 
  public int batchUpdateByQuery(String queryString, Map<String, Object> params) {
    Query query = entityManager.createQuery(queryString);
    logger.debug("Batch Update[{}]", queryString);
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
      for(String key: params.keySet()){
        logger.debug("{}) [{}] : {}", new Object[]{i++, key, params.get(key)});
        query.setParameter(key, params.get(key));
      }
    }
    return query.executeUpdate();
  }
 
  @SuppressWarnings("unchecked")
  private <T> List<T> findByQueryNative(Query query, Map<String,Object> params, int start, int pageSize){
    if(params != null && !params.keySet().isEmpty()){
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
            q.setParameter("status", coordAction.getStatus().toString());
            q.setParameter("lastModifiedTime", new Date());
            q.setParameter("runConf", coordAction.getRunConf());
            q.setParameter("externalId", coordAction.getExternalId());
            q.setParameter("pending", coordAction.getPending());
            q.executeUpdate();
            // Since the return type is Void, we have to return null
            return null;
        }
        catch (Exception e) {
            throw new JPAExecutorException(ErrorCode.E0603, e);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    public Integer execute(EntityManager em) throws JPAExecutorException {
        int actionsDeleted = 0;
        try {
            Query g = em.createNamedQuery("DELETE_COMPLETED_ACTIONS_FOR_BUNDLE");
            g.setParameter("bundleId", bundleId);
            actionsDeleted = g.executeUpdate();
        }
        catch (Exception e) {
            throw new JPAExecutorException(ErrorCode.E0603, e);
        }
        return actionsDeleted;
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    public Integer execute(EntityManager em) throws JPAExecutorException {
        int actionsDeleted = 0;
        try {
            Query g = em.createNamedQuery("DELETE_COMPLETED_ACTIONS_FOR_COORDINATOR");
            g.setParameter("jobId", coordJobId);
            actionsDeleted = g.executeUpdate();
        }
        catch (Exception e) {
            throw new JPAExecutorException(ErrorCode.E0603, e);
        }
        return actionsDeleted;
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    public Integer execute(EntityManager em) throws JPAExecutorException {
        int actionsDeleted = 0;
        try {
            Query g = em.createNamedQuery("DELETE_ACTIONS_FOR_WORKFLOW");
            g.setParameter("wfId", wfId);
            actionsDeleted = g.executeUpdate();
        }
        catch (Exception e) {
            throw new JPAExecutorException(ErrorCode.E0603, e);
        }
        return actionsDeleted;
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
        doOperation("updateCoordinatorAction", new Callable<Void>() {
            public Void call() throws StoreException {
                Query q = entityManager.createNamedQuery("UPDATE_COORD_ACTION");
                q.setParameter("id", action.getId());
                setActionQueryParameters(action, q);
                q.executeUpdate();
                return null;
            }
        });
    }
View Full Code Here
378
379
380
381
382
383
384
385
386
387
388
                q.setParameter("id", action.getId());
                q.setParameter("missingDependencies", action.getMissingDependencies());
                q.setParameter("lastModifiedTime", new Date());
                q.setParameter("status", action.getStatus().toString());
                q.setParameter("actionXml", action.getActionXml());
                q.executeUpdate();
                return null;
            }
        });
    }
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.