I know, two differents tests on two databases, I know also that setFetchSize limit the number of rows that are returned
withoutwaiting the full result list. That's what I want. The fact is that the behaviour is different from my pc
(windowsXP, pg 8.2.4).
I don't know where it could come from.
Frédéric
-----Message d'origine-----
De : Oliver Jowett [mailto:oliver@opencloud.com]
Envoyé : mercredi 19 septembre 2007 15:26
À : Frédéric Houbie
Cc : pgsql-jdbc@postgresql.org
Objet : Re: [JDBC] Postgres 8.2 and setFetchSize
Frédéric Houbie wrote:
> I have one more information, I tried the same code using my local Postgres database (on my XP, 8.2.4), it is working.
Whatcan I check on the server to see what's wrong ?
> 2007-09-19 14:10:51.993 LOG: duration: 0.000 ms execute S_2/C_3: SELECT * FROM SValues
That's a different query to what you said before:
> String q="SELECT a FROM SValues WHERE Name = 'title'";
so you're not really running the same code, it seems.
-O