RE: Postgres JDBC Driver : java.lang.OutOfMemoryError - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: Postgres JDBC Driver : java.lang.OutOfMemoryError
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B63E@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to Postgres JDBC Driver : java.lang.OutOfMemoryError  (adiddi@hss.hns.com)
Responses postgres access from windowsNT  (Manika Dey <bithi@ipr.res.in>)
List pgsql-interfaces
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@maidstone.gov.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@hss.hns.com [mailto:adiddi@hss.hns.com]
> Sent: Friday, December 08, 2000 10:50 AM
> To: pgsql-interfaces@postgresql.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
> 
> 


pgsql-interfaces by date:

Previous
From: adiddi@hss.hns.com
Date:
Subject: Postgres JDBC Driver : java.lang.OutOfMemoryError
Next
From: Frodo Larik
Date:
Subject: PostgreSQL -> ODBC -> MS ACCESS