JDBC prepared statements & server-side prepared statements

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

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)&lt;http://jdbc.postgresql.org/development/privateapi/org/postgresql/PGStatement.html#setPrepareThreshold%28int%29&gt;

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