Thread: Help With Mysql Connection1

Results 1 to 2 of 2
  1. #1 Help With Mysql Connection1 
    Registered Member Nuno555's Avatar
    Join Date
    Sep 2011
    Posts
    330
    Thanks given
    40
    Thanks received
    14
    Rep Power
    0
    Hello Guys I need Help with My Sql it Cant Connect i think when i do ::claim it Appers Me This Error:

    [1/23/12 7:15 AM]: java.lang.NullPointerException
    [1/23/12 7:15 AM]: at server.util.SQL.destroyConnection(SQL.java:65)
    [1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:33)
    [1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:133)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:47)
    [1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:137)
    [1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1226)
    [1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:140)
    [1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
    [1/23/12 7:15 AM]: java.sql.SQLException: Access denied for user '584537_nuno199
    6'@'46.23.70.224' (using password: YES)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.j
    ava:1055)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.j
    ava:956)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
    3536)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
    3468)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
    917)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 397
    4)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 82)

    [1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
    mpl.java:2142)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.j
    ava:773)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion
    .java:46)
    [1/23/12 7:15 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    0(Native Method)
    [1/23/12 7:15 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
    (Unknown Source)
    [1/23/12 7:15 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
    ance(Unknown Source)
    [1/23/12 7:15 AM]: at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onI
    mpl.java:352)
    [1/23/12 7:15 AM]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg ist
    eringDriver.java:282)
    [1/23/12 7:15 AM]: at java.sql.DriverManager.getConnection(Unknown Source)
    [1/23/12 7:15 AM]: at java.sql.DriverManager.getConnection(Unknown Source)
    [1/23/12 7:15 AM]: at server.util.SQL.createConnection(SQL.java:14)
    [1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:34)
    [1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:133)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:47)
    [1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:137)
    [1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1226)
    [1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:140)
    [1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
    [1/23/12 7:15 AM]: java.lang.NullPointerException
    [1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:26)
    [1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
    Commands.java:133)
    [1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
    ommands.java:47)
    [1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
    etHandler.java:137)
    [1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
    nt.java:1226)
    [1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
    ler.java:140)
    [1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
    [1/23/12 7:15 AM]: java.lang.NullPointerException

    Ok Heres my SQL:
    package server.util;
    import java.sql.*;
    import java.security.MessageDigest;
    import server.model.players.Client;

    public class SQL {

    public static Connection con = null;
    public static Statement stmt;
    public static boolean connectionMade;
    public static void createConnection() {
    try {
    Class.forName("com.mysql.jdbc.Driver").newInstance ();
    con = DriverManager.getConnection("jdbc:mysql://localhost/votelunatic_zzl_vote","584537_nuno1996","PassWordR emoved");
    stmt = con.createStatement();
    connectionMade = true;
    } catch (Exception e) {
    connectionMade = false;
    e.printStackTrace();
    }
    }

    public static ResultSet query(String s) throws SQLException {
    try {
    if (s.toLowerCase().startsWith("select")) {
    ResultSet rs = stmt.executeQuery(s);
    return rs;
    } else {
    stmt.executeUpdate(s);
    }
    return null;
    } catch (Exception e) {
    destroyConnection();
    createConnection();
    e.printStackTrace();
    }
    return null;
    }

    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);
    }
    }

    public static void destroyConnection() {
    try {
    stmt.close();
    con.close();
    connectionMade = false;
    } catch (Exception e) {
    e.printStackTrace();
    }
    }

    }

    Please Help Heres My Msn: [email protected]
    Reply With Quote  
     

  2. #2  
    Extreme Donator


    Join Date
    Oct 2006
    Posts
    1,370
    Thanks given
    64
    Thanks received
    197
    Rep Power
    426
    [1/23/12 7:15 AM]: java.sql.SQLException: Access denied for user '584537_nuno199
    6'@'46.23.70.224' (using password: YES)

    Allow remote mysql


    ~flow@hacking . rs
    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. MySQL HELP
    By elderdemons in forum Help
    Replies: 0
    Last Post: 12-03-2010, 12:05 AM
  2. Mysql.
    By Throat in forum Help
    Replies: 3
    Last Post: 11-27-2010, 05:31 PM
  3. MySQL: Cannot Find MySQL Driver
    By Glass O Wine in forum Help
    Replies: 3
    Last Post: 05-02-2010, 11:30 AM
  4. [MySQL]MySQL Intergration By Mikelmao [DELTA]
    By mikelmao in forum Tutorials
    Replies: 16
    Last Post: 12-02-2009, 10:06 AM
  5. Question? MySQL or Non-MySQL
    By Shivers in forum Help
    Replies: 19
    Last Post: 11-29-2009, 06:53 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •