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


    s.delete(bar);


    if ( getDialect() instanceof DB2Dialect || getDialect() instanceof PostgreSQLDialect ) {
      s.iterate("select one from One one join one.manies many group by one order by count(many)");
      s.iterate("select one from One one join one.manies many group by one having count(many) < 5");
    }


    s.find("from One one join one.manies many where one.id = 1 and many.id = 1");
    s.iterate("select one.id, elements(one.manies) from One one");
    s.iterate("select max( elements(one.manies) ) from One one");

View Full Code Here

      s.iterate("select one from One one join one.manies many group by one order by count(many)");
      s.iterate("select one from One one join one.manies many group by one having count(many) < 5");
    }


    s.find("from One one join one.manies many where one.id = 1 and many.id = 1");
    s.iterate("select one.id, elements(one.manies) from One one");
    s.iterate("select max( elements(one.manies) ) from One one");
    s.find("select one, elements(one.manies) from One one");
    //s.iterate("select one, max( elements(one.manies) ) from One one group by one");
    Iterator iter = s.iterate("select elements(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( iter.next()==null && iter.next()==foos[1] && !iter.hasNext() );

View Full Code Here

      s.iterate("select one from One one join one.manies many group by one having count(many) < 5");
    }


    s.find("from One one join one.manies many where one.id = 1 and many.id = 1");
    s.iterate("select one.id, elements(one.manies) from One one");
    s.iterate("select max( elements(one.manies) ) from One one");
    s.find("select one, elements(one.manies) from One one");
    //s.iterate("select one, max( elements(one.manies) ) from One one group by one");
    Iterator iter = s.iterate("select elements(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( iter.next()==null && iter.next()==foos[1] && !iter.hasNext() );
    assertTrue( iter.next()==foos[1] && !iter.hasNext() );

View Full Code Here

    s.find("from One one join one.manies many where one.id = 1 and many.id = 1");
    s.iterate("select one.id, elements(one.manies) from One one");
    s.iterate("select max( elements(one.manies) ) from One one");
    s.find("select one, elements(one.manies) from One one");
    //s.iterate("select one, max( elements(one.manies) ) from One one group by one");
    Iterator iter = s.iterate("select elements(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( iter.next()==null && iter.next()==foos[1] && !iter.hasNext() );
    assertTrue( iter.next()==foos[1] && !iter.hasNext() );
    list = s.find("select elements(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( list.size()==2 );
    assertTrue( list.size()==1 );

View Full Code Here

    //WAS: assertTrue( iter.next()==null && iter.next()==foos[1] && !iter.hasNext() );
    assertTrue( iter.next()==foos[1] && !iter.hasNext() );
    list = s.find("select elements(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( list.size()==2 );
    assertTrue( list.size()==1 );
    iter = s.iterate("select indices(baz.fooArray) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING);
    //WAS: assertTrue( iter.next().equals( new Integer(0) ) && iter.next().equals( new Integer(1) ) && !iter.hasNext() );
    assertTrue( iter.next().equals( new Integer(1) ) && !iter.hasNext() );


    //assertTrue( s.iterate("select max( elements(baz.timeArray) ) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING).next() instanceof Time );
    //assertTrue( s.iterate("select max( elements(baz.stringSet) ) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING).next().equals("foo") );

View Full Code Here

    //WAS: assertTrue( iter.next().equals( new Integer(0) ) && iter.next().equals( new Integer(1) ) && !iter.hasNext() );
    assertTrue( iter.next().equals( new Integer(1) ) && !iter.hasNext() );


    //assertTrue( s.iterate("select max( elements(baz.timeArray) ) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING).next() instanceof Time );
    //assertTrue( s.iterate("select max( elements(baz.stringSet) ) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING).next().equals("foo") );
    assertTrue( s.iterate("select size(baz.stringSet) from Baz baz where baz.id=?", baz.getCode(), Hibernate.STRING).next().equals( new Integer(3) ) );
    //s.find("from One one where sum one.manies.elements =0 or 1 = min one.manies.elements");


    s.find("from Foo foo where foo.component.glarch.id is not null");


    //iter = s.iterate("select baz, max( elements(baz.timeArray) ) from Baz baz group by baz");

View Full Code Here


    s.find("from Foo foo where foo.component.glarch.id is not null");


    //iter = s.iterate("select baz, max( elements(baz.timeArray) ) from Baz baz group by baz");
    //while ( iter.hasNext() ) { Object[] arr = (Object[]) iter.next(); System.out.println( arr[0] + " " + arr[1] ); }
    iter = s.iterate("select baz, size(baz.stringSet), count( distinct elements(baz.stringSet) ), max( elements(baz.stringSet) ) from Baz baz group by baz");
    while ( iter.hasNext() ) { Object[] arr = (Object[]) iter.next(); System.out.println( arr[0] + " " + arr[1] + " " + arr[2] + " " + arr[3] ); }
    
    s.delete(baz);
    s.delete(baz2);
    s.delete( foos[1] );

View Full Code Here

    Baz baz = new Baz();
    baz.setDefaults();
    s.save(baz);
    s.flush();
    baz.getStringArray()[0] = "a new value";
    Iterator iter = s.iterate("from Baz baz");//no flush
    assertTrue( iter.next()==baz );
    iter = s.iterate("select elements(baz.stringArray) from Baz baz");
    boolean found = false;
    while ( iter.hasNext() ) {
      if ( iter.next().equals("a new value") ) found = true;

View Full Code Here

    s.save(baz);
    s.flush();
    baz.getStringArray()[0] = "a new value";
    Iterator iter = s.iterate("from Baz baz");//no flush
    assertTrue( iter.next()==baz );
    iter = s.iterate("select elements(baz.stringArray) from Baz baz");
    boolean found = false;
    while ( iter.hasNext() ) {
      if ( iter.next().equals("a new value") ) found = true;
    }
    assertTrue(found);

View Full Code Here

    while ( iter.hasNext() ) {
      if ( iter.next().equals("a new value") ) found = true;
    }
    assertTrue(found);
    baz.setStringArray(null);
    s.iterate("from Baz baz"); //no flush
    iter = s.iterate("select elements(baz.stringArray) from Baz baz");
    assertTrue( !iter.hasNext() );
    baz.getStringList().add("1E1");
    iter = s.iterate("from Foo foo");//no flush
    assertTrue( !iter.hasNext() );

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.