Thread: Postgres JDBC Driver : java.lang.OutOfMemoryError

Postgres JDBC Driver : java.lang.OutOfMemoryError

From
adiddi@hss.hns.com
Date:


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




RE: Postgres JDBC Driver : java.lang.OutOfMemoryError

From
Peter Mount
Date:
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
> 
> 


RE: Postgres JDBC Driver : java.lang.OutOfMemoryError

From
adiddi@hss.hns.com
Date:

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
>
>






RE: Postgres JDBC Driver : java.lang.OutOfMemoryError

From
Peter Mount
Date:
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
> >
> >
> 
> 
> 
> 


postgres access from windowsNT

From
Manika Dey
Date:
Hi,  i have posgresql6.x on solaris platform.  i have downloaded odbc driver for postgresql7.x  and installed on
windowsNT, when i try to connect   to postgres database , it gives error--  unsupported frontend protocol.
 
how can i solve this problemlooking for your response.

manika 

-------------------------------------------------------------------

From:-                          | Ms. Manika Dey.                |Ph.No:--Engineer-SC (Comp. Tech.)      | IPR -- 02712
-69276 I.P.R                          |          EXT 336,315BHAT, GANDHINAGAR              | Residence -- 079 -
6873114Gujrat-- 382 428              | FAX --- 69017 ------------------------------------------------------------------




                                                     






Re: postgres access from windowsNT

From
Peter Eisentraut
Date:
Manika Dey writes:

>    i have posgresql6.x on solaris platform.

What is x?

>    i have downloaded odbc driver for postgresql7.x

What is x?

>    and installed on windowsNT , when i try to connect
>    to postgres database , it gives error--
>    unsupported frontend protocol.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



postgres access from windowsNT

From
Manika Dey
Date:
Hi,  I would like know if postgesql can be installed   on windows platform.    looking forward for an early reply.
manika

-------------------------------------------------------------------

From:-                          | Ms. Manika Dey.                |Ph.No:--Engineer-SC (Comp. Tech.)      | IPR -- 02712
-69276 I.P.R                          |          EXT 336,315BHAT, GANDHINAGAR              | Residence -- 079 -
6873114Gujrat-- 382 428              | FAX --- 69017 ------------------------------------------------------------------




                                                     





postgres access from windowsNT

From
Manika Dey
Date:
Hi,   I would like know if postgesql can be installed    on windows platform.      looking forward for an early reply.
  manika 
 
> -------------------------------------------------------------------
> 
> From:-                          | 
>  Ms. Manika Dey.                |Ph.No:--
>  Engineer-SC (Comp. Tech.)      | IPR -- 02712 - 69276 
>  I.P.R                          |          EXT 336,315
>  BHAT, GANDHINAGAR              | Residence -- 079 - 6873114
>  Gujrat -- 382 428              | FAX --- 69017
>   ------------------------------------------------------------------ 
> 
> 
> 
> 
>                                        
>                 
> 
> 
> 
> 



Re: postgres access from windowsNT

From
markMLl.pgsql-interfaces@telemetry.co.uk
Date:
Manika Dey wrote:

>    I would like know if postgesql can be installed
>    on windows platform.

The ODBC drivers work. If you want to run the server under NT you'll
need CygWin in practice.

-- 
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or
colleagues]


Re: postgres access from windowsNT

From
Matt Fair
Date:
Here are some links that should help:
http://members.tripod.com/~kevlo/postgres/portNT.html
http://people.freebsd.org/~kevlo/postgres/portNT.html
Matt

Manika Dey wrote:

>
>
>  Hi,
>     I would like know if postgesql can be installed
>     on windows platform.
>
>     looking forward for an early reply.
>
>    manika
>
>
> > -------------------------------------------------------------------
> >
> > From:-                          |
> >  Ms. Manika Dey.                |Ph.No:--
> >  Engineer-SC (Comp. Tech.)      | IPR -- 02712 - 69276
> >  I.P.R                          |          EXT 336,315
> >  BHAT, GANDHINAGAR              | Residence -- 079 - 6873114
> >  Gujrat -- 382 428              | FAX --- 69017
> >   ------------------------------------------------------------------
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl