setUseServerPrepare(true) and executeQuery(String)

Поиск
Список
Период
Сортировка
От Harald Krake
Тема setUseServerPrepare(true) and executeQuery(String)
Дата
Msg-id 200211301542.29994.harald@krake.de
обсуждение исходный текст
Список pgsql-jdbc
playing with the new server side prepared statements of 7.3 I discovered
that _all_ statements will be prepared as server objects, not only
the prepared ones. Depending on the application this might result in
a permanently increasing number of server objects.

In executeQuery(String), AbstractJdbc1Statement.java:141
I would suggest the following modification:

    boolean old_useServerPrepare = m_useServerPrepare;
    m_useServerPrepare = false;     // turn off for non-prepared statements
    java.sql.ResultSet rs = executeQuery();
    m_useServerPrepare = old_useServerPrepare;
    return rs;

regards,
Harald.


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

Предыдущее
От: pginfo
Дата:
Сообщение: JDBC and pg 7.3
Следующее
От: Harald Krake
Дата:
Сообщение: bug in AbstractJdbc1Statement.java (7.3)