Examples of org.hibernate.Query.scroll()

org.hibernate.Query.scroll()
Return the query results as ScrollableResults. The scrollability of the returned results depends upon JDBC driver support for scrollable ResultSets.
@see ScrollableResults @return the result iterator @throws HibernateException

        if (i.intValue() >= 0)
        {
          pstmt.setTimeout(i.intValue());
        }
      }
      final ScrollableResults res = pstmt.scroll(ScrollMode.FORWARD_ONLY);
      return generateDefaultTableModel(res, pstmt.getReturnAliases());
    }
    catch (Exception e)
    {
      throw new ReportDataFactoryException("Failed at query: " + query, e);

View Full Code Here

        dbQuery.setDate("createdBefore", end);
      }
  
      dbQuery.setString("outFile", outFile.getAbsolutePath());
      
      dbQuery.scroll();
    } catch(RuntimeException e) {
      e.printStackTrace(System.out);
    } catch(Error er) {
      er.printStackTrace(System.out);
    } finally {

View Full Code Here

    public SyntaxChecker checkScroll() {
      Session s = openSession();
      s.beginTransaction();
      Query query = s.createQuery( hql );
      preparer.prepare( query );
      query.scroll();
      s.getTransaction().commit();
      s.close();
      return this;
    }

View Full Code Here

            query.setMaxResults(maxResults);
        }
        query.setFetchSize(30000);
        query.setReadOnly(true);
        query.setTimeout(TIMEOUT);
        results = query.scroll(ScrollMode.FORWARD_ONLY);


        lastMigratedItemIndex = -1;


        if (log.isDebugEnabled()) {
            if (maxResults >= 0) {

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);

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 );

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() );

View Full Code Here

    public SyntaxChecker checkScroll() {
      Session s = openSession();
      s.beginTransaction();
      Query query = s.createQuery( hql );
      preparer.prepare( query );
      query.scroll();
      s.getTransaction().commit();
      s.close();
      return this;
    }

View Full Code Here

      public List transformList(List arg0)
      {
        return arg0;
      }
    });
    ScrollableResults sr = q.scroll();
    sr.first();
    Object[] row = sr.get();
    assertEquals(1, row.length);
    Object obj = row[0];
    assertTrue(obj instanceof PartnerA);

View Full Code Here

    s.save( new Foo() );
    s.save( new Foo() );
    s.save( new Bar() );
    Query query = s.createQuery("select f, f.integer from Foo f");
    assertTrue( query.getReturnTypes().length==2 );
    ScrollableResults iter = query.scroll();
    assertTrue( iter.next() );
    assertTrue( iter.scroll(1) );
    FooProxy f2 = (FooProxy) iter.get()[0];
    assertTrue( f2!=null );
    assertTrue( iter.scroll(-1) );

View Full Code Here

0 1 2 3 4

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.