NullPointerException Java MySQL problem

Hello, i'm working with SQL's and in this bit of code i'm basically trying to fetch the data located in the 'date' column in my table.

Code:

---

                Statement pStmt = null;
                pStmt.executeUpdate("SELECT date FROM " + ticker);
                RS = pStmt.getResultSet();
                ArrayList<Date> dates = new ArrayList<Date>();
                while(RS.next())
                {
                        if(RS.wasNull())
                                System.out.println("Null");
                        else
                                System.out.println("Not Null");
                        System.out.println(RS.getDate(1));
                        dates.add(RS.getDate(1));
                }

---

However the error i am getting is this:

Code:

---

Exception in thread "main" java.lang.NullPointerException
        at Main.Database.getDateData(Database.java:193)
        at Main.Main.main(Main.java:23)

---

The line the nullPointer is coming up at is in red.

I have tried using both executeQuery and executeUpdate.

Thanks

-Alex

Quote:

---

Originally Posted by Alexz003

Hello, i'm working with SQL's and in this bit of code i'm basically trying to fetch the data located in the 'date' column in my table.

Code:

---

                Statement pStmt = null;
                pStmt.executeUpdate("SELECT date FROM " + ticker);

---

However the error i am getting is this:

Code:

---

Exception in thread "main" java.lang.NullPointerException
        at Main.Database.getDateData(Database.java:193)
        at Main.Main.main(Main.java:23)

---

The line the nullPointer is coming up at is in red.

---

You set the Statement pStmt to null. And after that you are trying to execute

Code:

---

pStmt.executeUpdate(...);

---

with the NULL-pointer!
So why do you wonder getting the error message? :confused:

I actually figured it out.

Originally i was using a PreparedStatement and set it = to null. i forgot to prepare the statement and then execute it...

So the final code was

Code:

---

                PreparedStatement pStmt = conn.prepareStatement("SELECT date FROM " + ticker);
                pStmt.executeQuery();
                RS = pStmt.getResultSet();

---