herhor

List<Person> list = entityManger
  .createQuery("from Person p where p.status = :status", Person.class)
  .setParameter("status", clientStatus)
  .setHint("org.hibernate.fetchSize", "200")
  .getResultList();

herhor

List list = session
    .createQuery("from Person p where p.status = :status")
    .setString("status", clientStatus)
    .setFetchSize(200)
    .list();

herhor

[ INFO] HHH000412: Hibernate Core {4.3.5.Final}
[ INFO] HHH000021: Bytecode provider name : javassist
...
[DEBUG] Preparing to build session factory with filters : {}
[DEBUG] Creating new JDBC DriverManager Connection to [...]
...
[DEBUG] JDBC version : 11.1
[ INFO] HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
...
[DEBUG] JDBC3 getGeneratedKeys(): disabled

herhor

<logger name="org.hibernate">
  <level value="debug"/>
  <appender-ref ref="FILE"/>
</logger> 

herhor

<bean id="entityManagerFactory"
  class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
  p:dataSource-ref="dataSource"
  p:persistenceUnitName="pu">

  <property name="packagesToScan" value="..."/>
  <property name="jpaVendorAdapter">
    <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
  </property>

herhor

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  ...
  <property name="hibernateProperties">
    <props>
        <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
        <prop key="hibernate.jdbc.fetch_size">200</prop>
    </props>
  </property>
</bean>

herhor

public class MyJdbcDaoImpl extends JdbcDaoSupport implements MyJdbcDao {

  @Override
  protected void initTemplateConfig() {
    getJdbcTemplate().setFetchSize(200);
  }

  public MyResult loadAll() {
    final MyResult result = new MyResult();
    

herhor

JdbcTemplate jdbc = new JdbcTemplate(dataSource);
jdbc.setFetchSize(200);

jdbc.query("select a, b, c from table",

  new RowCallbackHandler() {
    @Override
    public void processRow(ResultSet rs) throws SQLException {
      ...
    }

herhor

PreparedStatement stmt = null;
ResultSet rs = null;

try {
  stmt = conn. prepareStatement("select a, b, c from table");
  stmt.setFetchSize(200);

  rs = stmt.executeQuery();
  while (rs.next()) {
    ...

herhor

JdbcTemplate jdbc = new JdbcTemplate(dataSource);
jdbc.setFetchSize(200);

jdbc.query("select a, b, c from table",
  new RowCallbackHandler() {
    @Override
    public void processRow(ResultSet rs) throws SQLException {
      ...
    }
  }