Search Postgresql Archives

Re: force JDBC driver fetch / autocommit parameters?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> 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@xxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux