how to convert java.sql.Array to an integer array

Question

Hello to everyone i'm stucked with this simple problem.

i'm trying to load an integer array from my Postgres DB.

My Code:

Array a = rs.getArray("my_field");

int[] b = (int[])a.getArray();

The Exception Displayed:

java.lang.ClassCastException: class [Ljava.lang.Integer; cannot be cast to class [I ([Ljava.lang.Integer; and [I are in module java.base of loader 'bootstrap')

How can i convert java.sql.Array into an int[] array or into an arraylist?

Unrelated to your question, but: Postgres 9.3 is no longer supported you should plan an upgrade as soon as possible. — user330315
– user330315, Commented Oct 28, 2020 at 11:00

user330315 · Accepted Answer · 2020-10-28 10:59:55Z

1

You need to cast it to an array of Integer:

Array a = rs.getArray("my_field");
Integer[] b = (Integer[])a.getArray();

Note that a will be null if the column is null in the database, so you should check that before calling a.getArray().

answered Oct 28, 2020 at 10:59

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to convert java.sql.Array to an integer array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related