So the problem for me in this tut Here isn't website sided, i got all that down on my trublood.site90.com/vote and it works.
But in server sided i added it and when i do the command ::check
Code:
if (playerCommand.equalsIgnoreCase("check") || playerCommand.equalsIgnoreCase("reward") || playerCommand.equalsIgnoreCase("claim")) {
try {
VoteReward reward = Server.voteChecker.getReward(c.playerName.replaceAll(" ", "_"));
if(reward != null){
switch(reward.getReward()){
case 0:
c.votingPoints += 1;
break;
case 1:
c.getItems().addItem(995, 10000000);
break;
default:
c.sendMessage("Reward not found.");
break;
}
c.sendMessage("Thank you for voting.");
} else {
c.sendMessage("You have no items waiting for you.");
}
} catch (Exception e){
c.sendMessage("An error occurred please try again later.");
}
}
after the person doese the command, the server is completely frozen (nothing on console) fo about 15 seconds then it lags everybody out of the server (including myself and the voter) and i get a biiigg error on my server console but nothing client sided. after about 30 seconds everybody can log back in...
Here's the error:
Code:
[7/30/12 8:03 PM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 1,343,703,785,415 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[7/30/12 8:03 PM]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
[7/30/12 8:03 PM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
[7/30/12 8:03 PM]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
[7/30/12 8:03 PM]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[7/30/12 8:03 PM]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
[7/30/12 8:03 PM]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
[7/30/12 8:03 PM]: at java.sql.DriverManager.getConnection(Unknown Source)
[7/30/12 8:03 PM]: at java.sql.DriverManager.getConnection(Unknown Source)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLConnectionPool.getFreeConnection(MySQLConnectionPool.java:61)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:29)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:1)
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask.run(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[7/30/12 8:03 PM]: at java.lang.Thread.run(Unknown Source)
[7/30/12 8:03 PM]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 1,343,703,785,414 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[7/30/12 8:03 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[7/30/12 8:03 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[7/30/12 8:03 PM]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
[7/30/12 8:03 PM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[7/30/12 8:03 PM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
[7/30/12 8:03 PM]: ... 19 more
[7/30/12 8:03 PM]: Caused by: java.net.ConnectException: Connection timed out: connect
[7/30/12 8:03 PM]: at java.net.DualStackPlainSocketImpl.connect0(Native Method)
[7/30/12 8:03 PM]: at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
[7/30/12 8:03 PM]: at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.PlainSocketImpl.connect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.SocksSocketImpl.connect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.Socket.connect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.Socket.connect(Unknown Source)
[7/30/12 8:03 PM]: at java.net.Socket.<init>(Unknown Source)
[7/30/12 8:03 PM]: at java.net.Socket.<init>(Unknown Source)
[7/30/12 8:03 PM]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
[7/30/12 8:03 PM]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
[7/30/12 8:03 PM]: ... 20 more
[7/30/12 8:03 PM]: java.util.concurrent.ExecutionException: java.lang.NullPointerException
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask.get(Unknown Source)
[7/30/12 8:03 PM]: at org.runetoplist.VoteChecker.getReward(VoteChecker.java:40)
[7/30/12 8:03 PM]: at server.model.players.packets.Commands.processPacket(Commands.java:159)
[7/30/12 8:03 PM]: at server.model.players.PacketHandler.processPacket(PacketHandler.java:139)
[7/30/12 8:03 PM]: at server.model.players.Client.processQueuedPackets(Client.java:1019)
[7/30/12 8:03 PM]: at server.model.players.PlayerHandler.process(PlayerHandler.java:136)
[7/30/12 8:03 PM]: at server.Server.main(Server.java:143)
[7/30/12 8:03 PM]: Caused by: java.lang.NullPointerException
[7/30/12 8:03 PM]: at org.runetoplist.PoolConnection.borrow(PoolConnection.java:27)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLConnectionPool.getFreeConnection(MySQLConnectionPool.java:66)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:29)
[7/30/12 8:03 PM]: at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:1)
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.FutureTask.run(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[7/30/12 8:03 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[7/30/12 8:03 PM]: at java.lang.Thread.run(Unknown Source)
idk whats wrong... anybody?