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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend