Re: Support for named parameters in the PostgreSQL JDBC driver - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Support for named parameters in the PostgreSQL JDBC driver
Date
Msg-id Pine.BSO.4.64.0611161249120.23576@leary2.csoft.net
Whole thread Raw
In response to Support for named parameters in the PostgreSQL JDBC driver  (Ravi Periasamy <rperiasamy@aol.com>)
Responses Re: Support for named parameters in the PostgreSQL JDBC driver
List pgsql-jdbc

On Thu, 16 Nov 2006, Ravi Periasamy wrote:

> Dear PGSQL-JDBC Team,
>
> Could you please let me know if the support for "Named Parameters" in the
> JDBC driver is slated for some future release?
>

Just recently I noticed an overlooked patch that implements this:
http://archives.postgresql.org/pgsql-jdbc/2006-07/msg00011.php

The suggested patch isn't quite right, but its approach can work in many
cases.  If functions are not overloaded then a simple lookup of parameter
names by the function name would work.  If the function is overloaded we
might be able to use the parameter type given by setXXX to try and
determine what function we're actually calling, but it's probably better
to just error out in that case.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Support for named parameters in the PostgreSQL JDBC driver
Next
From: Mikko Tiihonen
Date:
Subject: ResultSet.getBytes() of bytea speedup batch