Re: Forcing cursor behavior - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Forcing cursor behavior
Date
Msg-id 4A659236.2050305@opencloud.com
Whole thread Raw
In response to Re: Forcing cursor behavior  (Shawn Heisey <pgsql@elyograg.org>)
List 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

pgsql-jdbc by date:

Previous
From: Shawn Heisey
Date:
Subject: Re: Forcing cursor behavior
Next
From: Віталій Тимчишин
Date:
Subject: Re: Forcing cursor behavior