This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Null pointer exception in con.createStatement(); (Struts 2 using netbeans6.1 and MYSQL)

 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am creating a application in struts2 using netbeans 6.1. I have done database connection with MYSQL from netbeans. It also shows connection successful , but gives null pointer exception on this line -> con.createStatement();

Log is as folllows->

java.lang.NullPointerException
at net.roseindia.Login.execute(Login.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly
 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

then con is null.

how do you initialize this variable con? (post some code)

Herman
 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have pasted the code below , it shows null pointer exception on the line indicated as ##.

 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

my guess is that

throws a ClassNotFoundException


might be in your log, but it's only 1 line, easy to overlook.

Why not change it into


Good luck!

Herman
PS Please copy/paste from your log if you reply.
 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


for the above code i got the following error in the log...how to get around it

 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

if the e.getMessage() does not give enough information, add the class of the exception


It will probably give you a ClassNotFoundException, here's how to solve it:

If you have a connection from Netbeans to your MySQL database, that does not mean that your application can connect to the MySQL database.
You will have to add the mysql driver (the .jar file that it's in) to your webapplication (just put the jar file the lib folder of your webapplication), or add that .jar file to the classpath of your server.

Herman
 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks herman...now i am able to connect to MYSQL
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic