Received: from thor.tht.net (thor.tht.net [209.47.145.4])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB8E6MZ76313
	for <pgsql-interfaces@postgresql.org>;
	Fri, 8 Dec 2000 09:06:22 -0500 (EST)
	(envelope-from adiddi@hss.hns.com)
Received: from hindon.hss.co.in ([202.54.26.202])
	by thor.tht.net (8.9.3/8.9.3) with ESMTP id JAA08494
	for <pgsql-interfaces@postgresql.org>; Fri, 8 Dec 2000 09:58:56 GMT
	(envelope-from adiddi@hss.hns.com)
From: adiddi@hss.hns.com
Received: from sandesh.hss.hns.com (localhost [127.0.0.1])
	by hindon.hss.co.in (8.10.0/8.10.0) with SMTP id eB8DxsV20541
	for <pgsql-interfaces@postgresql.org>;
	Fri, 8 Dec 2000 19:29:55 +0530 (IST)
Received: by sandesh.hss.hns.com(Lotus SMTP MTA v4.6.3 (733.2 10-16-1998)) id
	652569AF.004BB032 ; Fri, 8 Dec 2000 19:16:43 +0530
X-Lotus-FromDomain: HSS
To: pgsql-interfaces@postgresql.org
Message-ID: <652569AF.004BAF1F.00@sandesh.hss.hns.com>
Date: Fri, 8 Dec 2000 19:22:39 +0530
Subject: RE: Postgres JDBC Driver : java.lang.OutOfMemoryError
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Archive-Number: 200012/61
X-Sequence-Number: 398



Hi Peter,

Thanks a lot. It worked : java -xmx128m my.app.classfile

So, it turned out to be the JVM  memory heap size issue - not a JdbcDriver
issue.

The resultset was really not that big !

But the jdbcDriver does have hardcoded values 8192 etc. at lot of places in the
PG_Stream, connection and other classes.

Thanks again
Anil






Peter Mount <petermount@maidstone.gov.uk> on 12/08/2000 05:11:42 PM

To:   Anil Diddi/HSS@HSS, pgsql-interfaces@postgresql.org
cc:

Subject:  RE: [INTERFACES]Postgres JDBC Driver : java.lang.OutOfMemoryError




How big is the ResultSet?

By default the JVM alocates 64Mb of memory. To increase this, you pass the
-Xmx parameter to java, ie:

java -Xmx32m my.app.classfile

where 32m is 32Meg of memory maximum.