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

    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 );
    assertTrue( iter.scroll(-1) );
    f1 = iter.get(0);

View Full Code Here

    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( f2.getString()!=null  && f2.getComponent().getImportantDates().length > 0 );
    assertTrue( iter.scroll(-1) );
    f1 = iter.get(0);
    iter.next();
    assertTrue( f1!=null && iter.get(0)==f2 );
    iter.getInteger(1);

View Full Code Here

    f1 = iter.get(0);
    iter.next();
    assertTrue( f1!=null && iter.get(0)==f2 );
    iter.getInteger(1);


    assertTrue( !iter.scroll(100) );
    assertTrue( iter.first() );
    assertTrue( iter.scroll(3) );
    f4 = iter.get(0);
    assertTrue( f4!=null );
    assertTrue( !iter.next() );

View Full Code Here

    assertTrue( f1!=null && iter.get(0)==f2 );
    iter.getInteger(1);


    assertTrue( !iter.scroll(100) );
    assertTrue( iter.first() );
    assertTrue( iter.scroll(3) );
    f4 = iter.get(0);
    assertTrue( f4!=null );
    assertTrue( !iter.next() );
    assertTrue( iter.first() );
    assertTrue( iter.get(0)==f1 );

View Full Code Here

    result = hibQuery.scroll();
    assertEquals( -1, 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

    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] );
    }
    for (Object element : s.createQuery( "from java.lang.Object" ).list()) s.delete( element );

View Full Code Here

    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

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.