Package org.hibernate

Examples of org.hibernate.Session.createQuery()

39
40
41
42
43
44
45
46
47
48
49
  @Test
  public void canUpdateEntityReturnedByQuery() {
    Session session = sessions.openSession();
    Transaction transaction = session.beginTransaction();

    Query query = session.createQuery( "from Helicopter h where name = 'Sergio'" );
    Helicopter helicopter = (Helicopter) query.uniqueResult();
    assertThat( helicopter ).isNotNull();
    helicopter.setName( "Leonie" );

    transaction.commit();
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    transaction.commit();
    session.clear();
    transaction = session.beginTransaction();

    query = session.createQuery( "from Helicopter h where name = 'Leonie'" );
    helicopter = (Helicopter) query.uniqueResult();
    assertThat( helicopter ).isNotNull();

    transaction.commit();
    session.close();
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
    transaction.commit();
    session.clear();
    transaction = session.beginTransaction();

    // search and update
    StockItem loadedItem = (StockItem) session.createQuery( "from StockItem si" ).uniqueResult();
    assertNotNull( "Cannot load persisted object", loadedItem );
    loadedItem.setCount( 24 );

    transaction.commit();
    session.clear();
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    LeakingMongoDBDialect.queueSize = -1;

    session = openSession();
    session.beginTransaction();
    List<Helicopter> helicopters = session.createQuery( "FROM Helicopter" ).list();
    for ( Helicopter helicopter : helicopters ) {
      session.delete( helicopter );
    }
    session.getTransaction().commit();
    session.close();
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
  @After
  public void clean() {
    Session session = openSession();
    session.beginTransaction();
    List<Helicopter> helicopters = session.createQuery( "FROM Helicopter" ).list();
    for ( Helicopter helicopter : helicopters ) {
      session.delete( helicopter );
    }
    session.getTransaction().commit();
    session.close();
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
            Map metadata = sessionFactory.getAllClassMetadata();
            for (Object o : metadata.values()) {
                EntityPersister persister = (EntityPersister) o;
                String className = persister.getEntityName();
                log.debug("Trying select * from: " + className);
                Query q = session.createQuery("from " + className + " c");
                q.iterate();
                log.debug("ok: " + className);
            }
        } finally {
            session.close();
View Full Code Here
405
406
407
408
409
410
411
412
413
414
415
   }

   public Object findOne(ObjectQuery q) throws Exception
   {
      Session session = openSession();
      List l = session.createQuery(q.getHibernateQuery()).list();
      if (l.size() == 0)
      {
         return null;
      }
      else if (l.size() > 1)
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
    }

    @Override
    public List<SystemNotification> getActiveNotifications(User user) {
        Session session = sessionManager.getSession();
        List<SystemNotification> activeNotifications = session.createQuery(
                "select sn from " + SqlSystemNotification.class.getSimpleName() + " as sn where sn.startDate <= :now and (sn.endDate is null or sn.endDate > :now)")
                .setParameter("now", new Date())
                .list();
        LOGGER.debug("returning %d active system notifications", activeNotifications.size());
        return activeNotifications;
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    }

    @Override
    public List<SystemNotification> getFutureNotifications(Date maxDate, User user) {
       Session session = sessionManager.getSession();
        List<SystemNotification> futureNotifications = session.createQuery(
                "select sn from " + SqlSystemNotification.class.getSimpleName() + " as sn where sn.startDate > :now and sn.startDate < :maxDate")
                .setParameter("now", new Date())
                .setParameter("maxDate", maxDate)
                .list();
        LOGGER.debug("returning %d future system notifications", futureNotifications.size());
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    @Override
    public User findByUsername(String username) {
        username = formatUsername(username);
        Session session = sessionManager.getSession();
        List<SqlUser> users = session.createQuery("select user from " + SqlUser.class.getSimpleName() + " as user where user.username=:username")
                .setParameter("username", username)
                .list();
        if (users.size() == 0) {
            return null;
        } else if (users.size() > 1) {
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.