Re: Forcing cursor behavior

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Shawn Heisey <pgsql(at)elyograg(dot)org>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Forcing cursor behavior
Date: 2009-07-21 10:02:30
Message-ID: 4A659236.2050305@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Shawn Heisey wrote:

> To the person with the Cyrillic name that also responded ... how much
> effort would be involved in writing the delegating driver you described?

http://onjava.com/pub/a/onjava/2001/12/05/optimization.html may be a
useful starting point for this.

You'd basically want a set of wrappers as described there, plus a Driver
or Datasource implementation (depending on what your app uses) that
handled building a wrapper Connection around the real connection
obtained from the PostgreSQL driver. Then your wrapper implementations
can mangle autocommit and fetchsize as you see fit (and presumably not
delegate setAutoCommit(true) calls from the app down to the driver either)

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Віталій Тимчишин 2009-07-21 13:29:05 Re: Forcing cursor behavior
Previous Message Shawn Heisey 2009-07-21 09:44:47 Re: Forcing cursor behavior