Обсуждение: Retrieving field of type bigint[]

Поиск
Список
Период
Сортировка

Retrieving field of type bigint[]

От
"RaviShankar K"
Дата:
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

Re: Retrieving field of type bigint[]

От
Rene Pijlman
Дата:
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, 9 Aug 2001 17:28:34 +0900, you 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

Re: Retrieving field of type bigint[]

От
Barry Lind
Дата:
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
>
>