Package org.hibernate

Examples of org.hibernate.Query.uniqueResult()

62
63
64
65
66
67
68
69
70
71
72
    s.close();

    s = openSession();
    tx = s.beginTransaction();
    Query q = s.createQuery( "from Dog" );
    dog = (Dog) q.uniqueResult();
    assertEquals( "Colley", dog.thoroughbredName );
    tx.commit();
    s.close();
  }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
    s.close();

    s = openSession();
    tx = s.beginTransaction();
    Query q = s.createQuery( "from " + Death.class.getName() );
    death = (Death) q.uniqueResult();
    assertEquals( "Well, haven't seen it", death.howDoesItHappen );
    s.delete( death );
    tx.commit();
    s.close();
  }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    tx.commit();
    s.clear();
   
    tx = s.beginTransaction();
    Query q = s.createQuery( "from Product p" );
    q.uniqueResult();
    tx.commit();
    s.close();
  }

}
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    tx.commit();
    s.close();
    s=openSession();
    tx=s.beginTransaction();
    Query q=s.createQuery( "select round(p.price,1) from Product p" );
    Object o=q.uniqueResult();
    assertEquals( BigDecimal.class , o.getClass() );
    assertEquals( BigDecimal.valueOf( 1.3 ) , o );
    tx.commit();
    s.close();
   
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
      query.list();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in (:names)", "category", Category.class);
      String[] str = new String[] { "WannaBeFound", "NotThere" };
      query.setParameterList("names", str);
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in :names", "category", Category.class);
      query.setParameterList("names", str);
      query.uniqueResult();

View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
      query.setParameterList("names", str);
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in :names", "category", Category.class);
      query.setParameterList("names", str);
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in (:names)", "category", Category.class);
      str = new String[] { "WannaBeFound" };
      query.setParameterList("names", str);
      query.uniqueResult();
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in (:names)", "category", Category.class);
      str = new String[] { "WannaBeFound" };
      query.setParameterList("names", str);
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in :names", "category", Category.class);
      query.setParameterList("names", str);     
      query.uniqueResult();

View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
      query.setParameterList("names", str);
      query.uniqueResult();

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in :names", "category", Category.class);
      query.setParameterList("names", str);     
      query.uniqueResult();

      session.connection().commit();
      session.close();
     
     
View Full Code Here
639
640
641
642
643
644
645
646
647
648
649
        // having a composite id with one property named id works since the map used by sqlloader to map names to properties handles it.
        Query query = s.createSQLQuery("select system as {c.system}, id as {c.id}, name as {c.name}, foo as {c.composite.foo}, bar as {c.composite.bar} from CompositeIdId where system=? and id=?", "c", CompositeIdId.class);
        query.setString(0, "c64");
        query.setString(1, "games");

        CompositeIdId id2 = (CompositeIdId) query.uniqueResult();
        check(id, id2);

        s.flush();
        s.connection().commit();
        s.close();
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
    s = openSession();
    tx = s.beginTransaction();
    Query q = s.createQuery( "from Flight f where f.departureDate = :departureDate" );
    q.setParameter( "departureDate", airFrance.getDepartureDate(), Hibernate.DATE );
    Flight copyAirFrance = (Flight) q.uniqueResult();
    assertNotNull( copyAirFrance );
    assertEquals(
        df.format(new Date( 05, 06, 21 )).toString(),
        df.format(copyAirFrance.getDepartureDate()).toString()
    );
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.