Обсуждение: JDBC prepared statements & server-side prepared statements

Поиск
Список
Период
Сортировка

JDBC prepared statements & server-side prepared statements

От
Jack Orenstein
Дата:
I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared statement
result in a server-side prepared statement?

Jack Orenstein

Re: JDBC prepared statements & server-side prepared statements

От
"Albe Laurenz"
Дата:
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

Re: JDBC prepared statements & server-side prepared statements

От
Dave Cramer
Дата:


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