Null pointer exception in con.createStatement();

[Hrishikesh Maluskar]

i am getting null pointer exception at the following line
stmt = con.createStatement();
int val = stmt.executeUpdate("INSERT INTO WEBDB.HNM VALUES('1','hRISHIKESH')");

my code is as follows->

  package net.roseindia;
import com.opensymphony.xwork2.ActionSupport;
import java.util.Date;
import java.sql.*;


/**
 * <p> Validate a user login. </p>
 */
public  class PostAdsFlats  extends ActionSupport {
  
  public String execute() throws Exception {
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "WEBDB";
    String driverName = "org.gjt.mm.mysql.Driver";
    String userName = "mysql";
    String password = "mysql";
    Connection con=null;
    Statement stmt=null;
    try{
      Class.forName(driverName).newInstance();
      con=DriverManager.getConnection(url+dbName, userName, 
          password);
      stmt=con.createStatement();
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    String uname="1";
    String pws="Admin";
    stmt = con.createStatement();
        int val = stmt.executeUpdate("INSERT INTO WEBDB.HNM VALUES('1','hRISHIKESH')"); 
    if(val == 0){
      return ERROR;
    }
    else{
      return SUCCESS;
    }
  }
 
} 
  

[Hrishikesh Maluskar]

to be precise the error is at line number 31

[David Newton]

Not a Struts issue; moving to... JDBC?

[David Newton]

There are several issues with this code, aside from looking like it was written 10 years ago :(

You're obviously not getting a connection when you think you are--any log messages? Is logging turned on at the DEBUG level?

[Jan Cumps]

Hint: you load the driver in the scope of a try block. You try to reuse it outside the scope of the try block.
What happens if you move line 31 and associated lines inside the try?

[Vijitha Kumara]

Can you post the full stack trace ? Apart from the driver name (I'm not sure about that driver class you have used) that code should work as it did for me.

[Hrishikesh Maluskar]

we have to use the following directly or some settings have to be made

  String driverName = "org.gjt.mm.mysql.Driver";  

[Vijitha Kumara]

Hrishikesh Maluskar wrote:we have to use the following directly or some settings have to be made

  String driverName = "org.gjt.mm.mysql.Driver";  

It's apparent that you are using a different driver. I think you should check the documentation of that to see how to connect. For mysql's driver this works fine.

[David Newton]

The old org.gjt... driver is still provided--it's the same driver.

[Hrishikesh Maluskar]

now i am getting this error

Access denied for user 'mysql'@'localhost' (using password: YES)

[ujjwal soni]

Hi,

Looks like there is some problem with your mysql password or username.....

[Hrishikesh Maluskar]

thanks everybody , i installed mysql again and set the username and password to root.