Fwd: JDBC Array double precision [] error

From: Juan Pablo Cook <juampick(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Fwd: JDBC Array double precision [] error
Date: 2013-03-31 22:08:18
Message-ID: CAKge45+cZpDVsGoYPdVew0haNs9mpq_i-qegaBKxnWDCiKQagQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi everyone! I need your help with this problem.

I'm using PostgreSQL 9.2 Server & the latest jdbc
driver: postgresql-9.2-1002.jdbc4.jar

I have a table with this column array:
-- histograma double precision[]

And I want to retrieve this and cast into java to double[] but I can't.

This is the extract of the code:

Statement stat1 = con.createStatement();
ResultSet rs1 = stat1.executeQuery("SELECT * FROM \"Vector\");

while (rs1.next()) {

double[] array = (double[]) rs1.getArray("histograma").getArray();

}

And the error:
"
Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException:
[Ljava.lang.Double; cannot be cast to [D
"
Also I tried to do a for loop but didn't work.

Can you help me?

Thanks a lot! ;)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Hachadoorian 2013-03-31 22:32:12 Current Schema for Functions called within other Functions
Previous Message Juan Pablo Cook 2013-03-31 22:06:43 JDBC Array double precision [] error

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hannes Erven 2013-03-31 22:38:28 Re: Fwd: JDBC Array double precision [] error
Previous Message Juan Pablo Cook 2013-03-31 22:06:43 JDBC Array double precision [] error