JDBC2.0:PreparedStatement setArray

From: Luigi Ruggiero <luigi(at)camara(dot)co(dot)za>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC2.0:PreparedStatement setArray
Date: 2003-11-10 09:59:34
Message-ID: 3FAF6186.8080204@camara.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-11-10 10:29:36 Re: JDBC2.0:PreparedStatement setArray
Previous Message Daniel Washusen 2003-11-10 04:20:26 Re: