Re: force JDBC driver fetch / autocommit parameters?

Поиск
Список
Период
Сортировка
От S. Balch
Тема Re: force JDBC driver fetch / autocommit parameters?
Дата
Msg-id CAAwMNsjkkBHC-D0nyr0NZ756Kttni0JSU+UHPCA6tiBby+Q5QQ@mail.gmail.com
обсуждение исходный текст
Ответ на force JDBC driver fetch / autocommit parameters?  ("S. Balch" <sbalch@gmail.com>)
Ответы Re: force JDBC driver fetch / autocommit parameters?
Список pgsql-general
Дерево обсуждения
Dave,

We're just running the JVM out of memory with a large query result.  By turning off autocommit and setting a reasonable fetch size this problem goes away.  The application using this driver does have a way to set these, but it seems to be broken.

Thanks,
Sean


On Fri, Oct 21, 2011 at 9:51 AM, Dave Cramer <pg@fastcrypt.com> wrote:
Can you be more specific as to what you are looking for ? I presume
there is something between you and the connection so when you turn
autocommit on it doesn't work ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca




On Thu, Oct 20, 2011 at 4:34 PM, S. Balch <sbalch@gmail.com> wrote:
> Greetings,
> I'm using the postgresql-9.1-901.jdbc4 driver in an application (that I
> don't control) that's not passing along my specified fetch and autocommit
> parameters.  Is there anyway I can force the driver to use my required
> parameters outside of the application?
> Thanks,
> Sean


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

Предыдущее
От: Emi Lu
Дата:
Сообщение: Re: Temporally disabled foreign key constraint check?
Следующее
От: Henry Drexler
Дата:
Сообщение: Re: plpgsql at what point does the knowledge of the query come in?