Advertisement
Guest User

Untitled

a guest
Feb 2nd, 2017
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.69 KB | None | 0 0
  1. java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  2. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548)
  3. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  4. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145)
  5. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)
  6. at de.arraying.Arraybot.managers.ManagerSync.addCustomCommand(ManagerSync.java:192)
  7. at de.arraying.Arraybot.commands.CommandsCommand.onCommand(CommandsCommand.java:100)
  8. at de.arraying.Arraybot.commands.Command.execute(Command.java:72)
  9. at de.arraying.Arraybot.listeners.ListenerChat.onGuildMessageReceived(ListenerChat.java:68)
  10. at net.dv8tion.jda.core.hooks.ListenerAdapter.onEvent(ListenerAdapter.java:299)
  11. at net.dv8tion.jda.core.hooks.InterfacedEventManager.handle(InterfacedEventManager.java:64)
  12. at net.dv8tion.jda.core.handle.MessageCreateHandler.handleDefaultMessage(MessageCreateHandler.java:97)
  13. at net.dv8tion.jda.core.handle.MessageCreateHandler.handleInternally(MessageCreateHandler.java:47)
  14. at net.dv8tion.jda.core.handle.SocketHandler.handle(SocketHandler.java:38)
  15. at net.dv8tion.jda.core.requests.WebSocketClient.handleEvent(WebSocketClient.java:688)
  16. at net.dv8tion.jda.core.requests.WebSocketClient.onTextMessage(WebSocketClient.java:437)
  17. at com.neovisionaries.ws.client.ListenerManager.callOnTextMessage(ListenerManager.java:352)
  18. at com.neovisionaries.ws.client.ReadingThread.callOnTextMessage(ReadingThread.java:262)
  19. at com.neovisionaries.ws.client.ReadingThread.callOnTextMessage(ReadingThread.java:240)
  20. at com.neovisionaries.ws.client.ReadingThread.handleTextFrame(ReadingThread.java:965)
  21. at com.neovisionaries.ws.client.ReadingThread.handleFrame(ReadingThread.java:748)
  22. at com.neovisionaries.ws.client.ReadingThread.main(ReadingThread.java:110)
  23. at com.neovisionaries.ws.client.ReadingThread.run(ReadingThread.java:66)
  24.  
  25. HikariConfig hikariConfig = new HikariConfig();
  26. hikariConfig.setJdbcUrl("jdbc:mysql://"+url+":3306/"+database+"?useSSL=false");
  27. hikariConfig.setUsername(username);
  28. hikariConfig.setPassword(password);
  29. hikariConfig.setMaximumPoolSize(10);
  30. hikariConfig.setMinimumIdle(3);
  31. hikariConfig.setLeakDetectionThreshold(2000);
  32. dataSource = new HikariDataSource(hikariConfig);
  33.  
  34. // inside a try/catch, after some checks that aren't related.
  35. PreparedStatement preparedStatement =
  36. dataSource.getConnection().prepareStatement(query);
  37. preparedStatement.setString(2, id);
  38. preparedStatement.setString(3, name);
  39. preparedStatement.setObject(1, value);
  40. preparedStatement.executeUpdate();
  41. preparedStatement.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement