Retrieving postgresql arrays using JDBC

Question

I have a table like this

  list     |  id  | 
-----------+--------
 {930,23}  |  1   |
 {2012,1}  |  2   |
 {5943}    |  3   |
 {6148}    |  4   |
 {1003}    |  5   |

Now, I'd like to use JDBC to retrieve the first column. I've learned that we can use java.sql.Array to do that. (http://docs.oracle.com/javase/tutorial/jdbc/basics/array.html#retrieving_array), but when I declare the Array object like this:

import java.sql.Array;

while(rs.next())
    Array arr;

It issues a compile error:

[javac] /home/xxx.java:291: error: not a statement
[javac]             Array arr;
[javac]             ^
[javac] /home/xxx.java:291: error: ';' expected
[javac]             Array arr;
[javac]                  ^
[javac] /home/xxx.java:291: error: not a statement
[javac]             Array arr;
[javac]                   ^

It seems that Java is not recognizing the data type java.sql.Array. Anyone knows why? Thanks a lot!

Mark Byers · Accepted Answer · 2012-05-24 19:14:35Z

2

You should use curly brackets with your while statements:

while (rs.next()) {
    Array arr;  // Add more code here.
}

answered May 24, 2012 at 19:14

Mark Byers

843k202 gold badges1.6k silver badges1.5k bronze badges

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

2 Comments

Yang Over a year ago

It works! Thank you. But why should we use curly brackets when there is only one statement?

Mark Byers Over a year ago

@Yang: Because the Java specification doesn't all you to create a local variable there unless you have a block. Even if it were allowed, it wouldn't make much sense. What would its scope be?

Collectives™ on Stack Overflow

Retrieving postgresql arrays using JDBC

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related