Re: JDBC prepared statements & server-side prepared statements

Lists: pgsql-general
From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: JDBC prepared statements & server-side prepared statements
Date: 2009-06-24 14:26:46
Message-ID: 4A4237A6.4050608@hds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared statement
result in a server-side prepared statement?

Jack Orenstein

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Jack Orenstein *EXTERN*" <jack(dot)orenstein(at)hds(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: JDBC prepared statements & server-side prepared statements
Date: 2009-06-25 06:59:44
Message-ID: D960CB61B694CF459DCFB4B0128514C202FF6681@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: "Jack Orenstein *EXTERN*" <jack(dot)orenstein(at)hds(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: JDBC prepared statements & server-side prepared statements
Date: 2009-06-25 09:49:55
Message-ID: 491f66a50906250249y6c0791f1qdcfaf6daf2c94be7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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)<http://jdbc.postgresql.org/development/privateapi/org/postgresql/PGStatement.html#setPrepareThreshold%28int%29>
>
> 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