title: Hibernate's setFirstResult() issue with Oracle jdbc driver
body: <p>I'm trying to do pagination with Hibernate using <code>setFirstResult()</code> and <code>setMaxResults()</code> but I'm not getting the expected results when setting the first result to 0.</p>
  
  <p>When doing the following:  </p>
  
  <pre><code>Query query = session.createQuery(queryString);  
  query.setFirstResult(0);  
  query.setMaxResults(30);  
  List list = query.list();  //list.size() returns 10  
  </code></pre>
  
  <p>but if I set the first result to 1 (or anything different than 0 for that matter):  </p>
  
  <pre><code>query.setFirstResult(1);  
  query.setMaxResults(30);  
  List list = query.list();  //list.size() returns 30  
  </code></pre>
  
  <p>I read this is a known bug in the jdbc driver, but I searched for a solution and I can't seem to find it. Has anyone run across anything similar and found a fix for it?</p>