setFetchSize « Fetch « JPA Q&A

  1. JPA Q&A
  2. Fetch
  3. setFetchSize




1. setFetchSize Ignored    forum.hibernate.org

2. setFetchSize() is not working for my code    forum.hibernate.org

Criteria cri = session.createCriteria(Instrument.class); instrument = cri.add(Restrictions.like("shortName", "%" +description + "%").ignoreCase()) .setFetchSize(3) ...

3. setFirstResult(0) and setFetchSize(10) didn't work!    forum.hibernate.org

Hi Hibernators, I'm not sure if this is hibernate's bug or my mistake :-( Pls see next: HQL: Code: select distinct p from Product as p left outer join p.keywords as keyword where 1=1 and ( keyword.value like :keyword or p.name like :prodNameKeyword ) Database: MSSQL2000 sp4 JDBC driver: JTDS version 1.2 Hibernate: version 3.2.3ga and 3.2.5 ga For above situction, ...