MySQL connection error...

Discussion in 'Plugin Development' started by D3_M0N, Nov 6, 2014.

Thread Status:
Not open for further replies.
  1. Offline

    D3_M0N

    Heyho

    i try to do my own ranker plugin and ive a strange problem.....

    on my windows pc my sql connection works fine...

    but on our Linux root it wont:-(

    connector:
    Code:java
    1. public synchronized void setupDB() {
    2. try {
    3. Class.forName("com.mysql.jdbc.Driver");
    4. connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/sr", "SR", "123456");
    5.  
    6. String query = "CREATE TABLE IF NOT EXISTS `simpleranker` (`Name` varchar(32) UNIQUE,"
    7. + "`Time` int NOT NULL default 0,"
    8. + "`Pvp` int NOT NULL default 0,"
    9. + "`Pve` int NOT NULL default 0,"
    10. + "`Deaths` int NOT NULL default 0,"
    11. + "`Country` varchar(32))";
    12. PreparedStatement ps = connection.prepareStatement(query);
    13. ps.execute();
    14. ps.close();
    15. e.printStackTrace();
    16. }
    17. }




    here is the stacktrace:
    Code:java
    1. 07:26:55
    2. CONSOLE:
    3. [SCHWERWIEGEND] at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    4. 07:26:55
    5. CONSOLE:
    6. [SCHWERWIEGEND] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    7. 07:26:55
    8. CONSOLE:
    9. [SCHWERWIEGEND] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    10. 07:26:55
    11. CONSOLE:
    12. [SCHWERWIEGEND] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    13. 07:26:55
    14. CONSOLE:
    15. [SCHWERWIEGEND] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    16. 07:26:55
    17. CONSOLE:
    18. [SCHWERWIEGEND] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    19. 07:26:55
    20. CONSOLE:
    21. [SCHWERWIEGEND] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    22. 07:26:55
    23. CONSOLE:
    24. [SCHWERWIEGEND] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    25. 07:26:55
    26. CONSOLE:
    27. [SCHWERWIEGEND] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    28. 07:26:55
    29. CONSOLE:
    30. [SCHWERWIEGEND] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    31. 07:26:55
    32. CONSOLE:
    33. [SCHWERWIEGEND] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    34. 07:26:55
    35. CONSOLE:
    36. [SCHWERWIEGEND] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    37. 07:26:55
    38. CONSOLE:
    39. [SCHWERWIEGEND] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    40. 07:26:55
    41. CONSOLE:
    42. [SCHWERWIEGEND] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    43. 07:26:55
    44. CONSOLE:
    45. [SCHWERWIEGEND] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    46. 07:26:55
    47. CONSOLE:
    48. [SCHWERWIEGEND] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    49. 07:26:55
    50. CONSOLE:
    51. [SCHWERWIEGEND] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    52. 07:26:55
    53. CONSOLE:
    54. [SCHWERWIEGEND] at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    55. 07:26:55
    56. CONSOLE:
    57. [SCHWERWIEGEND] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    58. 07:26:55
    59. CONSOLE:
    60. [SCHWERWIEGEND] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    61. 07:26:55
    62. CONSOLE:
    63. [SCHWERWIEGEND] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    64. 07:26:55
    65. CONSOLE:
    66. [SCHWERWIEGEND] at java.sql.DriverManager.getConnection(DriverManager.java:571)
    67. 07:26:55
    68. CONSOLE:
    69. [SCHWERWIEGEND] at java.sql.DriverManager.getConnection(DriverManager.java:215)
    70. 07:26:55
    71. CONSOLE:
    72. [SCHWERWIEGEND] at me.d3_m0n.simpleranker.SimpleRanker.setupDB(SimpleRanker.java:89)
    73. 07:26:55
    74. CONSOLE:
    75. [SCHWERWIEGEND] at me.d3_m0n.simpleranker.SimpleRanker$1.run(SimpleRanker.java:61)
    76. 07:26:55
    77. CONSOLE:
    78. [SCHWERWIEGEND] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftTask.run(CraftTask.java:53)
    79. 07:26:55
    80. CONSOLE:
    81. [SCHWERWIEGEND] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
    82. 07:26:55
    83. CONSOLE:
    84. [SCHWERWIEGEND] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    85. 07:26:55
    86. CONSOLE:
    87. [SCHWERWIEGEND] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    88. 07:26:55
    89. CONSOLE:
    90. [SCHWERWIEGEND] at java.lang.Thread.run(Thread.java:744)
     
  2. Offline

    ResultStatic

    D3_M0N that doesnt seem like a full stack trace, and 'SR' is the name of your database correct?
     
  3. Offline

    D3_M0N

    yea sr is my db and SR is the user

    And its the full trace-.- thats why i dont know whats wrong^^

    ok my mcmyadmin is stupid........ got the problem.... so SOLVED^^

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 14, 2016
  4. Offline

    ResultStatic

    D3_M0N well im not really sure whats causing your problem, but i created a class that gets the connection object in a different way (through connection pooling) its suppose to be more efficient, but it is more complex. you can try using it and see if that fixes the problem. http://forums.bukkit.org/threads/connection-pooling-class.318669/

    remember to tag me if you have any issues.
     
Thread Status:
Not open for further replies.

Share This Page