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.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

    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 = 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

      if ( foo==i.next() ) found = true;
    }
    assertTrue(found);


    baz.getFooArray()[0] = null;
    i = s.iterate("select foo from Baz baz join baz.fooArray foo");
    assertTrue( !i.hasNext() );
    baz.getFooArray()[0] = foo;
    i = s.iterate("select elements(baz.fooArray) from Baz baz");
    assertTrue( i.hasNext() );

View Full Code Here


    baz.getFooArray()[0] = null;
    i = s.iterate("select foo from Baz baz join baz.fooArray foo");
    assertTrue( !i.hasNext() );
    baz.getFooArray()[0] = foo;
    i = s.iterate("select elements(baz.fooArray) from Baz baz");
    assertTrue( i.hasNext() );


    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) && !(getDialect() instanceof InterbaseDialect) && !(getDialect() instanceof PointbaseDialect) && !(getDialect() instanceof SAPDBDialect) )  {
      baz.getFooArray()[0] = null;
      i = s.iterate(

View Full Code Here

    i = s.iterate("select elements(baz.fooArray) from Baz baz");
    assertTrue( i.hasNext() );


    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) && !(getDialect() instanceof InterbaseDialect) && !(getDialect() instanceof PointbaseDialect) && !(getDialect() instanceof SAPDBDialect) )  {
      baz.getFooArray()[0] = null;
      i = s.iterate(
        "from Baz baz where ? in elements(baz.fooArray)",
        foo, Hibernate.entity(Foo.class)
      );
      assertTrue( !i.hasNext() );
      baz.getFooArray()[0] = foo;

View Full Code Here

        "from Baz baz where ? in elements(baz.fooArray)",
        foo, Hibernate.entity(Foo.class)
      );
      assertTrue( !i.hasNext() );
      baz.getFooArray()[0] = foo;
      i = s.iterate(
        "select foo from Foo foo where foo in "
        + "(select elt from Baz baz join baz.fooArray elt)"
      );
      assertTrue( i.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.