postgresql « Fetch « JPA Q&A

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




1. Query.setFetchSize seems not work for PostgreSQL    forum.hibernate.org

I am using pg74.216.jdbc3.jar driver to access PostgreSQL db. I try to select all records in a table which has 100,000 records to inspect the performance with setFetchSize() mechanism. My code like this: Code: public static void pagingSelect(int fetchSize, int displayCount){ Session session = ConnectionBean.getCurrentSession(); Query query = session.createQuery("from Customer"); query.setFetchSize(fetchSize); ...

2. How to store/retrieve image with Hibernate and Postgresql?    forum.hibernate.org