NullPointerException - Using Java to Execute SQL

Question

I have the following Code that throws a null pointer exeption

public void checkAcc(String sql)
{
    System.out.print(sql);   // the statement executed is "SELECT AccountID FROM BankAccount"    
    try {
        stmt.executeQuery(sql);

    } catch (Exception e) {
        System.err.println("Nope that is broken - " + e);
    }
}

First, you don't catch "Exception". [That's a bad idea] (nekulturniy.com/Writings/RebelWithoutAClause/…). And I must guess the line that's giving you the exception is stmt.executeQuery(sql);? Also post the stack trace. — m0skit0
– m0skit0, Commented Feb 28, 2012 at 13:21
Yes, i beleive that it is that line, how do you catch exeption? I am fairly new to java — Olly Stredwick
– Olly Stredwick, Commented Feb 28, 2012 at 13:22
stmt is null. Where have you initialized this statement object? — m0skit0
– m0skit0, Commented Feb 28, 2012 at 13:26

Jim Kiley · Accepted Answer · 2012-02-28 13:23:45Z

2

Have you checked to ensure that stmt isn't null? The way that function is written, it must be a field, and you have to make certain that it has been initialized before checkAcc() is called.

answered Feb 28, 2012 at 13:23

Jim Kiley

3,6523 gold badges29 silver badges43 bronze badges

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

2 Comments

Olly Stredwick Over a year ago

Thanks, it was null due to part of the program not running when it was supposed to. Now I feel slightly Silly. But thanks!

Jim Kiley Over a year ago

If this answer solved your problem, please click the checkmark to note it as the accepted answer. Thanks!

Collectives™ on Stack Overflow

NullPointerException - Using Java to Execute SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related