Re: force JDBC driver fetch / autocommit parameters?

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(at)fastcrypt(dot)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(at)gmail(dot)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
>