Re: rule and JDBC

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: rule and JDBC
Дата
Msg-id Pine.LNX.4.33.0401282356570.16679-100000@leary.csoft.net
обсуждение исходный текст
Ответ на rule and JDBC  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: rule and JDBC  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список pgsql-hackers

On Thu, 29 Jan 2004, Tatsuo Ishii wrote:

> Hi,
>
> It seems JDBC driver does not handle if a INSERT SQL statement
> performed by executeUpdate() is actually a SELECT, which is rewritten
> by the rule system.


The JDBC spec says an exception should be thrown if "the given SQL
statement produces a ResultSet object" which it does.  As you note using
executeQuery works, but won't if there isn't a rule.  Perhaps using plain
execute() would be the most appropriate thing to do.

Kris Jurka



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: rule and JDBC
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: rule and JDBC