Two Laptop Bag*
The moose likes Beginning Java and the fly likes NullPointerException on PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "NullPointerException on PreparedStatement" Watch "NullPointerException on PreparedStatement" New topic
Author

NullPointerException on PreparedStatement

Peter Dennis
Greenhorn

Joined: Nov 30, 2008
Posts: 12
Hi All,

Could someone please tell me what kind of conditions could cause the NullPointerException?

My code looks like this:



Many thanks,

Peter.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38108
    
  22
Welcome to JavaRanch

You are not getting an SQLException anywhere?
As you doubtless already know, NullPointerExceptions (NPEs) are very common and very annoying. I seem to write about them all the time, most recently here (note there is a mistake which I picked up later).

Are you sure your connection isn't null?

I presume the SQL is correct; it looks all right, and it would produce an SQLException rather than an NPE.

Go through what I wrote, and add a line just before where you get your Exception which prints whether the connection is null. See whether that helps.

I probably can't help any more now; it is too late, but there will be other people around.
Peter Dennis
Greenhorn

Joined: Nov 30, 2008
Posts: 12
Thanks very much for that. The null connection was the problem.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38108
    
  22
You're welcome. It was easy to guess from the info you provided.
 
wood burning stoves
 
subject: NullPointerException on PreparedStatement
 
Similar Threads
java.sql.SQLException: Stream has already been closed
Calling SQL stored procedure from statment?
ejbLoad is not getting called
Trouble with regular expressions
ORA-01002 fetch out of sequence