Package org.hibernate

Examples of org.hibernate.ScrollableResults

67
68
69
70
71
72
73
74
75
76
77
78
79
80
  public void testScrollOrderParentDesc() {
    try {
      insertTestData();
      Session s = openSession();
      ScrollableResults results = s.createQuery( QUERY + " order by p.name desc" ).scroll();
      List list = new ArrayList();
      while ( results.next() ) {
        list.add( results.get( 0 ) );
      }
      assertResultFromAllUsers( list );
      s.close();
    }
    finally {
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
  public void testScrollOrderParentAscChildrenAsc() {
    try {
      insertTestData();
      Session s = openSession();
      ScrollableResults results = s.createQuery( QUERY + " order by p.name asc, c.name asc" ).scroll();
      List list = new ArrayList();
      while ( results.next() ) {
        list.add( results.get( 0 ) );
      }
      assertResultFromAllUsers( list );
      s.close();
    }
    finally {
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
  public void testScrollOrderParentAscChildrenDesc() {
    try {
      insertTestData();
      Session s = openSession();
      ScrollableResults results = s.createQuery( QUERY + " order by p.name asc, c.name desc" ).scroll();
      List list = new ArrayList();
      while ( results.next() ) {
        list.add( results.get( 0 ) );
      }
      assertResultFromAllUsers( list );
      s.close();
    }
    finally {
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
    assertEquals( "unexpected execution count", 2, continentStats.getExecutionCount() );
    // but should not effect the cumulative row count
    assertEquals( "unexpected row count", results, continentStats.getExecutionRowCount() );
    Hibernate.close( itr );

    ScrollableResults scrollableResults = s.createQuery( continents ).scroll();
    // same deal with scroll()...
    assertEquals( "unexpected execution count", 3, continentStats.getExecutionCount() );
    assertEquals( "unexpected row count", results, continentStats.getExecutionRowCount() );
    // scroll through data because SybaseASE15Dialect throws NullPointerException
    // if data is not read before closing the ResultSet
    while ( scrollableResults.next() ) {
      // do nothing
    }
    scrollableResults.close();
    tx.commit();
    s.close();

    // explicitly check that statistics for "split queries" get collected
    // under the original query
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
    DummyTransactionManager.INSTANCE.getTransaction().commit();

    // First, test partially scrolling the result with out closing
    DummyTransactionManager.INSTANCE.begin();
    s = getSessions().getCurrentSession();
    ScrollableResults results = s.createQuery( "from Item" ).scroll();
    results.next();
    DummyTransactionManager.INSTANCE.getTransaction().commit();

    // Next, test partially scrolling the result with closing
    DummyTransactionManager.INSTANCE.begin();
    s = getSessions().getCurrentSession();
    results = s.createQuery( "from Item" ).scroll();
    results.next();
    results.close();
    DummyTransactionManager.INSTANCE.getTransaction().commit();

    // Next, scroll the entire result (w/o closing)
    DummyTransactionManager.INSTANCE.begin();
    s = getSessions().getCurrentSession();
    results = s.createQuery( "from Item" ).scroll();
    while ( results.next() ) {
      // do nothing
    }

    DummyTransactionManager.INSTANCE.getTransaction().commit();

    // Next, scroll the entire result (closing)
    DummyTransactionManager.INSTANCE.begin();
    s = getSessions().getCurrentSession();
    results = s.createQuery( "from Item" ).scroll();
    while ( results.next() ) {
      // do nothing
    }
    results.close();
    DummyTransactionManager.INSTANCE.getTransaction().commit();

    DummyTransactionManager.INSTANCE.begin();
    s = getSessions().getCurrentSession();
    s.createQuery( "delete from Item" ).executeUpdate();
View Full Code Here
477
478
479
480
481
482
483
484
485
486
487
488
489
490
    set.add("Simple 1"); set.add("foo");
    q.setParameterList( "name_list", set );
    q.setParameter("count", new Integer(-1) );
    assertTrue( q.list().size()==1 );

    ScrollableResults sr = s.createQuery("from Simple s").scroll();
    sr.next();
    sr.get(0);
    sr.close();

    s.delete(other);
    s.delete(simple);
    s.delete(min);
    t.commit();
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
   
    s = openSession();
    s.setCacheMode(CacheMode.IGNORE);
    t = s.beginTransaction();
    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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
    course.setCourseCode("HIB");
    course.setDescription("Hibernate Training");
    session.persist(course);
    session.flush();
    session.clear();
    ScrollableResults sr = session.createCriteria(Course.class).scroll();
    assertTrue( sr.next() );
    course = (Course) sr.get(0);
    assertNotNull(course);
    sr.close();
    session.delete(course);
   
    t.commit();
    session.close();
   
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
    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
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
    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
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
    • Copyright © 2018 www.massapicom. 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.