Обсуждение: 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
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 > >
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 > >
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 > > > > > > > >
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 ------------------------------------------------------------------
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
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 ------------------------------------------------------------------
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 > ------------------------------------------------------------------ > > > > > > > > > >
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]
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