Examples of org.hibernate.Query.iterate()

org.hibernate.Query.iterate()
Return the query results as an Iterator. If the query contains multiple results pre row, the results are returned in an instance of Object[].

Entities returned as results are initialized on demand. The first SQL query returns identifiers only.
@return the result iterator @throws HibernateException

    Query f = s.createFilter( master.getDetails(), "select max(this.i) where this.i < :top and this.i>=:bottom" );
    f.setInteger("top", 100);
    f.setInteger("bottom", 0);
    assertEquals( f.iterate().next(), new Integer(12) );
    f.setInteger("top", 2);
    assertEquals( f.iterate().next(), new Integer(0) );


    f = s.createFilter( master.getDetails(), "select max(this.i) where this.i not in (:list)" );
    Collection coll = new ArrayList();
    coll.add( new Integer(-666) );
    coll.add( new Integer(22) );

View Full Code Here

    Collection coll = new ArrayList();
    coll.add( new Integer(-666) );
    coll.add( new Integer(22) );
    coll.add( new Integer(0) );
    f.setParameterList("list", coll);
    assertEquals( f.iterate().next(), new Integer(12) );


    f = s.createFilter( master.getDetails(), "select max(this.i) where this.i not in (:list) and this.master.name = :listy2" );
    f.setParameterList("list", coll);
    f.setParameter( "listy2", master.getName() );
    assertEquals( f.iterate().next(), new Integer(12) );

View Full Code Here

    assertEquals( f.iterate().next(), new Integer(12) );


    f = s.createFilter( master.getDetails(), "select max(this.i) where this.i not in (:list) and this.master.name = :listy2" );
    f.setParameterList("list", coll);
    f.setParameter( "listy2", master.getName() );
    assertEquals( f.iterate().next(), new Integer(12) );


    iter = master.getDetails().iterator();
    i=0;
    while ( iter.hasNext() ) {
      Detail d = (Detail) iter.next();

View Full Code Here

    }
    assertTrue(types[0] instanceof StringType);
    assertTrue(types[1] instanceof EntityType);
    assertTrue(types[2] instanceof StringType);
    assertTrue(types[3] instanceof DateType);
    Iterator iter = qu.iterate();
    int j = 0;
    while ( iter.hasNext() ) {
      j++;
      assertTrue( ( (Object[]) iter.next() )[1] instanceof Fum );
    }

View Full Code Here

    s.createFilter( fum.getQuxArray(), "where this.foo.id = ?" )
        .setParameter( 0, "fooid", Hibernate.STRING )
        .list();
    Query f = s.createFilter( fum.getQuxArray(), "where this.foo.id = :fooId" );
    f.setString("fooId", "abc");
    assertFalse( f.iterate().hasNext() );


    iter = s.createQuery( "from Fum fum where not fum.fum='FRIEND'" ).iterate();
    int i = 0;
    while ( iter.hasNext() ) {
      fum = (Fum) iter.next();

View Full Code Here

    public SyntaxChecker checkIterate() {
      Session s = openSession();
      s.beginTransaction();
      Query query = s.createQuery( hql );
      preparer.prepare( query );
      query.iterate();
      s.getTransaction().commit();
      s.close();
      return this;
    }
  }

View Full Code Here

    s.clear();
    Query q = s.createQuery("select distinct a.zoo from Animal a where a.zoo is not null");
    Type type = q.getReturnTypes()[0];
    assertTrue( type instanceof ManyToOneType );
    assertEquals( ( (ManyToOneType) type ).getAssociatedEntityName(), "org.hibernate.test.hql.Zoo" );
    zoo = (Zoo) q
      .iterate().next();
    assertEquals( zoo.getMammals().size(), 1 );
    assertEquals( zoo.getAnimals().size(), 1 );
    s.clear();
    s.delete(plat);

View Full Code Here

    assertTrue( q.list().size()==1 );
    q = s.createQuery("from Simple s where s.name = ? and upper(s.name) = ?");
    q.setString(1, "SIMPLE 1");
    q.setString(0, "Simple 1");
    q.setFirstResult(0);
    assertTrue( q.iterate().hasNext() );
    q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1");
    q.setParameter("bar", "SIMPLE 1");
    q.setString("foo", "Simple 1");
    q.setInteger("count", 69);
    q.setFirstResult(0);

View Full Code Here

    q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1");
    q.setParameter("bar", "SIMPLE 1");
    q.setString("foo", "Simple 1");
    q.setInteger("count", 69);
    q.setFirstResult(0);
    assertTrue( q.iterate().hasNext() );
    q = s.createQuery("select s.id from Simple s");
    q.setFirstResult(1);
    q.setMaxResults(2);
    iter = q.iterate();
    int i=0;

View Full Code Here

    q.setFirstResult(0);
    assertTrue( q.iterate().hasNext() );
    q = s.createQuery("select s.id from Simple s");
    q.setFirstResult(1);
    q.setMaxResults(2);
    iter = q.iterate();
    int i=0;
    while ( iter.hasNext() ) {
      assertTrue( iter.next() instanceof Long );
      i++;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.