Postgres Pro
Downloads
Home   >   mailing lists

Thread: Retrieving field of type bigint[]

Retrieving field of type bigint[]

From
"RaviShankar K"
Date:
Hi,

I am trying to retrieve field of type bigint[] from postgres DB. I tried most of getXXX methods of ResultSet but I could not do it . If any one has idea about this, please help me .

Thank you.

Regards,
Ravi

Re: Retrieving field of type bigint[]

From
"RaviShankar K"
Date:
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}" . {1,2} is the value in that field .
   
    Please help me .My jdbc driver is "jdbc7.1-1.3.jar".
 
Regards,
Ravi
 
 
   
----- Original Message -----
Sent: Monday, August 06, 2001 AM 11:13
Subject: [JDBC] Retrieving field of type bigint[]

Hi,

I am trying to retrieve field of type bigint[] from postgres DB. I tried most of getXXX methods of ResultSet but I could not do it . If any one has idea about this, please help me .

Thank you.

Regards,
Ravi

Re: Retrieving field of type bigint[]

From
Rene Pijlman
Date:
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 error
- the full text of the error message in the exception.

Kind regards,
René Pijlman

>    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}" . {1,2} is the value in that field .
>
>    Please help me .My jdbc driver is "jdbc7.1-1.3.jar".
>
>Regards,
>Ravi

Re: Retrieving field of type bigint[]

From
Barry Lind
Date:
The correct method to call is getArray() on the result set.
Unfortunately that functionality hasn't yet been implemented in the
current jdbc code for postgresql.

thanks,
--Barry


RaviShankar K wrote:
> 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}" . {1,2} is the value in that
> field .
>
>
>
>     Please help me .My jdbc driver is "jdbc7.1-1.3.jar".
>
>
>
> Regards,
>
> Ravi
>
>
>
>
>
>
>
>     ----- Original Message -----
>
>     *From:* RaviShankar K <mailto:ravi@e-jan.co.jp>
>
>     *To:* pgsql-jdbc@postgresql.org <mailto:pgsql-jdbc@postgresql.org>
>
>     *Sent:* Monday, August 06, 2001 AM 11:13
>
>     *Subject:* [JDBC] Retrieving field of type bigint[]
>
>
>     Hi,
>
>     I am trying to retrieve field of type bigint[] from postgres DB. I
>     tried most of getXXX methods of ResultSet but I could not do it . If
>     any one has idea about this, please help me .
>
>     Thank you.
>
>     Regards,
>     Ravi
>