| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Saurabh Dave | 2009-06-25 11:55:07 | Re: [JDBC] Postgres 8.3.7 -- EOF on client connection |
| Previous Message | Jasen Betts | 2009-06-25 09:26:14 | Re: Replication |