Re: Problems with big tables.

Поиск
Список
Период
Сортировка
От Jose Miguel Madinaveitia Ramirez
Тема Re: Problems with big tables.
Дата
Msg-id 411671BA.70806@servidor.unam.mx
обсуждение исходный текст
Ответ на Re: Problems with big tables.  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Thanks to all for the help.
The problem is the autocommit status.

I change the values to off and the program work well ..



Oliver Jowett wrote:
> Jose Miguel Madinaveitia Ramirez wrote:
>
>> Hi, I have a problem to obtain big tables (1 million records) with the
>> jdbc driver.
>> The out of memory error is throw by the executeQuery().
>> The fetchsize() function does not work.?
>
>
> With the most current drivers, cursors will only be used to
> incrementally fetch data when all of these conditions are true:
>
>   - a positive fetchsize has been set via setFetchSize()
>   - autocommit is off
>   - the resultset type is TYPE_FORWARD_ONLY
>   - you are connecting to a 7.4 or above server
>
> -O
>
>

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: executing batch select queries
Следующее
От: "Justin Kennedy - Maritime Source"
Дата:
Сообщение: Re: executing batch select queries