Examples of org.hibernate.classic.Session.iterate()

org.hibernate.classic.Session.iterate()
Execute a query and return the results in an iterator. If the query has multiple return values, values will be returned in an array of type Object[].

Entities returned as results are initialized on demand. The first SQL query returns identifiers only. So iterate() is usually a less efficient way to retrieve objects than find(). @deprecated use {@link #createQuery}. {@link Query#iterate} @param query the query string @return an iterator @throws HibernateException

    assertTrue( "count", ( (Long) rs.next() ).longValue()==2 );
    assertTrue( !rs.hasNext() );
    rs = s.iterate("select count(*), foo.int from Foo foo group by foo.int");
    assertTrue( "count(*) group by", ( (Object[]) rs.next() )[0].equals( new Long(3) ) );
    assertTrue( !rs.hasNext() );
    rs = s.iterate("select sum(foo.foo.int) from Foo foo");
    assertTrue( "sum", ( (Long) rs.next() ).longValue()==4 );
    assertTrue( !rs.hasNext() );
    rs = s.iterate("select count(foo) from Foo foo where foo.id=?", foo.getKey(), Hibernate.STRING);
    assertTrue( "id query count", ( (Long) rs.next() ).longValue()==1 );
    assertTrue( !rs.hasNext() );

View Full Code Here

    assertTrue( "count(*) group by", ( (Object[]) rs.next() )[0].equals( new Long(3) ) );
    assertTrue( !rs.hasNext() );
    rs = s.iterate("select sum(foo.foo.int) from Foo foo");
    assertTrue( "sum", ( (Long) rs.next() ).longValue()==4 );
    assertTrue( !rs.hasNext() );
    rs = s.iterate("select count(foo) from Foo foo where foo.id=?", foo.getKey(), Hibernate.STRING);
    assertTrue( "id query count", ( (Long) rs.next() ).longValue()==1 );
    assertTrue( !rs.hasNext() );


    list = s.find( "from Foo foo where foo.boolean = ?", new Boolean(true), Hibernate.BOOLEAN );

View Full Code Here

      //.setComment("projection test 2")
      .setCacheable(true)
      .list();
    assertTrue(list.size()==3);


    rs = s.iterate("select new Foo(fo.x) from Foo fo");
    assertTrue( "projection iterate (results)", rs.hasNext() );
    assertTrue( "projection iterate (return check)", Foo.class.isAssignableFrom( rs.next().getClass() ) );


    ScrollableResults sr = s.createQuery("select new Foo(fo.x) from Foo fo").scroll();
    assertTrue( "projection scroll (results)", sr.next() );

View Full Code Here

    assertTrue( "array of proxies", g.getProxyArray().length==2 );
    assertTrue( "array of proxies", g.getProxyArray()[0]!=null );
    assertTrue("deferred load test",g.getProxyArray()[1].getProxyArray()[0]==null );
    assertTrue("deferred load test",g.getProxyArray()[1].getProxyArray()[2]==g );
    assertTrue( "set of proxies", g.getProxySet().size()==2 );
    Iterator iter = s.iterate("from Glarch g");
    while ( iter.hasNext() ) {
      iter.next();
      iter.remove();
    }

View Full Code Here

    s.flush();
    s.connection().commit();
    s.close();


    s = openSession();
    Iterator it = s.iterate(
      "SELECT one FROM " +
      One.class.getName() +
      " one ORDER BY one.value ASC"
    );
    int count = 0;

View Full Code Here

    s.flush();
    s.connection().commit();
    s.close();


    s = openSession();
    it = s.iterate(
      "SELECT many.one FROM " +
      Many.class.getName() +
      " many ORDER BY many.one.value ASC, many.one.id"
    );
    count = 0;

View Full Code Here


    s = openSession();
    tx = s.beginTransaction();
    baz = (Baz) s.load(Baz.class, baz.getCode());
    baz.getStringArray()[0] = "bark";
    Iterator i = s.iterate("select elements(baz.stringArray) from Baz baz");
    boolean found = false;
    while ( i.hasNext() ) {
      if ( "bark".equals( i.next() ) ) found = true;
    }
    assertTrue(found);

View Full Code Here

    while ( i.hasNext() ) {
      if ( "bark".equals( i.next() ) ) found = true;
    }
    assertTrue(found);
    baz.setStringArray(null);
    i = s.iterate("select distinct elements(baz.stringArray) from Baz baz");
    assertTrue( !i.hasNext() );
    baz.setStringArray( new String[] { "foo", "bar" } );
    i = s.iterate("select elements(baz.stringArray) from Baz baz");
    assertTrue( i.hasNext() );

View Full Code Here

    assertTrue(found);
    baz.setStringArray(null);
    i = s.iterate("select distinct elements(baz.stringArray) from Baz baz");
    assertTrue( !i.hasNext() );
    baz.setStringArray( new String[] { "foo", "bar" } );
    i = s.iterate("select elements(baz.stringArray) from Baz baz");
    assertTrue( i.hasNext() );


    Foo foo = new Foo();
    s.save(foo);
    s.flush();

View Full Code Here

    Foo foo = new Foo();
    s.save(foo);
    s.flush();
    baz.setFooArray( new Foo[] {foo} );


    i = s.iterate("select foo from Baz baz join baz.fooArray foo");
    found = false;
    while ( i.hasNext() ) {
      if ( foo==i.next() ) found = true;
    }
    assertTrue(found);

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.