| 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: | Whole Thread | Raw Message | 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
| 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: |