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! ;)
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 |
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? |