Jim,
What happens when you try to do this in psql. It's possible that
there are notify messages filling up memory.
Dave
On 25-Aug-06, at 8:10 AM, Jim Davis wrote:
> Jim Davis wrote:
>
> I changed the executeUpdate to just an execute, saved, re-ran java
> application and received the same
> Exception in thread "main" java.lang.OutOfMemoryError: Java heap
> space error.
>
>
>
>
> Roland Walter wrote:
>
>> 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.
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>