| From: | "Roberta Campo" <rcampo(at)mm(dot)eutelsat(dot)org> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | PreparedStatement.setXXX |
| Date: | 2005-07-18 11:55:23 |
| Message-ID: | dbg5ba$2g9c$3@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
We're moving from Postgresql7.4 to v.8.0.3,
with some problems rising from the strictness of the new driver
postgresql-8.0-311.jdbc3.jar.
We used to call a function f(integer[]) using
PreparedStatement.setString('{...}')
but now the types are not compatible.
How should we fix that ?
A. Using the setArray method :
This requires the implementation of the interface java.sql.Array :
- which methods are required in this case ?
- is there any available implementation of this class ? :)
B. Using the setObject(colnumber, String, type ) method :
This should require less implementation than the Array, shouldn't it ?
- how to specify the type int[] ?
C. Using different drivers / protocol versions / ...
Thanks,
Roberta
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-07-18 12:35:58 | Re: Timezone conversion woes |
| Previous Message | Kris Jurka | 2005-07-16 04:07:32 | Re: patch to fix jdk 2 compile errors and v2 compatability |