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.
However the error i am getting is this: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)); }
The line the nullPointer is coming up at is in red.Code:Exception in thread "main" java.lang.NullPointerException at Main.Database.getDateData(Database.java:193) at Main.Main.main(Main.java:23)
I have tried using both executeQuery and executeUpdate.
Thanks
-Alex




Reply With Quote