Re: rule and JDBC - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: rule and JDBC
Date
Msg-id Pine.LNX.4.33.0401282356570.16679-100000@leary.csoft.net
Whole thread Raw
In response to rule and JDBC  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: rule and JDBC  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List 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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: rule and JDBC
Next
From: Tatsuo Ishii
Date:
Subject: Re: rule and JDBC