Craig Ringer wrote:
Greg Stark wrote:
Ankit Kumar wrote:
Thanks for your response. Hibernate works well when I change the
DB to SQL server but somehow the moment I point to Postgresql it
start generating OutOfMemory. Is there some configuration at DB
end to ensure it starts using the
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
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
On Mon, Dec 21, 2009 at 12:54 PM, Ankit Kumar ank...@xebia.com 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 to fix this.
Postgresql DB version: 8.4
On 22/12/2009 1:25 AM, Greg Stark wrote:
On Mon, Dec 21, 2009 at 5:04 PM, Ankit Kumarank...@xebia.com wrote:
Thanks for your response. Hibernate works well when I change the DB to SQL
server but somehow the moment I point to Postgresql it start generating
OutOfMemory. Is there some