Thread: Getting a error after adding vote4cash

Results 1 to 3 of 3
  1. #1 Getting a error after adding vote4cash 
    Extreme Donator


    Join Date
    Dec 2011
    Posts
    323
    Thanks given
    92
    Thanks received
    46
    Rep Power
    81
    Spoiler for Error:
    [2/21/12 8:47 AM]: olem playerCommand: check
    [2/21/12 8:47 AM]: java.lang.NullPointerException
    [2/21/12 8:47 AM]: at server.util.SQL.destroyConnection(SQL.java:44)
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:35)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Comm
    unications link failure

    The last packet successfully received from the server was 1,329,842,830,823 mill
    iseconds ago. The last packet sent successfully to the server was 0 millisecond
    s ago.
    [2/21/12 8:47 AM]: at sun.reflect.GeneratedConstructorAccessor4.newInsta nce
    (Unknown Source)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.SQLError.createCommunicationsExcept ion
    (SQLError.java:1074)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
    mpl.java:2214)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.j
    ava:773)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion
    .java:46)
    [2/21/12 8:47 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    0(Native Method)
    [2/21/12 8:47 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    (NativeConstructorAccessorImpl.java:57)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onI
    mpl.java:352)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg ist
    eringDriver.java:282)
    [2/21/12 8:47 AM]: at java.sql.DriverManager.getConnection(DriverManager .ja
    va:579)
    [2/21/12 8:47 AM]: at java.sql.DriverManager.getConnection(DriverManager .ja
    va:221)
    [2/21/12 8:47 AM]: at server.util.SQL.createConnection(SQL.java:19)
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:36)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce
    ption: Communications link failure

    The last packet successfully received from the server was 1,329,842,830,823 mill
    iseconds ago. The last packet sent successfully to the server was 0 millisecond
    s ago.
    [2/21/12 8:47 AM]: at sun.reflect.GeneratedConstructorAccessor4.newInsta nce
    (Unknown Source)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.SQLError.createCommunicationsExcept ion
    (SQLError.java:1074)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
    mpl.java:2137)
    [2/21/12 8:47 AM]: ... 20 more
    [2/21/12 8:47 AM]: Caused by: java.net.ConnectException: Connection refused: con
    nect
    [2/21/12 8:47 AM]: at java.net.DualStackPlainSocketImpl.connect0(Native Met
    hod)
    [2/21/12 8:47 AM]: at java.net.DualStackPlainSocketImpl.socketConnect(Du alS
    tackPlainSocketImpl.java:69)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.doConnect(Abstrac tPl
    ainSocketImpl.java:339)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.connectToAddress( Abs
    tractPlainSocketImpl.java:200)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.connect(AbstractP lai
    nSocketImpl.java:182)
    [2/21/12 8:47 AM]: at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava
    :157)
    [2/21/12 8:47 AM]: at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava
    :391)
    [2/21/12 8:47 AM]: at java.net.Socket.connect(Socket.java:579)
    [2/21/12 8:47 AM]: at java.net.Socket.connect(Socket.java:528)
    [2/21/12 8:47 AM]: at java.net.Socket.<init>(Socket.java:425)
    [2/21/12 8:47 AM]: at java.net.Socket.<init>(Socket.java:241)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.StandardSocketFactory.connect(Stand ard
    SocketFactory.java:253)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
    [2/21/12 8:47 AM]: ... 21 more
    [2/21/12 8:47 AM]: java.lang.NullPointerException
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:28)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: java.lang.NullPointerException
    [2/21/12 8:47 AM]: sam playerCommand: check
    [2/21/12 8:47 AM]: java.lang.NullPointerException
    [2/21/12 8:47 AM]: at server.util.SQL.destroyConnection(SQL.java:44)
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:35)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Comm
    unications link failure

    The last packet successfully received from the server was 1,329,842,832,885 mill
    iseconds ago. The last packet sent successfully to the server was 0 millisecond
    s ago.
    [2/21/12 8:47 AM]: at sun.reflect.GeneratedConstructorAccessor4.newInsta nce
    (Unknown Source)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.SQLError.createCommunicationsExcept ion
    (SQLError.java:1074)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
    mpl.java:2214)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.j
    ava:773)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion
    .java:46)
    [2/21/12 8:47 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    0(Native Method)
    [2/21/12 8:47 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    (NativeConstructorAccessorImpl.java:57)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onI
    mpl.java:352)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg ist
    eringDriver.java:282)
    [2/21/12 8:47 AM]: at java.sql.DriverManager.getConnection(DriverManager .ja
    va:579)
    [2/21/12 8:47 AM]: at java.sql.DriverManager.getConnection(DriverManager .ja
    va:221)
    [2/21/12 8:47 AM]: at server.util.SQL.createConnection(SQL.java:19)
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:36)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce
    ption: Communications link failure

    The last packet successfully received from the server was 1,329,842,832,885 mill
    iseconds ago. The last packet sent successfully to the server was 0 millisecond
    s ago.
    [2/21/12 8:47 AM]: at sun.reflect.GeneratedConstructorAccessor4.newInsta nce
    (Unknown Source)
    [2/21/12 8:47 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [2/21/12 8:47 AM]: at java.lang.reflect.Constructor.newInstance(Construc tor
    .java:525)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.SQLError.createCommunicationsExcept ion
    (SQLError.java:1074)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
    mpl.java:2137)
    [2/21/12 8:47 AM]: ... 20 more
    [2/21/12 8:47 AM]: Caused by: java.net.ConnectException: Connection refused: con
    nect
    [2/21/12 8:47 AM]: at java.net.DualStackPlainSocketImpl.connect0(Native Met
    hod)
    [2/21/12 8:47 AM]: at java.net.DualStackPlainSocketImpl.socketConnect(Du alS
    tackPlainSocketImpl.java:69)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.doConnect(Abstrac tPl
    ainSocketImpl.java:339)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.connectToAddress( Abs
    tractPlainSocketImpl.java:200)
    [2/21/12 8:47 AM]: at java.net.AbstractPlainSocketImpl.connect(AbstractP lai
    nSocketImpl.java:182)
    [2/21/12 8:47 AM]: at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava
    :157)
    [2/21/12 8:47 AM]: at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava
    :391)
    [2/21/12 8:47 AM]: at java.net.Socket.connect(Socket.java:579)
    [2/21/12 8:47 AM]: at java.net.Socket.connect(Socket.java:528)
    [2/21/12 8:47 AM]: at java.net.Socket.<init>(Socket.java:425)
    [2/21/12 8:47 AM]: at java.net.Socket.<init>(Socket.java:241)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.StandardSocketFactory.connect(Stand ard
    SocketFactory.java:253)
    [2/21/12 8:47 AM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
    [2/21/12 8:47 AM]: ... 21 more
    [2/21/12 8:47 AM]: java.lang.NullPointerException
    [2/21/12 8:47 AM]: at server.util.SQL.query(SQL.java:28)
    [2/21/12 8:47 AM]: at server.util.SQL.checkVote(SQL.java:56)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:84)
    [2/21/12 8:47 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:46)
    [2/21/12 8:47 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:139)
    [2/21/12 8:47 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1810)
    [2/21/12 8:47 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:149)
    [2/21/12 8:47 AM]: at server.Server.main(Server.java:181)
    [2/21/12 8:47 AM]: java.lang.NullPointerException


    Seems to be a issue with the command or something, at least i get the error when i use the command. Also getting same/similar error when i type other commands)
    Spoiler for Command i added":
    if (playerCommand.startsWith("check") || playerCommand.startsWith("reward")) {
    try {
    SQL.checkVote(c);
    } catch(Exception e) {
    System.out.println(e);
    }

    Spoiler for mysql.java:
    public static void checkVote(Client c) {
    try {
    if(c.getItems().freeSlots() > 0) {
    //Statement stmt = con.createStatement();
    ResultSet rs = query("SELECT id,item_id, item_amount FROM `items` WHERE `username`= '" + c.playerName + "' AND `claimed`= '0'");
    if(rs.next()) {
    int rowid = rs.getInt("id");
    int itemid = rs.getInt("item_id");
    int amount = rs.getInt("item_amount");
    query("UPDATE `items` SET `claimed` = 1 WHERE `username` = '" + c.playerName + "' AND `id`='" + rowid + "'");
    c.getItems().addItem(itemid, amount);
    c.sendMessage("You receive "+amount+" X "+c.getItems().getItemName(itemid)+".");
    } else {
    c.sendMessage("No items waiting for you.");
    }
    } else {
    c.sendMessage("Please make space for your items.");
    }
    } catch (SQLException ex) {
    System.out.println(ex);
    }
    }


    Tut i followed: http://www.rune-server.org/runescape...ote4items.html
    Reply With Quote  
     

  2. #2  
    Extreme Donator


    Join Date
    Dec 2011
    Posts
    323
    Thanks given
    92
    Thanks received
    46
    Rep Power
    81
    Daily bump
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Feb 2012
    Posts
    368
    Thanks given
    24
    Thanks received
    26
    Rep Power
    14
    Your not connecting to Mysql

    Code:
    Communications link failure
    Did i help you? All i ask in return is thanks/Rep.



    Quote Originally Posted by rustigold View Post
    iknow, but i fail.
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. vote4cash error
    By Ch3ck it S0n in forum Help
    Replies: 8
    Last Post: 02-13-2012, 12:49 AM
  2. [vote4cash] adding paying!
    By erasedpvp in forum Help
    Replies: 0
    Last Post: 02-09-2012, 10:58 AM
  3. Replies: 12
    Last Post: 08-03-2011, 11:46 PM
  4. 317 [pi] adding vote4cash & highscores
    By ladesman120 in forum Requests
    Replies: 10
    Last Post: 06-27-2011, 06:40 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •