PreparedStatement & direct execution methods

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: PreparedStatement & direct execution methods
Date: 2004-05-22 23:59:07
Message-ID: 40AFE94B.7060904@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Just noticed this in the JDBC spec (13.2.4):

If any of the PreparedStatement execute methods is called with an SQL
string as a parameter, an SQLException is thrown.

(don't you love how you have to look at both the spec and the javadoc to
discover the behaviour of particular methods?)

The current driver doesn't do this, and we've had at least one bug
report that turned out to be caused by calling an execute...() method
with a string on a PreparedStatement.

Worth fixing?

-O

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-05-23 00:25:24 Re: patch: streaming of bytea parameter values
Previous Message Kris Jurka 2004-05-22 17:49:34 Re: patch: streaming of bytea parameter values