ROWNUM « Oracle « JPA Q&A

  1. JPA Q&A
  2. Oracle
  3. ROWNUM




1. Hibernate(3.3.1.GA) + ORACLE(10.2.0.3) ROWNUM Exception    forum.hibernate.org

Hi everybody! I'm using Hibernate(3.3.1GA) with ojdbc14(10.2.0.3) on ORACLE(10.2.0.3) and get an unbelievable problem. I like using Named Parameters in HQL as it supports Collections to be set. But I found hibernate only return 10 rows even though I set query.setFirstResult(0);query.setMaxResults(20);, and I'm sure there are more then 10 rows in DB. More Detail: 1, Debug on line query.list();, query.selection displays ...