I am getting a NullPointerException when i run this code

Question

Hi guys i have a NullPointerException when i run this code ,and its pointing on the model = (DefaultTableModel) DbUtils.resultSetToTableModel(rs) , and i have imported the net.proteanit.sql.DbUtils , any ideas ?

public void setTableValues(){
         try {
             cn.start();
             String sql = "select id,first_name as Firstname,last_name as Lastname,email,phone,description as AllergyInfo from clients where isDeleted=0";
             rs = cn.executeSelect(sql);
             model = (DefaultTableModel) DbUtils.resultSetToTableModel(rs);
             jTable1.setModel(model);
             rowSorter = new TableRowSorter<>(jTable1.getModel());
             jTable1.setRowSorter(rowSorter);
             cn.stop();
         } catch (SQLException ex) {
             Logger.getLogger(Clients.class.getName()).log(Level.SEVERE, null, ex);
         }
    }

(1-) A variable is null. Figure out which variable is null, by adding System.out.println(...) statements for each variable you access in that statement. Don't expect to ask a question every time you get a NullPointerException. — camickr, May 05 '18 at 19:39

score 2 · Answer 1 · answered May 05 '18 at 19:44

2

Use any IDE like eclipse to debug your code to add breakpoints and get to know which variable is null and that will be pointing to null pointer exception.

And you can add null check in your code to prevent null pointer exception like

If (object != null)

answered May 05 '18 at 19:44

SSV

95
1
1
11

i tried it on the variables in this function it showed me that jTable1 is null, any ideas? – A.Antho May 05 '18 at 20:36

I am getting a NullPointerException when i run this code

1 Answers1