How to Get an array from mysql?

Question

i am trying to get a list of actors from my database ,but i am getting an error,

I search a little on google and it seems Mysql does not support this kind of operation with arrays ,How i can do it ?

 public void GetCast() throws SQLException, IOException {
                try {
                    int ID = idMovie;
                    String IDMOVIE = Integer.toString(ID);
                    IDMovieLabel.setText(IDMOVIE);



                    Class.forName("com.mysql.jdbc.Driver");

                    con = DriverManager.getConnection("jdbc:mysql://localhost/whichmovie", "Asis", "dekrayat24");
                    String sql ="SELECT Name From actor";
                    st = con.prepareStatement(sql);
                    rs = st.executeQuery(sql);
                    if (rs.next()) {

                        Array actors=rs.getArray(1);
                        String [] ListActors = (String [])actors.getArray();

                        System.out.println(ListActors);

                    }
                    rs.close();
                    st.close();
                    con.close();
                } catch (ClassNotFoundException ex) {
                   System.out.println(ex.getMessage());
                }



            }



Grave: null
java.sql.SQLFeatureNotSupportedException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at java.lang.Class.newInstance(Class.java:374)

Islay · Accepted Answer · 2014-05-18 21:29:50Z

1

MySQL does not support storing arrays as is. I'm assuming you are trying to get the list of actors (which are actually just multiple rows in the resultset) into an array.
You can use this instead of the if block:

ArrayList<String> actors = new ArrayList<>();

while (rs.next())
{
    actors.add(rs.getString(1));
}

System.out.println(actors);

answered May 18, 2014 at 21:29

Islay

4764 silver badges17 bronze badges

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

3 Comments

Asis Over a year ago

Yes ,they are just multiple rows .i will try your answer.

Asis Over a year ago

Great, it works .i Can't vote the answer because of the reputation.anyway Thank you very much for your help.

Islay Over a year ago

@Asis: On the left you should see a tick mark below the 'up' and 'down' symbols. Click it to mark the post as the answer, if you agree that it answered your question.

Collectives™ on Stack Overflow

How to Get an array from mysql?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related