[编程]JdbcConnectionBridge —— 使用HikariCP连接池建立MySQL连接[全版本]

这个怎么用呢？放在哪了？BC？

本插件为spigot插件，并且只是一个前置，需要其他插件配合使用，装在同一个服务器里

哦！谢谢

请问怎么填数据库连接信息

按照配置文件
分别填写地址
用户名
密码
一般情况只需填写default的信息

我用这个插件得话，不知道是否因为max lifetime设置得为30minutes
如果长期挂着服务器，会提示Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl

提示: 作者被禁止或删除 内容自动屏蔽

完整报错发一下

[01:54:35] [luckperms-scheduler-worker-0/WARN]: [me.lucko.luckperms.lib.hikari.pool.PoolBase] luckperms-hikari - Failed to validate connection me.lucko.luckperms.lib.mysql.jdbc.JDBC4Connection@51f1c394 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

[02:24:10] [Craft Scheduler Thread - 151/WARN]: [com.zaxxer.hikari.pool.PoolBase] HikariPool-1 - Failed to validate connection com.mysql.jdbc.JDBC4Connection@76e48511 (No operations allowed after connection closed.)

[03:33:44] [Server thread/WARN]: The last packet successfully received from the server was 3,953,113 milliseconds ago.  The last packet sent successfully to the server was 3,953,149 milliseconds ago.
[03:33:44] [Server thread/WARN]:         at sun.reflect.GeneratedConstructorAccessor180.newInstance(Unknown Source)
[03:33:44] [Server thread/WARN]:         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[03:33:44] [Server thread/WARN]:         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3746)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2509)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[03:33:44] [Server thread/WARN]:         at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[03:33:44] [Server thread/WARN]:         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[03:33:44] [Server thread/WARN]:         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[03:33:44] [Server thread/WARN]:         at me.zhanshi123.globalprefix.Database.getData(Database.java:82)
[03:33:44] [Server thread/WARN]:         at me.zhanshi123.globalprefix.placholder.PlaceholderHook.onRequest(PlaceholderHook.java:53)
[03:33:44] [Server thread/WARN]:         at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:237)
[03:33:44] [Server thread/WARN]:         at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:377)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.PluginHooks.PlaceholderAPI_setPlaceholders(PluginHooks.java:238)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.platforms.bukkit.Main$31.get(Main.java:566)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.placeholders.PlayerPlaceholder.getValue(PlayerPlaceholder.java:24)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.placeholders.Placeholder.set(Placeholder.java:31)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.Property.isUpdateNeeded(Property.java:89)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.Property.get(Property.java:71)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.ITabPlayer.buildTeamName(ITabPlayer.java:383)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.shared.ITabPlayer.init(ITabPlayer.java:62)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.platforms.bukkit.TabPlayer.<init>(TabPlayer.java:40)
[03:33:44] [Server thread/WARN]:         at me.neznamy.tab.platforms.bukkit.Main.a(Main.java:115)
[03:33:44] [Server thread/WARN]:         at com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor741.execute(Unknown Source)
[03:33:44] [Server thread/WARN]:         at org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:70)
[03:33:44] [Server thread/WARN]:         at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[03:33:44] [Server thread/WARN]:         at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[03:33:44] [Server thread/WARN]:         at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:513)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.PlayerList.onPlayerJoin(PlayerList.java:370)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.PlayerList.a(PlayerList.java:183)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.LoginListener.b(LoginListener.java:178)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.LoginListener.e(LoginListener.java:68)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.NetworkManager.a(NetworkManager.java:273)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.ServerConnection.c(ServerConnection.java:150)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:948)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:423)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:774)
[03:33:44] [Server thread/WARN]:         at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:666)
[03:33:44] [Server thread/WARN]:         at java.lang.Thread.run(Thread.java:748)


[03:33:44] [Server thread/WARN]: [com.zaxxer.hikari.pool.PoolBase] HikariPool-2 - Failed to validate connection com.mysql.jdbc.JDBC4Connection@b91132e (No operations allowed after connection closed.)

[03:33:54] [Craft Scheduler Thread - 233/WARN]: [com.zaxxer.hikari.pool.ProxyConnection] HikariPool-1 - Connection com.mysql.jdbc.JDBC4Connection@775ae62c marked as broken because of SQLSTATE(08S01), ErrorCode(0)
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


[03:33:45] [Craft Scheduler Thread - 235/INFO]: [MiaoBoard] [Replace] PAPI变量 &l※ &7点券: &e%playerpoints_points% 替换时发生错误 java.lang.NullPointerException: null 请检查 PlaceholderAPI 扩展配置!
[03:33:45] [Craft Scheduler Thread - 235/WARN]: java.lang.NullPointerException
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at lib.PatPeter.SQLibrary.Database.prepare(Database.java:291)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.black_ixx.playerpoints.storage.models.MySQLStorage.getPoints(MySQLStorage.java:85)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.black_ixx.playerpoints.storage.StorageHandler.getPoints(StorageHandler.java:39)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.black_ixx.playerpoints.PlayerPointsAPI.look(PlayerPointsAPI.java:102)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.getPoints(PlayerPointsExpansion.java:73)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.onPlaceholderRequest(PlayerPointsExpansion.java:65)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at me.clip.placeholderapi.PlaceholderHook.onRequest(PlaceholderHook.java:38)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:237)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:377)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:41)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:35)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:29)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at \?.?.?.MiaoBoard.??.onBodyUpdate(SelfListener.java:33)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor55.execute(Unknown Source)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:70)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:74)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:513)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at \?.?.?.MiaoBoard.??.?(SidebarBoard.java:43)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:64)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[03:33:45] [Craft Scheduler Thread - 235/WARN]:         at java.lang.Thread.run(Thread.java:748)

数据库是没问题得，开启服务端都没问题，就是时间久了以后，就会出现这些报错，数据库得最**接数已经增加到了50000了，wait time设置了8小时，还是不能解决这个问题

与本插件无关

[04:19:40] [Craft Scheduler Thread - 73/WARN]: [com.zaxxer.hikari.pool.PoolBase] HikariPool-1 - Failed to validate connection com.mysql.jdbc.JDBC4Connection@2b9f9799 (No operations allowed after connection closed.)

6666666666

这只是一个支持库
别的插件可能会包含同样的支持库
与本插件无任何关系

加载时出现这个是正常的吗

正常

是不是不支持1.12.2，在1.12.2cat端上无法使用，报错

cat的bug

能不能出一个这样的教程？真的十分需要...