Hello Ravi,
Thank you for the clarification. The best way to handle this
would be with the JDBC methods getArray and setArray.
Unfortunately, these methods are currently not implemented in
the JDBC driver. See also
http://lab.applinet.nl/postgresql-jdbc/ ("Array").
Regards,
René Pijlman
On Thu,
Hello Ravi,
I'm sorry, but I'm not sure I understand what you are trying to
do.
I'd suggest that you post:
- the CREATE TABLE statement used to create this particular
table (or a description of the table from psql)
- some data from this table
- the actual Java/JDBC code that reproduces the erro
Hi,
I am sorry for the previous
post .
My field type is bigint[] . I
am storing some numbers in it (as an array) .
I want to get that feild value
and insert it into another table . When I am using getLong() method
ResultSet
I am getting error message "Bad Long {1,2}" .
On Sun, 5 Aug 2001 23:08:16 +0900, you wrote:
>I am trying to retrieve field of type bigint[] from postgres DB.
>I tried most of getXXX methods of ResultSet abut I could not
>do it.
The JDBC spec recommends ResultSet.getLong() for the JDBC type
BIGINT:
long getLong(int columnIndex) throw