Package javax.persistence

Examples of javax.persistence.EntityTransaction

176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
    try {
     
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll;       

    } catch (Exception ex2) {
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
    try {
     
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll;       

    } catch (Exception ex2) {
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
     
      log.debug("Show HQL: "+hql);           
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      //log.debug("id: "+folderId);
     
      //query.setParameter("macomUserId", userId);
      //query.setParameter("messageFolder", folderId);
      //query
           
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
     
      //log.error((Long)ll.get(0));
      Long i = (Long)ll.get(0);
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
   */
  public boolean checkUserLogin(String DataValue) {
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Users as c where c.login = :DataValue AND c.deleted <> :deleted");
      query.setParameter("DataValue", DataValue);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();

      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (count != 0) {
        return false;
      }     
    } catch (Exception ex2) {
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
      String hql = "SELECT u FROM Users as u " +
          " where u.login = :login" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("login", login);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;     
    } catch (Exception e) {
      log.error("[getUserByAdressesId]",e);
    }
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
      String hql = "SELECT u FROM Users as u " +
          " where u.adresses.adresses_id = :adresses_id" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("adresses_id", adresses_id);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;     
    } catch (Exception e) {
      log.error("[getUserByAdressesId]",e);
    }
View Full Code Here
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
      String hql = "SELECT u FROM Users as u " +
          " where u.resethash = :resethash" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("resethash", hash);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (us!=null) {
        return us;   
      } else {
        return new Long(-5);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
   */
  public Long addUserSalutation(String titelname, long fieldvalues_id) {
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Salutations ti = new Salutations();
      ti.setName(titelname);
      ti.setDeleted("false");
      ti.setFieldvalues_id(fieldvalues_id);
      ti.setStarttime(new Date());
      ti = session.merge(ti);
      Long salutations_id = ti.getSalutations_id();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return salutations_id;
    } catch (Exception ex2) {
      log.error("[addUserSalutation]" ,ex2);
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
   */
  public List<Salutations> getUserSalutations(long language_id){
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Salutations> cq = cb.createQuery(Salutations.class);
      Root<Salutations> from = cq.from(Salutations.class);
      CriteriaQuery<Salutations> select = cq.select(from);
      TypedQuery<Salutations> q = session.createQuery(select);
      List<Salutations> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      for (Iterator it4 = ll.iterator(); it4.hasNext();) {
        Salutations ti = (Salutations) it4.next();
        ti.setLabel(Fieldmanagment.getInstance().getFieldByIdAndLanguage(ti.getFieldvalues_id(),language_id));
      }
View Full Code Here
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
          ")";
     
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("search", StringUtils.lowerCase(search));
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      log.info("selectMaxFromUsers"+(Long)ll.get(0));
      return (Long)ll.get(0);       
    } catch (Exception ex2) {
      log.error("[selectMaxFromUsers] ",ex2);
View Full Code Here
TOP

Related Classes of javax.persistence.EntityTransaction

  • br.com.caelum.vraptor.jpa.JPATransactionInterceptor
  • br.com.caelum.vraptor.util.jpa.JPATransactionInterceptor
  • br.gov.frameworkdemoiselle.transaction.JPATransaction
  • cave.nice.testMessage.data.DataManager
  • com.adaptrex.core.persistence.jpa.JPAModelInstance
  • com.adaptrex.core.persistence.jpa.JpaPersistence
  • com.appspot.finajjarane.framework.generic.GenericDaoImpl
  • com.darkhonor.rage.libs.dataaccess.CategoryDAO
  • com.darkhonor.rage.libs.dataaccess.CourseDAO
  • com.darkhonor.rage.libs.dataaccess.GradedEventDAO
    • Copyright © 2018 www.massapicom. 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.