RE: Postgres JDBC Driver : java.lang.OutOfMemoryError

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(at)maidstone(dot)gov(dot)uk> on 12/08/2000 05:11:42 PM

To: Anil Diddi/HSS(at)HSS, pgsql-interfaces(at)postgresql(dot)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.

From SUN's docs:

-Xmsn
Specify the initial size, in bytes, of the memory allocation pool. This
value must be a multiple of 1024 greater than 1MB. Append the letter k or K
to indicate kilobytes, or m or M to indicate megabytes. The default value is
2MB. Examples:
-Xms6291456
-Xms6144k
-Xms6m

-Xmxn
Specify the maximum size, in bytes, of the memory allocation pool. This
value must a multiple of 1024 greater than 2MB. Append the letter k or K to
indicate kilobytes, or m or M to indicate megabytes. The default value is
64MB. Examples:
-Xmx83886080
-Xmx81920k
-Xmx80m

--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount(at)maidstone(dot)gov(dot)uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council

> -----Original Message-----
> From: adiddi(at)hss(dot)hns(dot)com [mailto:adiddi(at)hss(dot)hns(dot)com]
> Sent: Friday, December 08, 2000 10:50 AM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES]Postgres JDBC Driver : java.lang.OutOfMemoryError
>
>
>
>
>
> Hi ,
>
> Will appreciate any help in resolving the following exception:
>
> PostGreSQL : 7.0.2
>
> Exception occurred during event dispatching:
> java.lang.OutOfMemoryError:
> at org.postgresql.PG_Stream.ReceiveString(PG_Stream.java:250)
> at
> org.postgresql.Connection.ReceiveFields(Connection.java:447)
> at org.postgresql.Connection.ExecSQL(Connection.java:419)
> at org.postgresql.jdbc1.Statement.execute(Statement.java:269)
> at
> org.postgresql.jdbc1.Statement.executeQuery(Statement.java:53)
> .....
>
> Thanks
> Anil
>
>