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

    t.commit();
    s.close();


    s = openSession();
    t = s.beginTransaction();
    ScrollableResults sr = s.getNamedQuery("Item.nameDesc").scroll();
    assertTrue( sr.next() );
    i1 = (Item) sr.get(0);
    assertTrue( sr.next() );
    i2 = (Item) sr.get(0);
    assertTrue( Hibernate.isInitialized(i1) );
    assertTrue( Hibernate.isInitialized(i2) );
    assertEquals( i1.getName(), "foo" );
    assertEquals( i2.getName(), "bar" );
    assertFalse( sr.next() );
    s.delete(i1);
    s.delete(i2);
    t.commit();
    s.close();
    assertEquals( getSessions().getStatistics().getEntityFetchCount(), 0 );

View Full Code Here

Examples of org.hibernate.ScrollableResults

    s.flush();


    // both scroll() and iterate() cause the batcher to hold on
    // to resources, which should make aggresive-release not release
    // the connection (and thus cause serialization to fail)
    ScrollableResults sr = s.createQuery( "from Silly" ).scroll();


    try {
      SerializationHelper.serialize( s );
      fail( "Serialization allowed on connected session; or aggressive release released connection with open resources" );
    }
    catch( IllegalStateException e ) {
      // expected behavior
    }


    // getting the first row only because SybaseASE15Dialect throws NullPointerException
    // if data is not read before closing the ResultSet
    sr.next();


    // Closing the ScrollableResults does currently force the batcher to
    // aggressively release the connection
    sr.close();
    SerializationHelper.serialize( s );


    s.delete( silly );
    s.flush();

View Full Code Here

Examples of org.hibernate.ScrollableResults

    Session s = getSessionUnderTest();
    Silly silly = new Silly( "silly" );
    s.save( silly );
    s.flush();


    ScrollableResults sr = s.createQuery( "from Silly" ).scroll();
    assertTrue( sr.next() );
    Silly silly2 = ( Silly ) sr.get( 0 );
    assertEquals( silly, silly2 );
    sr.close();


    sr = s.createQuery( "from Silly" ).scroll();
    ScrollableResults sr2 = s.createQuery( "from Silly where name = 'silly'" ).scroll();


    assertTrue( sr.next() );
    assertEquals( silly, sr.get( 0 ) );
    assertTrue( sr2.next() );
    assertEquals( silly, sr2.get( 0 ) );


    sr.close();
    sr2.close();


    s.delete( silly );
    s.flush();


    release( s );

View Full Code Here

Examples of org.hibernate.ScrollableResults

    s = openSession();
    s.setCacheMode(CacheMode.IGNORE);
    t = s.beginTransaction();
    s.setDefaultReadOnly( true );
    int i = 0;
    ScrollableResults sr = s.createQuery("from DataPoint dp order by dp.x asc")
        .scroll(ScrollMode.FORWARD_ONLY);
    s.setDefaultReadOnly( false );
    while ( sr.next() ) {
      DataPoint dp = (DataPoint) sr.get(0);
      if (++i==50) {
        s.setReadOnly(dp, false);
      }
      dp.setDescription("done!");
    }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    s = openSession();
    s.setCacheMode(CacheMode.IGNORE);
    t = s.beginTransaction();
    s.setDefaultReadOnly( true );
    int i = 0;
    ScrollableResults sr = s.createQuery("from DataPoint dp order by dp.x asc")
        .setReadOnly( false )
        .scroll(ScrollMode.FORWARD_ONLY);
    while ( sr.next() ) {
      DataPoint dp = (DataPoint) sr.get(0);
      if (++i==50) {
        s.setReadOnly(dp, true);
      }
      dp.setDescription("done!");
    }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    s = openSession();
    s.setCacheMode(CacheMode.IGNORE);
    t = s.beginTransaction();
    assertFalse( s.isDefaultReadOnly() );
    int i = 0;
    ScrollableResults sr = s.createQuery("from DataPoint dp order by dp.x asc")
        .setReadOnly( true )
        .scroll(ScrollMode.FORWARD_ONLY);
    while ( sr.next() ) {
      DataPoint dp = (DataPoint) sr.get(0);
      if (++i==50) {
        s.setReadOnly(dp, false);
      }
      dp.setDescription("done!");
    }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    t = s.beginTransaction();
    s.setDefaultReadOnly( false );
    int i = 0;
    Query query = s.createQuery("from DataPoint dp order by dp.x asc");
    s.setDefaultReadOnly( true );
    ScrollableResults sr = query.scroll(ScrollMode.FORWARD_ONLY);
    s.setDefaultReadOnly( false );
    while ( sr.next() ) {
      DataPoint dp = (DataPoint) sr.get(0);
      if (++i==50) {
        s.setReadOnly(dp, false);
      }
      dp.setDescription("done!");
    }

View Full Code Here

Examples of org.hibernate.ScrollableResults

    assertFalse( query.isReadOnly() );
    query.setReadOnly( true );
    assertTrue( query.isReadOnly() );
    s.setDefaultReadOnly( false );
    assertFalse( s.isDefaultReadOnly() );
    ScrollableResults sr = query.scroll(ScrollMode.FORWARD_ONLY);
    assertFalse( s.isDefaultReadOnly() );
    assertTrue( query.isReadOnly() );
    DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );    
    assertFalse( s.isReadOnly( dpLast ) );
    query.setReadOnly( false );
    assertFalse( query.isReadOnly() );
    int nExpectedChanges = 0;
    assertFalse( s.isDefaultReadOnly() );
    while ( sr.next() ) {
      assertFalse( s.isDefaultReadOnly() );
      dp = (DataPoint) sr.get(0);
      if ( dp.getId() == dpLast.getId() ) {
        //dpLast existed in the session before executing the read-only query
        assertFalse( s.isReadOnly( dp ) );
      }
      else {

View Full Code Here

Examples of org.hibernate.ScrollableResults

    assertTrue( query.isReadOnly() );
    query.setReadOnly( false );
    assertFalse( query.isReadOnly() );
    s.setDefaultReadOnly( true );
    assertTrue( s.isDefaultReadOnly() );
    ScrollableResults sr = query.scroll(ScrollMode.FORWARD_ONLY);
    assertFalse( query.isReadOnly() );
    DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );
    assertTrue( s.isReadOnly( dpLast ) );
    query.setReadOnly( true );
    assertTrue( query.isReadOnly() );
    int nExpectedChanges = 0;
    assertTrue( s.isDefaultReadOnly() );
    while ( sr.next() ) {
      assertTrue( s.isDefaultReadOnly() );
      dp = (DataPoint) sr.get(0);
      if ( dp.getId() == dpLast.getId() ) {
        //dpLast existed in the session before executing the read-only query
        assertTrue( s.isReadOnly( dp ) );
      }
      else {

View Full Code Here

Examples of org.hibernate.ScrollableResults

    t = s.beginTransaction();
    DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class,  dp.getId() );
    assertFalse( s.isReadOnly( dpLast ) );
    s.setDefaultReadOnly( true );
    int i = 0;
    ScrollableResults sr = s.createQuery("from DataPoint dp order by dp.x asc")
        .scroll(ScrollMode.FORWARD_ONLY);
    s.setDefaultReadOnly( false );
    int nExpectedChanges = 0;
    while ( sr.next() ) {
      dp = (DataPoint) sr.get(0);
      if ( dp.getId() == dpLast.getId() ) {
        //dpLast existed in the session before executing the read-only query
        assertFalse( s.isReadOnly( dp ) );
      }
      else {

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.