JDBC Array double precision [] error

From: Juan Pablo Cook <juampick(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC Array double precision [] error
Date: 2013-03-31 22:06:43
Message-ID: CAKge45+Tmvu75UjHMtoAhuTnw_yCpkrgktt-kWT7ojPEu+W8gg@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! ;)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juan Pablo Cook 2013-03-31 22:08:18 Fwd: JDBC Array double precision [] error
Previous Message Enke, Dr., Michael 2013-03-31 22:06:25 in C trigger function find out if column is part of primary key

Browse pgsql-jdbc by date

  From Date Subject
Next Message Juan Pablo Cook 2013-03-31 22:08:18 Fwd: JDBC Array double precision [] error
Previous Message Edson Richter 2013-03-31 14:32:33 JDBC 9.2 DEV not working with Hex bytea output?