From: | "RaviShankar K" <ravi(at)e-jan(dot)co(dot)jp> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Retrieving field of type bigint[] |
Date: | 2001-08-09 08:28:34 |
Message-ID: | 030401c120ad$47847a60$0400a8c0@ejan.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)wanadoo(dot)nl>
To: <pgsql-jdbc(at)postgresql(dot)org>
Cc: <ravi(at)e-jan(dot)co(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | RaviShankar K | 2001-08-09 08:29:17 | field of type oid |
Previous Message | RaviShankar K | 2001-08-09 08:25:37 | How to deal with "oid" field when it contains NULL ? |