Re: Retrieving field of type bigint[]

From: Barry Lind <barry(at)xythos(dot)com>
To: RaviShankar K <ravi(at)e-jan(dot)co(dot)jp>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Retrieving field of type bigint[]
Date: 2001-08-06 16:31:16
Message-ID: 3B6EC654.1040302@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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(at)e-jan(dot)co(dot)jp>
>
> *To:* pgsql-jdbc(at)postgresql(dot)org <mailto:pgsql-jdbc(at)postgresql(dot)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
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message RaviShankar K 2001-08-06 18:00:57 field of type oid
Previous Message Rene Pijlman 2001-08-06 12:05:11 Re: How can I get anoncvs PGSQL-JDBC source?