Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

104
105
106
107
108
109
110
111
112
113
114
         
      if(shapeId != null)
          q.setParameter(10,  shapeId);
     
         
          q.executeUpdate();
    }
    else if(serviceCalendarDateId != null)
    {
Query q;
     
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
          .setParameter(8,  serviceCalendarDateId);
         
          if(shapeId != null)
            q.setParameter(9,  shapeId);
                 
          q.executeUpdate();
    }
    else
    {
      Logger.error("Missing vaild serivce id for trip " + gtfsTrip.getId().toString());
    }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
        .setParameter(4,  trip.tripHeadsign);

        if(trip.shape != null)
         q.setParameter(5,  trip.shape.id);

        q.executeUpdate();


      ArrayList<StopTime> stopTimes = trip.getStopTimes();

      Integer previousDepartureTime = 0;
View Full Code Here
200
201
202
203
204
205
206
207
208
209
210
          previousDistance = stopTime.shapeDistTraveled;
        }
       
        lastStopName = stopTime.stop.stopName;

        q.executeUpdate();
       
        q = em.createNativeQuery("INSERT INTO trippattern_trippatternstop (trippattern_id, patternstops_id) VALUES (?, ?);");
       
        q.setParameter(1,  tripPatternId.longValue());
        q.setParameter(2,  tripPatternStopId.longValue());
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
        q = em.createNativeQuery("INSERT INTO trippattern_trippatternstop (trippattern_id, patternstops_id) VALUES (?, ?);");
       
        q.setParameter(1,  tripPatternId.longValue());
        q.setParameter(2,  tripPatternStopId.longValue());
       
        q.executeUpdate();
       
           
           
      }
     
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
    @Override
    public int deleteOrphaned() {
        Query query = entityManager.createNamedQuery("ScheduleAction.removeOrphaned");

        return query.executeUpdate();
    }

    @PersistenceContext
    public void setEntityManager(EntityManager entityManager) {
        this.entityManager = entityManager;
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    @Override
    public int deleteExpired(Date expiration) {
        Query query = entityManager.createNamedQuery("ScheduleExecution.deleteExpired");
        query.setParameter("expiration", expiration);

        return query.executeUpdate();
    }

    @Override
    public int detachJob(long scheduleJobId) {
        Query query = entityManager.createNamedQuery("ScheduleExecution.detachJob");
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
    @Override
    public int detachJob(long scheduleJobId) {
        Query query = entityManager.createNamedQuery("ScheduleExecution.detachJob");
        query.setParameter("scheduleJobId", scheduleJobId);

        return query.executeUpdate();
    }

    @PersistenceContext
    public void setEntityManager(EntityManager entityManager) {
        this.entityManager = entityManager;
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
        String ejbdelUpdate =
            "DELETE  FROM RuntimeTest1 r WHERE r.stringField = ?1";
        Query query = em.createQuery(ejbdelUpdate);

        query.setParameter(1, "runt1");
        int ok = query.executeUpdate();

        assertEquals(1, ok);

        endTx(em);
        endEm(em);
View Full Code Here
476
477
478
479
480
481
482
483
484
485
486
        EntityManager em = getEntityManagerProvider().get();
        Query nativeQuery = em.createNativeQuery("UPDATE hostcomponentstate SET current_state=?1 WHERE current_state in (?2, ?3)");
        nativeQuery.setParameter(1, "INSTALLED");
        nativeQuery.setParameter(2, "STOP_FAILED");
        nativeQuery.setParameter(3, "START_FAILED");
        nativeQuery.executeUpdate();
      }
    });

    // HostRoleCommand
    executeInTransaction(new Runnable() {
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.