[JDBC] Retrieving field of type bigint[]

2001-08-09 Thread 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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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



Re: [JDBC] Retrieving field of type bigint[]

2001-08-05 Thread Rene Pijlman

On Sun, 5 Aug 2001 23:08:16 +0900, you wrote:
I am trying to retrieve field of type bigint[] from postgres DB. 
I tried most of  getXXX methods of ResultSet abut I could not 
do it. 

The JDBC spec recommends ResultSet.getLong() for the JDBC type
BIGINT:

long getLong(int columnIndex) throws SQLException
long getLong(String columnName) throws SQLException

What is the problem precisely? I could not do it is not very
informative.

What's your source code? What's the column type? What versions
of what are you using? What exception did you get?

Regards,
René Pijlman

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html