Hi
I am running a Criteria.scroll() on postgresql on a DB containing 2M
records. The memory keeps increasing and finally it generates an
OutOfMemoryException. Please can you advice how to fix this.
*Postgresql DB version:* 8.4
*Postgresql Driver Used:* postgresql-8.4-701.jdbc4.jar
Some forum
/archive/index.php/t-23170.html
Regards
Ankit
Greg Stark wrote:
On Mon, Dec 21, 2009 at 12:54 PM, Ankit Kumar wrote:
I am running a Criteria.scroll() on postgresql on a DB containing 2M
records. The memory keeps increasing and finally it generates an
OutOfMemoryException. Please can you advice how
All
Thanks alot for your help. Got it working by setting the following: -
1. Connection to AutoCommit(false);
2. Criteria.scroll(ScrollMode.FORWARD_ONLY);
3. Set hibernate.jdbc.fetch_size=1000
Regards
Ankit
Kevin Grittner wrote:
Craig Ringer wrote:
Greg Stark wrote:
Ankit Kumar
