Jim Davis schrieb:
> I am not a java programmer, so it is possible I am doing something wrong:
>
> I saw this problem initially on my test system using sequoia jdbc
> driver with my postgresql 8.1.4 database servers trying
> to create an index on a 27 million row table. After many suggestions
> and tests, It was suggested I try using the postgresql
> jdbc driver to perform the create index to try and isolate where the
> out of memory condition is occurring. So I edited a
> java application I was testing with and pointed it to the postgresql
> jdbc driver. I used version postgresql-.2dev-503.jdbc3.jar
> the first time and postgresql-9.2dev-503.jdbc3.jar the second time
> with the same results: Exception in thread "main"
> java.lang.OutOfMemoryError: Java heap space
>
I have no idea, why this happens. I would not expect that. But i saw in
your code example that you use executeUpdate for a defining sql
statement. I would use just the execute method. A cursor should not be
needed.
Regards,
Roland.
--
Roland Walter mailto: rwa (at) mosaic-ag (dot) com
MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-44 9
Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1
D-53340 Meckenheim http://www.mosaic-ag.com
Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich
fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte,
vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger
oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung,
Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt.
Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte
unverzueglich den Absender und vernichten Sie die E-Mail.
This e-mail message and any attachment are intended exclusively for the named
addressee. They may contain confidential information which may also be protected
by professional secrecy. Unless you are the named addressee (or authorised to
receive for the addressee) you may not copy or use this message or any attachment
or disclose the contents to anyone else. If this e-mail was sent to you by mistake
please notify the sender immediately and delete this e-mail.
