Examples of ScrollableResults

com.dotcms.repackage.net.sf.hibernate.ScrollableResults
net.sf.hibernate.ScrollableResults
org.hibernate.ScrollableResults
A result iterator that allows moving around within the results by arbitrary increments. The Query / ScrollableResults pattern is very similar to the JDBC PreparedStatement/ ResultSet pattern and the semantics of methods of this interface are similar to the similarly named methods on ResultSet.

Contrary to JDBC, columns of results are numbered from zero. @see Query#scroll() @author Gavin King

Examples of org.hibernate.ScrollableResults


    s = openSession();
    s.setCacheMode( CacheMode.IGNORE );
    t = s.beginTransaction();
    int i = 0;
    ScrollableResults sr = s.createQuery( "from DataPoint dp order by dp.x asc" )
        .scroll( ScrollMode.FORWARD_ONLY );
    while ( sr.next() ) {
      DataPoint dp = ( DataPoint ) sr.get( 0 );
      dp.setDescription( "done!" );
      if ( ++i % 20 == 0 ) {
        s.flush();
        s.clear();
      }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    // first, as a control, make sure there are no results
    int size = s.createQuery( query ).setString( "desc", "root%" ).list().size();
    assertEquals( 0, size );


    // now get the scrollable results
    ScrollableResults results = s.createQuery( query ).setString( "desc", "root%" ).scroll();


    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );


    assertFalse( results.next() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );


    assertFalse( results.previous() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );


    results.beforeFirst();
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.next() );


    assertFalse( results.first() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.next() );


    results.afterLast();
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.next() );


    assertFalse( results.last() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.next() );


    for ( int i=1; i<3; i++ ) {
      assertFalse( results.scroll( i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );


      assertFalse( results.scroll( - i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );


      assertFalse( results.setRowNumber( i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );


      assertFalse( results.setRowNumber( - i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );
    }


    txn.commit();
    s.close();
  }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    assertNotNull(s
            .createQuery( "from Animal a left join fetch a.offspring where a.description like :desc order by a.id" )
            .setString( "desc", "root%" )
            .uniqueResult() );


    ScrollableResults results = s
            .createQuery( "from Animal a left join fetch a.offspring where a.description like :desc order by a.id" )
            .setString( "desc", "root%" )
            .scroll();


    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.previous() );    


    assertTrue( results.next() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );


    assertFalse( results.next() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );


    assertTrue( results.previous() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );


    assertFalse( results.previous() );
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );


    assertTrue( results.next() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );


    results.beforeFirst();
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.previous() );


    assertTrue( results.first() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );
    assertFalse( results.next() );


    results.afterLast();
    assertFalse( results.isFirst() );
    assertFalse( results.isLast() );
    assertFalse( results.next() );


    assertTrue( results.last() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );
    assertFalse( results.next() );


    assertTrue( results.first() );
    assertTrue( results.isFirst() );
    assertTrue( results.isLast() );    


    for ( int i=1; i<3; i++ ) {
      assertTrue( results.setRowNumber( 1 ) );
      assertTrue( results.isFirst() );
      assertTrue( results.isLast() );


      assertFalse( results.scroll( i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );


      assertTrue( results.setRowNumber( 1 ) );
      assertTrue( results.isFirst() );
      assertTrue( results.isLast() );


      assertFalse( results.scroll( - i ) );
      assertFalse( results.isFirst() );
      assertFalse( results.isLast() );


      if ( i != 1 ) {
        assertFalse( results.setRowNumber( i ) );
        assertFalse( results.isFirst() );
        assertFalse( results.isLast() );


        assertFalse( results.setRowNumber( - i ) );
        assertFalse( results.isFirst() );
        assertFalse( results.isLast() );
      }
    }


    txn.commit();
    s.close();

View Full Code Here

0 1 2 3 4 5

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.