Thread: Problems with big tables.

Problems with big tables.

From
Jose Miguel Madinaveitia Ramirez
Date:
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.?

sorry for my english.

Thanks.

saludos.
miguel.

Re: Problems with big tables.

From
Dave Cramer
Date:
Jose,

Have you tried the latest driver, and server, setFetchSize() is
implemented on those.

Dave
On Fri, 2004-08-06 at 13:53, 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.?
>
> sorry for my english.
>
> Thanks.
>
> saludos.
> miguel.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


Re: Problems with big tables.

From
Oliver Jowett
Date:
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

Re: Problems with big tables.

From
Jose Miguel Madinaveitia Ramirez
Date:
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
>
>