While creating a table in MySql database, NullPointerException encountered

Question

With Netbeans 8.2, It runs perfectly.

But in Eclipse Neon 3, after adding mysql connector jar, still the problem persists

import java.io.FileInputStream;
import java.sql.*;
import java.util.Properties;

public class Table {

    public static void main(String[] args) {

        try {
            FileInputStream f = new FileInputStream("db.properties");
            Properties p = new Properties();
            p.load(f);
            String qry = "Create table Table1(values integer(2) primary key)";
            String driver_name = p.getProperty("Driver");
            String url = p.getProperty("url");
            Class.forName(driver_name);
            Connection c = DriverManager.getConnection(url, p);
            Statement s = c.createStatement();
            s.execute(qry);
            System.out.println("Table created successfully!");
        }

        catch (Exception e) {
            e.printStackTrace();
        }
    }
}

What MySQL version are you using? Following the 5.5 syntax you don't need "values" in the query: dev.mysql.com/doc/refman/5.5/en/creating-tables.html — Rafael R. S. Robles
– Rafael R. S. Robles, Commented Jun 9, 2017 at 20:08

Nigel Ren · Accepted Answer · 2017-06-09 20:50:53Z

1

'Values' is a reserved word, so preferably change it or use back ticks to make sure it's dealt with as a column name...

String qry = "Create table Table1(`values` integer(2) primary key)";

answered Jun 9, 2017 at 20:50

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rakesh Mishra Over a year ago

That's not an issue here. I made it back, Thanks for your valuable feedback!

Collectives™ on Stack Overflow

While creating a table in MySql database, NullPointerException encountered

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related