| Lists: | pgsql-jdbc |
|---|
| From: | Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Problems with big tables. |
| Date: | 2004-08-06 17:53:49 |
| Message-ID: | 4113C5AD.3070503@servidor.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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.
| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Problems with big tables. |
| Date: | 2004-08-06 19:21:41 |
| Message-ID: | 1091820101.1552.75.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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
| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Problems with big tables. |
| Date: | 2004-08-06 22:10:16 |
| Message-ID: | 411401C8.2080109@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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
| From: | Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Problems with big tables. |
| Date: | 2004-08-08 18:32:26 |
| Message-ID: | 411671BA.70806@servidor.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
>
>