Package org.hibernate

Examples of org.hibernate.ScrollableResults.last()

98
99
100
101
102
103
104
105
106
107
108
      .setFetchSize( 10 )
      .scroll();
    scrollableResults.beforeFirst();
    // initial position should be -1 as in Hibernate Core
    assertEquals( -1, scrollableResults.getRowNumber() );
    assertTrue( scrollableResults.last() );
    int position = scrollableResults.getRowNumber();
    assertEquals( 323, position );
    while ( scrollableResults.previous() ) {
      AlternateBook book = (AlternateBook) scrollableResults.get()[0];
      assertEquals( --position, book.getId().intValue() );
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
 
  private int getResultNumberUsingScrollableResults(org.hibernate.Query hibernateQuery, Session session) {
    int resultNumber = 0;
    logger.debug("Scrolling query " + statement.getQueryString() + " ...");
    ScrollableResults scrollableResults = hibernateQuery.scroll();
    scrollableResults.last();
    logger.debug("Scrolled query " + statement.getQueryString());
    resultNumber = scrollableResults.getRowNumber() + 1; // Hibernate ScrollableResults row number starts with 0
    logger.debug("Number of fetched records: " + resultNumber + " for query " + statement.getQueryString());
    resultNumber = resultNumber < 0? 0: resultNumber;
    return resultNumber;
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
    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() );
View Full Code Here
3331
3332
3333
3334
3335
3336
3337
3338
3339
3340
3341
      Object f4 = iter.get(0);
      assertTrue( f4!=null );
      assertTrue( !iter.next() );
      assertTrue( iter.first() );
      assertTrue( iter.get(0)==f1 );
      assertTrue( iter.last() );
      assertTrue( iter.get(0)==f4 );
      assertTrue( iter.previous() );
      txn.commit();
      s.close();
View Full Code Here
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
      f4 = iter.get(0);
      assertTrue( f4!=null );
      assertTrue( !iter.next() );
      assertTrue( iter.first() );
      assertTrue( iter.get(0)==f1 );
      assertTrue( iter.last() );
      assertTrue( iter.get(0)==f4 );
      assertTrue( iter.previous() );
      assertTrue( s.delete("from Foo")==4 );
      s.flush();
      assertTrue( s.find("from java.lang.Object").size()==0 );
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    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++ ) {
View Full Code Here
449
450
451
452
453
454
455
456
457
458
459
    results = hibQuery.scroll();
    results.first();
    Object[] result = results.get();
    assertEquals(1004, result[0]);

    results.last();
    result = results.get();
    assertEquals(1004, result[0]);

    //cleanup
    for (Object element : s.createQuery( "from " + Employee.class.getName() ).list()) s.delete( element );
View Full Code Here
3331
3332
3333
3334
3335
3336
3337
3338
3339
3340
3341
    Object f4 = iter.get(0);
    assertTrue( f4!=null );
    assertTrue( !iter.next() );
    assertTrue( iter.first() );
    assertTrue( iter.get(0)==f1 );
    assertTrue( iter.last() );
    assertTrue( iter.get(0)==f4 );
    assertTrue( iter.previous() );
    txn.commit();
    s.close();
View Full Code Here
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
    f4 = iter.get(0);
    assertTrue( f4!=null );
    assertTrue( !iter.next() );
    assertTrue( iter.first() );
    assertTrue( iter.get(0)==f1 );
    assertTrue( iter.last() );
    assertTrue( iter.get(0)==f4 );
    assertTrue( iter.previous() );
    assertTrue( s.delete("from Foo")==4 );
    s.flush();
    assertTrue( s.find("from java.lang.Object").size()==0 );
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    projections.next();
    Object[] projection = projections.get();
    checkProjectionFirst( projection, s );
    assertTrue( projections.isFirst() );

    projections.last();
    projection = projections.get();
    checkProjectionLast( projection, s );
    assertTrue( projections.isLast() );

    projections.next();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.