aspose file tools*
The moose likes JDBC and the fly likes NullPointerException when trying to connect to MySQL Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "NullPointerException when trying to connect to MySQL Database" Watch "NullPointerException when trying to connect to MySQL Database" New topic
Author

NullPointerException when trying to connect to MySQL Database

Patrick Boos
Greenhorn

Joined: Sep 09, 2008
Posts: 15
Hello,
I am trying to insert values from a .csv file into a MySQL database from a GUI. I cannot seem to accomplish this. I keep getting a null pointer exception where I set the connection properties in my main method. I also cannot seem to figure out how to use the importData() method after setting my variables in my GUI. I currently have that method called in the main method. I would appreciate any help anyone can give me. Thank you. Here is my code:

Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3838

What is the detailed stack trace of the exception? That might help to figure out whats wrong.


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
If an exception is been thrown in your connect() method you're completely ignoring the exception, only printing the trace and returning null.

That is indeed asking for trouble. The returned connection should in no way be null. You know, if you invoke/access some object reference which is actually null, you'll see NullPointerExceptions flying around. And that would happen when you call Connection#createStatement().

(didn't you notice the printed trace from connect() by the way?)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: NullPointerException when trying to connect to MySQL Database