Re: PreparedStatement.setXXX
| От | Dave Cramer |
|---|---|
| Тема | Re: PreparedStatement.setXXX |
| Дата | |
| Msg-id | A8C2BE1D-2BAC-4B55-BAB0-E8DFF456E901@fastcrypt.com обсуждение исходный текст |
| Ответ на | PreparedStatement.setXXX ("Roberta Campo" <rcampo@mm.eutelsat.org>) |
| Ответы |
Re: PreparedStatement.setXXX
|
| Список | pgsql-jdbc |
Roberta,
You can force version 2 protocol with protocolVersion=2
or you can implement the Array interface.
For putting information into the db, I would imagine all you need to implement is everything up to getResultSet()
Dave
On 18-Jul-05, at 7:55 AM, Roberta Campo wrote:
We're moving from Postgresql7.4 to v.8.0.3,with some problems rising from the strictness of the new driverpostgresql-8.0-311.jdbc3.jar.We used to call a function f(integer[]) usingPreparedStatement.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
В списке pgsql-jdbc по дате отправления: