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