Re: JDBC Array double precision [] error - Mailing list pgsql-jdbc

From Juan Pablo Cook
Subject Re: JDBC Array double precision [] error
Date
Msg-id CAKge45+4EA9sppsRd-hR9fj+7w3dd-FomD3u=xNG3vXsSsFHTQ@mail.gmail.com
Whole thread Raw
In response to Re: JDBC Array double precision [] error  (Nicholas White <n.j.white@gmail.com>)
List pgsql-jdbc
Thanks everyone! that's help a lot ;) Double[] instead of the primitive double[].

Thanks!

JP


On Mon, Apr 1, 2013 at 3:28 AM, Nicholas White <n.j.white@gmail.com> wrote:
getArray returns a Double[] - not a primitive double[]. You can't cast between the two; use something like http://docs.guava-libraries.googlecode.com/git/javadoc/com/google/common/primitives/Doubles.html#toArray(java.util.Collection) ...


On Sunday, 31 March 2013, Juan Pablo Cook wrote:
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! ;)


pgsql-jdbc by date:

Previous
From: Edson Richter
Date:
Subject: Re: JDBC 9.2 DEV not working with Hex bytea output?
Next
From: Juan Pablo Cook
Date:
Subject: Trigger of Transaction