Re: Retrieving field of type bigint[] - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Retrieving field of type bigint[]
Date
Msg-id 3B72BE33.7040303@xythos.com
Whole thread Raw
In response to Retrieving field of type bigint[]  ("RaviShankar K" <ravi@e-jan.co.jp>)
List pgsql-jdbc
Ravi,

A very creative way of working around this issue.  I don't see anything
worng with what you are doing given how the driver code currently is
written.

thanks,
--Barry

RaviShankar K wrote:
> Hi René Pijlman,
>
>     Thank you for your mail. Sorry for the delayed reply .
>     I am giving the details about my application .
>
>    > the CREATE TABLE statement used to create this particular
>    >table (or a description of the table from psql)
>     CREATE TABLE mytable (sno integer UNIQUE, image_ids bigint[]);
>
>     >- some data from this table
>     The value of one of the row for the image_ids field :   {"20", "40"}
>
>         I tried to retrieve value of this field using getString(columnName)
> method
> of ResultSet and I was able to do it . I am able to insert the retrieved
> string back in to the
> database without any problem . So my problem is solved from my point of
> view.
>
>     Is there anything wrong in what I did ? If it is , please tell me the
> correct way.
>
> Thanks & Regards,
> Ravi
>
>
>
>
> ----- Original Message -----
> From: "Rene Pijlman" <rpijlman@wanadoo.nl>
> To: <pgsql-jdbc@postgresql.org>
> Cc: <ravi@e-jan.co.jp>
> Sent: Monday, August 06, 2001 PM 08:32
> Subject: Re: [JDBC] Retrieving field of type bigint[]
>
>
> 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
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>



pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: deleting large objects from jdbc
Next
From: Barry Lind
Date:
Subject: Re: Re: JDBC 2.0 conformance, documentation and todo list