Examples of org.hibernate.ScrollableResults.scroll()

org.hibernate.ScrollableResults.scroll()
Scroll an arbitrary number of locations @param i a positive (forward) or negative (backward) number of rows @return true if there is a result at the new location

    ScrollableResults results = hibQuery.scroll();
    results.beforeFirst();
    results.next();
    Object[] result = results.get();
    assertEquals( "incorrect entityInfo returned", 1000, result[0] );
    results.scroll( 2 );
    result = results.get();
    assertEquals( "incorrect entityInfo returned", 1003, result[0] );
    // check cache addition
    results.next();
    result = results.get();

View Full Code Here

    // check cache addition
    results.next();
    result = results.get();
    assertEquals( "incorrect entityInfo returned", 1004, result[0] );


    results.scroll( -2 );
    result = results.get();
    assertEquals( "incorrect entityInfo returned", 1002, result[0] );


    //cleanup
    for (Object element : s.createQuery( "from " + Employee.class.getName() ).list()) s.delete( element );

View Full Code Here

    results.beforeFirst();
    results.next();
    Object[] result = results.get();
    assertEquals( "incorrect entityInfo returned", 1002, result[0] );


    results.scroll( 2 );
    result = results.get();
    assertEquals( "incorrect entityInfo returned", 1004, result[0] );


    results.next();
    result = results.get();

View Full Code Here


    results.next();
    result = results.get();
    assertNull( result );


    results.scroll( -8 );
    result = results.get();
    assertNull( result );


    // And test a bad forward scroll.
    results.scroll( 10 );

View Full Code Here

    results.scroll( -8 );
    result = results.get();
    assertNull( result );


    // And test a bad forward scroll.
    results.scroll( 10 );
    result = results.get();
    assertNull( result );


    //cleanup
    for (Object element : s.createQuery( "from " + Employee.class.getName() ).list()) s.delete( element );

View Full Code Here

    results.afterLast();
    results.previous();
    assertTrue("afterLast() pointer incorrect", results.isLast());


    // Let's see if a bad reverse scroll screws things up
    results.scroll( -8 );
    results.next();
    assertTrue("large negative scroll() pointer incorrect", results.isFirst());


    // And test a bad forward scroll.
    results.scroll( 10 );

View Full Code Here

    results.scroll( -8 );
    results.next();
    assertTrue("large negative scroll() pointer incorrect", results.isFirst());


    // And test a bad forward scroll.
    results.scroll( 10 );
    results.previous();
    assertTrue("large positive scroll() pointer incorrect", results.isLast());


    // Finally, let's test a REAL screwup.
    hibQuery.setFirstResult( 3 );

View Full Code Here

    result = hibQuery.scroll();
    assertEquals( 0, result.getRowNumber() );
    result.beforeFirst();
    assertEquals( true, result.next() );
    assertTrue( result.isFirst() );
    assertTrue( result.scroll( 1 ) );
    assertTrue( result.isLast() );
    assertFalse( result.scroll( 1 ) );
    result.beforeFirst();
    while ( result.next() ) {
      s.delete( result.get()[0] );

View Full Code Here

    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) );
    Object f1 = iter.get(0);
    iter.next();

View Full Code Here

    ScrollableResults iter = query.scroll();
    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    FooProxy f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( iter.scroll(-1) );
    Object f1 = iter.get(0);
    iter.next();
    assertTrue( f1!=null && iter.get(0)==f2 );
    iter.getInteger(1);

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.