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
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.