Examples of org.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

    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

    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

    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

    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

    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

    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

    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

    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

    t = s.beginTransaction();
    s.setDefaultReadOnly( true );
    DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class,  dp.getId() );
    assertTrue( s.isReadOnly( dpLast ) );
    int i = 0;
    ScrollableResults sr = s.createQuery("from DataPoint dp order by dp.x asc")
        .setReadOnly(false)
        .scroll(ScrollMode.FORWARD_ONLY);
    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
        assertTrue( s.isReadOnly( dp ) );
      }
      else {

View Full Code Here

    assertTrue( "Incorrect result size", iter.hasNext() );
    obj = iter.next();
    assertTrue( "Incorrect return type", obj instanceof Map );
    assertEquals( "Incorrect return type", ( (Map) obj ).size(), 2 );


    ScrollableResults sr = session.createQuery( "select new map(an.description, an.bodyWeight) from Animal an" ).scroll();
    assertTrue( "Incorrect result size", sr.next() );
    obj = sr.get(0);
    assertTrue( "Incorrect return type", obj instanceof Map );
    assertEquals( "Incorrect return type", ( (Map) obj ).size(), 2 );
    sr.close();


    sr = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" ).scroll();
    assertTrue( "Incorrect result size", sr.next() );
    assertTrue( "Incorrect return type", sr.get(0) instanceof Animal );
    sr.close();


    // caching...
    QueryStatistics stats = getSessions().getStatistics().getQueryStatistics( "select new Animal(an.description, an.bodyWeight) from Animal an" );
    results = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" )
        .setCacheable( true )

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hibernate.ScrollableResults

ch.qos.logback.audit.persistent.AuditEventDAO

cn.org.rapid_framework.page.impl.Hibernate3Page

com.jeecms.cms.lucene.LuceneContentDaoImpl

com.jeecms.cms.staticpage.StaticPageDaoImpl

com.mysema.query.jpa.hibernate.AbstractHibernateQuery

com.mysema.query.jpa.HibernateHandler

com.mysema.query.jpa.IntegrationBase

it.eng.qbe.statement.hibernate.HQLDataSet

net.mlw.vlh.adapter.hibernate3.HibernateAdapter

net.sf.chellow.physical.SiteGroup

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.