Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NullPointerException when trying to connect to MySQL Database

 
Patrick Boos
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 3918
10
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the detailed stack trace of the exception? That might help to figure out whats wrong.
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic