Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

112
113
114
115
116
117
118
119
120
121
122
  }
 
  public int executeNative (String query, Object... pars) {
    Query q = this.getStorage().createNativeQuery(query);
    for (int i=0; i<pars.length; i++) q.setParameter(i, pars[i]);
    return q.executeUpdate();
  }
 
  public List getNativeResults (String query) { return this.getNativeResults(query, new Object[0]); }
 
  public List getNativeResults (String query, Object... pars) {
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
    Query query = this.getStorage().createQuery(queryString);
    if (parameters != null) for (Object key : parameters.keySet()) {
      Object value = this.translateParameter( parameters.get(key) );
      if (queryString.contains(":" + key)) query.setParameter(key.toString(), value);
    }
    return query.executeUpdate();
  }
 
  public Object translateParameter (Object object) { return object; }
 
  public boolean exists (Map parameters, String queryString) {
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
     * Verifies if the container can make a bulk operation delete.
     */
    public void testDelete() {
        startup();
        Query query = entityManager.createQuery("DELETE FROM Customer c  WHERE  c.id > 2");
        query.executeUpdate();
        entityManager.flush();
        Query queryTest = entityManager.createQuery("SELECT c FROM Customer c");
        List lstCustomer = queryTest.getResultList();
        for (Object obj : lstCustomer) {
            Customer customer = (Customer) obj;
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
     * Verifies if the container can make a bulk operation update.
     */
    public void testUpdate() {
        startup();
        Query query = entityManager.createQuery("UPDATE Address a SET a.country = 'Brazil' WHERE a.id =1");
        query.executeUpdate();
        entityManager.flush();
        testVerifyUpdate();
      }

    /**
 
View Full Code Here
559
560
561
562
563
564
565
566
567
568
569
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("isTrash", isTrash);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
     
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
View Full Code Here
613
614
615
616
617
618
619
620
621
622
623
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("isRead", isRead);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
     
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
     
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
View Full Code Here
699
700
701
702
703
704
705
706
707
708
709
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
     
//      //Refresh the Entities in the Cache as Hibernate will not do it!
//      for (Long privateMessageId : privateMessageIds) {
//        String hqlSel = "select c from PrivateMessages c " +
//                "where c.privateMessageId = :privateMessageId ";
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
      EntityTransaction tx = session.getTransaction();
      tx.begin();
     
      Query query = session.createQuery(hql);
          query.setParameter("userContactId",userContactId);
          int rowCount = query.executeUpdate();
     
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return rowCount;     
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
      EntityTransaction tx = session.getTransaction();
      tx.begin();
     
      Query query = session.createQuery(hql);
          query.setParameter("ownerId",ownerId);
          int rowCount = query.executeUpdate();
     
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return rowCount;     
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.