Thread: JDBC2.0:PreparedStatement setArray

Hi there,

I am trying to set an array type in the preparedStatement. We are using
a Postgres 7.3.2 database. The driver jar version used, pg73jdbc3.jar.
Does anyone have a clue on how to do this?

Here is a snippet of my code. The function address.getLines() returns an
array of String's. (see the commented line)


public void prepare(PreparedStatement pst) throws SQLException{
             pst.setInt(1, agency.getId());
           //pst.setObject(2, address.getLines(), java.sql.Types.ARRAY);
             pst.setString(3, address.getCountry());
             pst.setString(4, address.getRegion());
             pst.setString(5, address.getCity());
}

I know there is a patch somewhere for this, does anyone know where  can
find it?

Thanx
Luigi

On Mon, Nov 10, 2003 at 11:59:34AM +0200, Luigi Ruggiero wrote:
> Hi there,
>
> I am trying to set an array type in the preparedStatement. We are using
> a Postgres 7.3.2 database. The driver jar version used, pg73jdbc3.jar.
> Does anyone have a clue on how to do this?

With the patch applied (below) you pass your own implementation of
java.sql.Array (that implements at least getBaseType and getArray) to
PreparedStatement.setArray.

[...]

> I know there is a patch somewhere for this, does anyone know where  can
> find it?

  http://archives.postgresql.org/pgsql-jdbc/2003-07/msg00294.php

I can regenerate this against current CVS if needed.

-O