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

                // minimize cache
                .setCacheMode(CacheMode.IGNORE)
                // limit fetch size
                .setFetchSize(fetchBatchSize);
        log.info("setting scroll mode to FORWARD_ONLY for " + entityName);
        ScrollableResults scroll = q.scroll(ScrollMode.FORWARD_ONLY);


        int batch = 0;
        while (scroll.next())
        {
            batch++;

View Full Code Here

    public final void givenUsingTheScrollableApi_whenRetrievingPaginatedData_thenCorrect() {
        final int pageSize = 10;
        final String hql = "FROM Foo f order by f.name";
        final Query query = session.createQuery(hql);


        final ScrollableResults resultScroll = query.scroll(ScrollMode.FORWARD_ONLY);


        // resultScroll.last();
        // final int totalResults = resultScroll.getRowNumber() + 1;


        resultScroll.first();

View Full Code Here

        for (int i = 0; i < queryArgs.length; i++) {
            Object arg = queryArgs[i];
            setParameter(namedQuery, i, arg);
        }
        namedQuery.setLockMode( "obj", lockMode );
        return (ScrollableResults) namedQuery.scroll();
    }


    @SuppressWarnings("unchecked")
    public T executeUnique(Method method, final Object[] queryArgs, LockMode lockMode) {
        final String queryName = queryNameFromMethod(method);

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.