Can't select data from MySQL database: java.lang.NullPointerException

Question

I'm trying to select data from database using this code:

//DATABASE
ResultSet rs;
String polecenie;
Statement st;
String[] subj;

public void polacz() {
    try {
        Class.forName("com.mysql.jdbc.Driver");

        Connection pol=DriverManager.getConnection("jdbc:mysql://localhost:3306/testgenerator", "root", "pospaz");
        st = pol.createStatement();
        lblPolaczonoZBaza.setText("Połączono z bazą danych testgenerator");

    } catch (Exception ek) {
        statusMessageLabel.setText("Can't connect to d: "+ek);
    }


    polecenie = "select * from subjects";


    try {
        rs = st.executeQuery(polecenie);
        int i=0;
        while (rs.next()){
            subj[i] = rs.getString("name");
            i++;
        }
        st.close();
    } catch (Exception ek) {
        statusMessageLabel.setText("Can't select data: "+ek);
    }
}

The second catch shows exception:

java.lang.NullPointerException

I looked everywhere and I can't find the solution. I'd be grateful for any help.

Oskar Kjellin · Accepted Answer · 2010-05-11 19:35:41Z

6

You never instantiate subj[] which causes it to be null

answered May 11, 2010 at 19:35

Oskar Kjellin

22k10 gold badges57 silver badges95 bronze badges

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

Comments

tzaman · Accepted Answer · 2010-05-11 19:39:01Z

5

You're not initializing the String[] subj array, that I can see, so when it gets to subj[i] = ... it chokes. You need to do one of the following:

determine the number of rows in the resultset, and initialize subj = new String[resultcount]
use an auto-extending container (like an ArrayList) instead of the string array

answered May 11, 2010 at 19:39

tzaman

48k11 gold badges93 silver badges118 bronze badges

Collectives™ on Stack Overflow

Can't select data from MySQL database: java.lang.NullPointerException

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related