Examples of org.hibernate.Query.scroll()

org.hibernate.Query.scroll()
Return the query results as ScrollableResults. The scrollability of the returned results depends upon JDBC driver support for scrollable ResultSets.
@see ScrollableResults @return the result iterator @throws HibernateException


    s = openSession();
    txn = s.beginTransaction();
    query = s.createQuery("select f, f.integer from Foo f");
    assertTrue( query.getReturnTypes().length==2 );
    iter = query.scroll();
    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( f2.getString()!=null  && f2.getComponent().getImportantDates().length > 0 );

View Full Code Here

          } else {
            hhStreams.add(importGen);
          }
        }
        query.setBoolean("isImport", isImport);
        ScrollableResults hhData = query.scroll();
        try {
          if (!hhData.next()) {
            continue;
          }
          int i = 0;

View Full Code Here

          query.setTimestamp("to", finishDate.getDate());
        }
        if (targetChannel != null) {
          query.setEntity("targetChannel", targetChannel);
        }
        ScrollableResults hhData = query.scroll();
        HhStartDate groupStart = null;
        if (hhData.next()) {
          groupStart = (HhStartDate) hhData.get(0);
          if (targetChannel == null) {
            throw new UserException("There is no channel for the "

View Full Code Here

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

View Full Code Here

      s.save( new Foo() );
      s.save( new Foo() );
      s.save( new Bar() );
      Query query = s.createQuery("select f, f.integer from Foo f");
      assertTrue( query.getReturnTypes().length==2 );
      ScrollableResults iter = query.scroll();
      assertTrue( iter.next() );
      assertTrue( iter.scroll(1) );
      FooProxy f2 = (FooProxy) iter.get()[0];
      assertTrue( f2!=null );
      assertTrue( iter.scroll(-1) );

View Full Code Here


      s = openSession();
      txn = s.beginTransaction();
      query = s.createQuery("select f, f.integer from Foo f");
      assertTrue( query.getReturnTypes().length==2 );
      iter = query.scroll();
      assertTrue( iter.next() );
      assertTrue( iter.scroll(1) );
      f2 = (FooProxy) iter.get()[0];
      assertTrue( f2!=null );
      assertTrue( f2.getString()!=null  && f2.getComponent().getImportantDates().length > 0 );

View Full Code Here

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

View Full Code Here

    s.save( new Foo() );
    s.save( new Foo() );
    s.save( new Bar() );
    Query query = s.createQuery("select f, f.integer from Foo f");
    assertTrue( query.getReturnTypes().length==2 );
    ScrollableResults iter = query.scroll();
    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    FooProxy f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( iter.scroll(-1) );

View Full Code Here


    s = openSession();
    txn = s.beginTransaction();
    query = s.createQuery("select f, f.integer from Foo f");
    assertTrue( query.getReturnTypes().length==2 );
    iter = query.scroll();
    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( f2.getString()!=null  && f2.getComponent().getImportantDates().length > 0 );

View Full Code Here

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

View Full Code Here

0 1 2 3 4

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.