Re: PostgreSQL, WebObjects and fetchSize - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: PostgreSQL, WebObjects and fetchSize
Date
Msg-id Pine.BSO.4.56.0505111701440.15183@leary.csoft.net
Whole thread Raw
In response to Re: PostgreSQL, WebObjects and fetchSize  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: PostgreSQL, WebObjects and fetchSize
List pgsql-jdbc

On Thu, 12 May 2005, Oliver Jowett wrote:

> Jan Willem Luiten wrote:
>
> > Thanks for the prompt reply. Unfortunately I've got no access to
> > Statement.setFetchSize() from within WebObjects. Is there any other  way
> > to solve this?
>
> This is up to WebObjects to support -- it's a standard JDBC mechanism.
> The driver doesn't give you another way to set it.
>

Well defaulting it to a nonzero value is a reasonable thing to do, we have
just chosen not to for the pg driver because of possible performance
problems specific to pg.  We could consider exposing it via a URL
parameter.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: bytea encoding
Next
From: Warren Killian
Date:
Subject: PostgreSQL/Tomcat JNDI Datasource Questions