pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres JDBC Driver : java.lang.OutOfMemoryError
4+ messages / 2 participants
[nested] [flat]
* Postgres JDBC Driver : java.lang.OutOfMemoryError
@ 2000-12-08 10:50 adiddi@hss.hns.com
0 siblings, 0 replies; 4+ messages in thread
From: adiddi@hss.hns.com @ 2000-12-08 10:50 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Postgres JDBC Driver : java.lang.OutOfMemoryError
@ 2000-12-08 11:41 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Mount @ 2000-12-08 11:41 UTC (permalink / raw)
To: 'adiddi@hss.hns.com' <adiddi@hss.hns.com>; 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Postgres JDBC Driver : java.lang.OutOfMemoryError
@ 2000-12-08 13:52 adiddi@hss.hns.com
0 siblings, 0 replies; 4+ messages in thread
From: adiddi@hss.hns.com @ 2000-12-08 13:52 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Postgres JDBC Driver : java.lang.OutOfMemoryError
@ 2000-12-08 14:13 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Mount @ 2000-12-08 14:13 UTC (permalink / raw)
To: 'adiddi@hss.hns.com' <adiddi@hss.hns.com>; pgsql-interfaces
There shouldn't be that many 8k blocks (I can think of only 2, PG_Stream and
the old tuple size limit).
Peter
--
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 1:53 PM
> To: pgsql-interfaces@postgresql.org
> Subject: RE: [INTERFACES]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@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.
>
> 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
> >
> >
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-12-08 14:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-08 10:50 Postgres JDBC Driver : java.lang.OutOfMemoryError adiddi@hss.hns.com
2000-12-08 11:41 RE: Postgres JDBC Driver : java.lang.OutOfMemoryError Peter Mount <petermount@maidstone.gov.uk>
2000-12-08 13:52 RE: Postgres JDBC Driver : java.lang.OutOfMemoryError adiddi@hss.hns.com
2000-12-08 14:13 RE: Postgres JDBC Driver : java.lang.OutOfMemoryError Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox