NullPointerException Java MySQL problem

[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.

                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:

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

[VictorN]

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.

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

However the error i am getting is this:

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

pStmt.executeUpdate(...);

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

[Alexz003]

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

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