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

2001-08-05 Thread RaviShankar K



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 
  
  To: [EMAIL PROTECTED] 
  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 



[JDBC] Retrieving field of type bigint[]

2001-08-05 Thread RaviShankar K



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 


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



[JDBC]

2001-08-05 Thread raviG




Hi,
 
 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 . If any one has idea about this please help me 
.
 
 Thank you.
 
Regards,Ravi


[JDBC] Retrieving field of type bigint[]

2001-08-05 Thread raviG



Hi,
 
 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 . If any one has idea about this please help me 
.
 
 Thank you.
 
Regards,Ravi