Skip site navigation (1) Skip section navigation (2)

Re: statement caching patch from Laszlo Hornyak for review

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: László Hornyák <kocka(dot)public(at)gmail(dot)com>,"Paul van den Bogaard" <Paul(dot)Vandenbogaard(at)sun(dot)com>,"Oliver Jowett" <oliver(at)opencloud(dot)com>,"Kris Jurka" <books(at)ejurka(dot)com>,"List" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: statement caching patch from Laszlo Hornyak for review
Date: 2007-08-30 08:14:10
Message-ID: 46D67C52.60902@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Dave Cramer wrote:
> I just noticed this:
> 
> Now that JDBC 4 has a notion of pooling built right into the statement
> interface it is clear (to me at least) that the implementation belongs
> in the driver.

In chapter 11.6, "Reuse of Statements by Pooled Connection", the spec says:

> In FIGURE 11-2, the connection pool and statement pool are implemented by the
> application server. However, this functionality could also be implemented by the
> driver or underlying data source. This discussion of statement pooling is meant to
> allow for any of these implementations.

The new methods added in JDBC4, setPoolable and isPoolable are for use
by applications to hint the connection pool implementation which
statements it should try to pool. Statements are poolable by default, so
it's really for telling the pool not to bother pooling one off queries.

I still don't think it's wise for us to bundle a statement cache in the
driver. If we had a server-side statement cache, or if there was some
other PostgreSQL specific trick we could take advantage of, it would
make sense to provide an interface for it. But there isn't.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-jdbc by date

Next:From: Albe LaurenzDate: 2007-08-30 09:48:31
Subject: Re: Problem connecting to a pgsql database from Net Beans.
Previous:From: Flavio MonteiroDate: 2007-08-30 01:53:38
Subject: Problem connecting to a pgsql database from Net Beans.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group