Getting MySQL credentials from config

Hi guys,
I'd like to read my MySQL credentials from the config file in order to create the Connection object. I wrote following code:

Code:java

public static Connection connection;
    public static Main plugin;
 
    public MySQL(Main plugin) {
        this.plugin = plugin;
    }
 
    public static synchronized void openConnection() {
        try {
            connection = DriverManager.getConnection("jdbc:mysql://"
                    + plugin.getConfig().getString("MySQL.Host") + ":"
                    + plugin.getConfig().getString("MySQL.Port") + "/"
                    + plugin.getConfig().getString("MySQL.DB"), plugin
                    .getConfig().getString("MySQL.User"), plugin.getConfig()
                    .getString("MySQL.Password"));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

My config.yml looks so:

Code:

MySQL:
  Host: localhost
  Port: 3306
  DB: bukkit
  User: root
  Pass: xxxxx
  

But whenever I try to use the openConnection method, I get a NullPoinetrExecption:

Code:java

16:16:28 [SEVERE] java.lang.NullPointerException
16:16:28 [SEVERE]      at es.programahermes.MySQL.openConnection(MySQL.java:22)
16:16:28 [SEVERE]      at es.programahermes.MySQL.dbContanisPlayer(MySQL.java:43)
16:16:28 [SEVERE]      at es.programahermes.Utilidades.PointsAdjust$1.run(PointsAdjust.java:21)
16:16:28 [SEVERE]      at org.bukkit.craftbukkit.v1_6_R3.scheduler.CraftTask.run(CraftTask.java:53)
16:16:28 [SEVERE]      at org.bukkit.craftbukkit.v1_6_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
16:16:28 [SEVERE]      at net.minecraft.server.v1_6_R3.MinecraftServer.t(MinecraftServer.java:524)
16:16:28 [SEVERE]      at net.minecraft.server.v1_6_R3.DedicatedServer.t(DedicatedServer.java:227)
16:16:28 [SEVERE]      at net.minecraft.server.v1_6_R3.MinecraftServer.s(MinecraftServer.java:488)
16:16:28 [SEVERE]      at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java:421)
16:16:28 [SEVERE]      at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:583)
16:16:28 [INFO] Error al conectar con la base de datos. Revisar credenciales.
16:16:28 [WARNING] [HermesCore] Task #12 for HermesCore v0.2 generated an exception
java.lang.NullPointerException
 

Any help will be appreciated

 

Pitazzo
Config may be null on first start up if the config isn't generated before invoking openConnection.

 

Pitazzo remove all the static keywords

 

Gater12
I know it, but it'snt the problem; the config is generated.

Thanks

fireblast709 No way, I need to access the method from other classes

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Pitazzo then learn how to do this without static, because you obviously have no idea how to properly implent it with (and static isn't the preferred way anyway) .

Just use the constructor to pass along refences, and a non static getter function to retrieve the connection.