Re: Under what circumstances does PreparedStatement use stored

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Under what circumstances does PreparedStatement use stored
Дата
Msg-id 407E91A7.3040500@opencloud.com
обсуждение исходный текст
Ответ на Re: Under what circumstances does PreparedStatement use stored  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Kris Jurka wrote:
> Basically I want to run the whole regression tests with everything using
> server prepared statements cleanly.  Sure the patch doesn't affect the
> long standing behavior, but it makes in much more accessible and I'd
> expect a number of bug reports.  There were a number of other failures as
> well, but I don't recall what they are at the moment.

I just tried changing the driver to only use server-side-prepare for
SELECT statements, and changed the default value of useServerPrepare to
true so all statements are candidates for preparation. With those
changes, we pass all of the regression tests except for the
ResultSetMetaData tests. I haven't dug into the cause of the failures,
but it looks like the metadata has no column names for some reason.

Assuming the RSMD failures can be fixed, perhaps a change along those
lines when talking to a <= 7.4 server would let us turn on more
aggressive use of PREPARE?

-O

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Freddy Villalba Arias"
Дата:
Сообщение: PostgreSQL on Windows?
Следующее
От: James Robinson
Дата:
Сообщение: Performance analysis of server-parsed PreparedStatements ...