Hello
I want to read object returned from JPQL query in small chunks. I've use code like that:
q.setFirstResult(from);
q.setMaxResults(count);
q.getResultList()
in a loop until empty list returned. Unfortunately each iteration of loop executes select SQL query without LIMIT and OFFSET clauses simply ignoring unwanted rows.
Anybody knows how to force right behavior in this situation?
AS: Sun Java System Application Server 9.1_02 (build b04-fcs)
Database: PostgreSQL Version: 8.1.11
Driver: PostgreSQL Native Driver Version: PostgreSQL 8.3 JDBC4 with SSL (build 603)
Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/17/2008))
--
Jan Artysiewicz
[Message sent by forum member 'janartysiewicz' (janartysiewicz)]
http://forums.java.net/jive/thread.jspa?messageID=338022