SyncSQL object is null

Discussion in 'Plugin Development' started by Benedikt Wüller, Oct 1, 2012.

Thread Status:
Not open for further replies.
  1. Hey there,
    I'm back with a new problem: My new created SyncSQL object is null.

    Code:
    Code:java
    1. try {
    2. SyncSQL sql = new SyncSQL(getConfig().getString("config.database.host"), getConfig().getString("config.database.database"), getConfig().getString("config.database.username"), getConfig().getString("config.database.password"));
    3.  
    4. if (sql == null) {
    5. System.out.println("IT'S NULL!!!");
    6. return;
    7. }
    8.  
    9. sql.initialise();
    10.  
    11. if (!sql.doesTableExist(getConfig().getString("config.database.table"))) {
    12. printInfo("Table '" + getConfig().getString("config.database.table") + "' does not exists. Creating table...");
    13. sql.standardQuery("CREATE TABLE " + getConfig().getString("config.database.table") + " ('id' INTEGER PRIMARY KEY, 'username' VARCHAR(50), 'password' VARCHAR(50), 'banned' BOOLEAN));");
    14. printInfo("Table '" + getConfig().getString("config.database.table") + "' successfully created.");
    15. } else {
    16. printInfo("Table '" + getConfig().getString("config.database.table") + "' already exists.");
    17. }
    18.  
    19. sql.closeConnection();
    20. } catch (SQLException ex) {
    21. printInfo(ex.getSQLState());
    22. printError("Could not create table.");
    23. }


    Error:
    Code:
    22:36:25 [SCHWERWIEGEND] [Sync] SQL Exception!
    22:36:25 [SCHWERWIEGEND] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
    : Communications link failure
     
    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance0(Native Method)
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance(NativeConstructorAccessorImpl.java:57)
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.DelegatingConstructorAccessorImpl
    .newInstance(DelegatingConstructorAccessorImpl.java:45)
    22:36:25 [SCHWERWIEGEND]        at java.lang.reflect.Constructor.newInstance(Con
    structor.java:525)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.Util.handleNewInstance(Util.ja
    va:407)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.SQLError.createCommunicationsE
    xception(SQLError.java:1116)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:34
    3)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.coreConnect(Con
    nectionImpl.java:2334)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.connectOneTryOn
    ly(ConnectionImpl.java:2371)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.createNewIO(Con
    nectionImpl.java:2163)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.<init>(Connecti
    onImpl.java:794)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Co
    nnection.java:47)
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance0(Native Method)
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance(NativeConstructorAccessorImpl.java:57)
    22:36:25 [SCHWERWIEGEND]        at sun.reflect.DelegatingConstructorAccessorImpl
    .newInstance(DelegatingConstructorAccessorImpl.java:45)
    22:36:25 [SCHWERWIEGEND]        at java.lang.reflect.Constructor.newInstance(Con
    structor.java:525)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.Util.handleNewInstance(Util.ja
    va:407)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.getInstance(Con
    nectionImpl.java:378)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.NonRegisteringDriver.connect(N
    onRegisteringDriver.java:305)
    22:36:25 [SCHWERWIEGEND]        at java.sql.DriverManager.getConnection(DriverMa
    nager.java:579)
    22:36:25 [SCHWERWIEGEND]        at java.sql.DriverManager.getConnection(DriverMa
    nager.java:221)
    22:36:25 [SCHWERWIEGEND]        at couk.Adamki11s.SQL.SyncSQL.initialise(SyncSQL
    .java:60)
    22:36:25 [SCHWERWIEGEND]        at couk.Adamki11s.SQL.SyncSQL.refreshConnection(
    SyncSQL.java:35)
    22:36:25 [SCHWERWIEGEND]        at couk.Adamki11s.SQL.SyncSQL.doesTableExist(Syn
    cSQL.java:136)
    22:36:25 [SCHWERWIEGEND]        at com.bw2801.plugins.autohomepagelogin.ZZZAutoH
    omepageLogin.test(ZZZAutoHomepageLogin.java:84)
    22:36:25 [SCHWERWIEGEND]        at com.bw2801.plugins.autohomepagelogin.ZZZAutoH
    omepageLogin.onEnable(ZZZAutoHomepageLogin.java:21)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.plugin.java.JavaPlugin.setEnabled(
    JavaPlugin.java:217)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.plugin.java.JavaPluginLoader.enabl
    ePlugin(JavaPluginLoader.java:365)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.plugin.SimplePluginManager.enableP
    lugin(SimplePluginManager.java:381)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.craftbukkit.CraftServer.loadPlugin
    (CraftServer.java:265)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.craftbukkit.CraftServer.enablePlug
    ins(CraftServer.java:247)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.craftbukkit.CraftServer.reload(Cra
    ftServer.java:567)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.Bukkit.reload(Bukkit.java:183)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.command.defaults.ReloadCommand.exe
    cute(ReloadCommand.java:21)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.command.SimpleCommandMap.dispatch(
    SimpleCommandMap.java:168)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.craftbukkit.CraftServer.dispatchCo
    mmand(CraftServer.java:492)
    22:36:25 [SCHWERWIEGEND]        at org.bukkit.craftbukkit.CraftServer.dispatchSe
    rverCommand(CraftServer.java:488)
    22:36:25 [SCHWERWIEGEND]        at net.minecraft.server.DedicatedServer.ah(Dedic
    atedServer.java:248)
    22:36:25 [SCHWERWIEGEND]        at net.minecraft.server.DedicatedServer.q(Dedica
    tedServer.java:213)
    22:36:25 [SCHWERWIEGEND]        at net.minecraft.server.MinecraftServer.p(Minecr
    aftServer.java:474)
    22:36:25 [SCHWERWIEGEND]        at net.minecraft.server.MinecraftServer.run(Mine
    craftServer.java:406)
    22:36:25 [SCHWERWIEGEND]        at net.minecraft.server.ThreadServerApplication.
    run(SourceFile:539)
    22:36:25 [SCHWERWIEGEND] Caused by: java.net.ConnectException: Connection timed
    out: connect
    22:36:25 [SCHWERWIEGEND]        at java.net.DualStackPlainSocketImpl.connect0(Na
    tive Method)
    22:36:25 [SCHWERWIEGEND]        at java.net.DualStackPlainSocketImpl.socketConne
    ct(DualStackPlainSocketImpl.java:69)
    22:36:25 [SCHWERWIEGEND]        at java.net.AbstractPlainSocketImpl.doConnect(Ab
    stractPlainSocketImpl.java:337)
    22:36:25 [SCHWERWIEGEND]        at java.net.AbstractPlainSocketImpl.connectToAdd
    ress(AbstractPlainSocketImpl.java:198)
    22:36:25 [SCHWERWIEGEND]        at java.net.AbstractPlainSocketImpl.connect(Abst
    ractPlainSocketImpl.java:180)
    22:36:25 [SCHWERWIEGEND]        at java.net.PlainSocketImpl.connect(PlainSocketI
    mpl.java:157)
    22:36:25 [SCHWERWIEGEND]        at java.net.SocksSocketImpl.connect(SocksSocketI
    mpl.java:391)
    22:36:25 [SCHWERWIEGEND]        at java.net.Socket.connect(Socket.java:579)
    22:36:25 [SCHWERWIEGEND]        at java.net.Socket.connect(Socket.java:528)
    22:36:25 [SCHWERWIEGEND]        at java.net.Socket.<init>(Socket.java:425)
    22:36:25 [SCHWERWIEGEND]        at java.net.Socket.<init>(Socket.java:241)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.StandardSocketFactory.connect(
    StandardSocketFactory.java:254)
    22:36:25 [SCHWERWIEGEND]        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:29
    2)
    22:36:25 [SCHWERWIEGEND]        ... 35 more
    Line 84 ist this:
    Code:
    sql.initialise();
    Any ideas how to fix this?
    The database informations in the config are correct.
     
  2. Offline

    LucasEmanuel

    You sure you posted the correct stack-trace? That one just says the connection to the database timed out.
     
Thread Status:
Not open for further replies.

Share This Page