Re: rule and JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: rule and JDBC
Date: 2004-01-29 05:00:11
Message-ID: Pine.LNX.4.33.0401282356570.16679-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2004-01-29 05:07:10 Re: rule and JDBC
Previous Message Tatsuo Ishii 2004-01-29 04:44:59 rule and JDBC