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( c.getSubcategories().get(0)!=null && c.getSubcategories().get(1)!=null );
    List list = ( (Category) c.getSubcategories().get(1) ).getSubcategories();
    assertTrue( list.get(1)!=null && list.get(0)==null );


    assertTrue(
      s.iterate("from Category c where c.name = org.hibernate.test.legacy.Category.ROOT_CATEGORY").hasNext()
    );
    s.delete(c);
    s.flush();
    s.connection().commit();
    s.close();

View Full Code Here


  public void testCollectionQuery() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof MckoiDialect) ) {
      s.iterate("FROM Master m WHERE NOT EXISTS ( FROM m.details d WHERE NOT d.i=5 )");
      s.iterate("FROM Master m WHERE NOT 5 IN ( SELECT d.i FROM m.details AS d )");
    }
    s.iterate("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m.id FROM Master AS m JOIN m.details AS d WHERE d.i=5");

View Full Code Here

  public void testCollectionQuery() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof MckoiDialect) ) {
      s.iterate("FROM Master m WHERE NOT EXISTS ( FROM m.details d WHERE NOT d.i=5 )");
      s.iterate("FROM Master m WHERE NOT 5 IN ( SELECT d.i FROM m.details AS d )");
    }
    s.iterate("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m.id FROM Master AS m JOIN m.details AS d WHERE d.i=5");
    t.commit();

View Full Code Here

    Transaction t = s.beginTransaction();
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof MckoiDialect) ) {
      s.iterate("FROM Master m WHERE NOT EXISTS ( FROM m.details d WHERE NOT d.i=5 )");
      s.iterate("FROM Master m WHERE NOT 5 IN ( SELECT d.i FROM m.details AS d )");
    }
    s.iterate("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m FROM Master m JOIN m.details d WHERE d.i=5");
    s.find("SELECT m.id FROM Master AS m JOIN m.details AS d WHERE d.i=5");
    t.commit();
    s.close();
  }

View Full Code Here

    s.save( new Holder("ice cube") );


    assertTrue( s.find("from java.lang.Object as o").size()==15 );
    assertTrue( s.find("from Named").size()==7 );
    assertTrue( s.find("from Named n where n.name is not null").size()==4 );
    iter = s.iterate("from Named n");
    while ( iter.hasNext() ) {
      assertTrue( iter.next() instanceof Named );
    }


    s.save( new Holder("bar") );

View Full Code Here

    while ( iter.hasNext() ) {
      assertTrue( iter.next() instanceof Named );
    }


    s.save( new Holder("bar") );
    iter = s.iterate("from Named n0, Named n1 where n0.name = n1.name");
    int cnt = 0;
    while ( iter.hasNext() ) {
      Object[] row = (Object[]) iter.next();
      if ( row[0]!=row[1] ) cnt++;
    }

View Full Code Here


    Query qu = s.createQuery("from Named n where n.name = :name");
    qu.getReturnTypes();
    qu.getNamedParameters();


    iter = s.iterate("from java.lang.Object");
    int c = 0;
    while ( iter.hasNext() ) {
      iter.next();
      c++;
    }

View Full Code Here

      iter.next();
      c++;
    }
    assertTrue(c==16);


    s.iterate("select baz.code, min(baz.count) from Baz baz group by baz.code");


    iter = s.iterate("selecT baz from Baz baz where baz.stringDateMap['foo'] is not null or baz.stringDateMap['bar'] = ?", new Date(), Hibernate.DATE);
    assertFalse( iter.hasNext() );
    list = s.find("select baz from Baz baz where baz.stringDateMap['now'] is not null");
    assertTrue( list.size()==1 );

View Full Code Here

    }
    assertTrue(c==16);


    s.iterate("select baz.code, min(baz.count) from Baz baz group by baz.code");


    iter = s.iterate("selecT baz from Baz baz where baz.stringDateMap['foo'] is not null or baz.stringDateMap['bar'] = ?", new Date(), Hibernate.DATE);
    assertFalse( iter.hasNext() );
    list = s.find("select baz from Baz baz where baz.stringDateMap['now'] is not null");
    assertTrue( list.size()==1 );
    list = s.find("select baz from Baz baz where baz.stringDateMap['now'] is not null and baz.stringDateMap['big bang'] < baz.stringDateMap['now']");
    assertTrue( list.size()==1 );

View Full Code Here

    assertFalse( Hibernate.isInitialized( baz.getFees() ) );


    s = openSession();
    s.delete(baz);
    s.flush();
    assertFalse( s.iterate("from Fee").hasNext() );
    s.connection().commit();
    s.close();


    s = openSession();
    baz = new Baz();

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.