Postgres Pro
Downloads
Home   >   mailing lists

JDBC, prepared queries, and partitioning - Mailing list pgsql-jdbc

From Josh Berkus
Subject JDBC, prepared queries, and partitioning
Date
Msg-id 200802131005.30553.josh@agliodbs.com
Whole thread Raw
Responses Re: JDBC, prepared queries, and partitioning  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view 
All,

Since JDBC always prepares and plan-caches queries, it makes it hard to use
partitioning with a database connected to a JDBC connection pool; successive
queries in the same session will select the wrong partition, or scan the
whole partition set.

Is there any workaround for this, either on 8.2 or 8.3?

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: 8.3 build 603 build error on Fedora 8
Next
From: Kris Jurka
Date:
Subject: Re: JDBC, prepared queries, and partitioning