permaculture playing cards*
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 Android Security Essentials Live Lessons this week in the Android 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: 3817

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?)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: NullPointerException when trying to connect to MySQL Database
 
Similar Threads
how will we move from one page to another within the same window in Swing?
Please help me solve my problem
Networked Programs that work across countries
Problem adding JComboBox to JFrame
Line Spacing in jTextPane