Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC prepared statements & server-side prepared statements - Mailing list pgsql-general

From Dave Cramer
Subject Re: JDBC prepared statements & server-side prepared statements
Date
Msg-id 491f66a50906250249y6c0791f1qdcfaf6daf2c94be7@mail.gmail.com
Whole thread Raw
In response to Re: JDBC prepared statements & server-side prepared statements  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view


On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Jack Orenstein wrote:
> I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared statement
> result in a server-side prepared statement?

http://jdbc.postgresql.org/development/privateapi/org/postgresql/PGStatement.html#setPrepareThreshold(int)

The default is 5, as far as I remember.

Yours,
Laurenz Albe

5 is when they become named statements. The driver always uses prepared statements

Dave

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Replication
Next
From: Saurabh Dave
Date:
Subject: Re: [JDBC] Postgres 8.3.7 -- EOF on client connection