Minecraft(我的世界)中文论坛
标题: [编程]JdbcConnectionBridge —— 使用HikariCP连接池建立MySQL连接[全版本]
作者: zhanshi123 时间: 2019-1-6 16:55
标题: [编程]JdbcConnectionBridge —— 使用HikariCP连接池建立MySQL连接[全版本]
本帖最后由 zhanshi123 于 2020-3-10 08:31 编辑
JdbcConnectionBridge
- 此插件为个人使用的支持库，用于建立HikariCP的MySQL连接，并且将类库打包到一个插件中，本人的插件会经常用到
- 以减少其他插件大小，便捷管理连接，当然，欢迎其他人使用
使用方法
下载地址
本插件所用代码部分来自其他开源或闭源(已授权)作品 HikariCP
作者: lyxycraft 时间: 2019-2-25 16:48
这个怎么用呢？放在哪了？BC？
作者: zhanshi123 时间: 2019-2-25 22:43
lyxycraft 发表于 2019-2-25 16:48
这个怎么用呢？放在哪了？BC？
本插件为spigot插件，并且只是一个前置，需要其他插件配合使用，装在同一个服务器里
作者: lyxycraft 时间: 2019-2-26 15:43
哦！谢谢
作者: Flous 时间: 2019-7-27 02:02
请问怎么填数据库连接信息
作者: zhanshi123 时间: 2019-7-27 08:58
Flous 发表于 2019-7-27 02:02
请问怎么填数据库连接信息
按照配置文件
分别填写地址
用户名
密码
一般情况只需填写default的信息
作者: a154477274 时间: 2020-4-21 21:45
我用这个插件得话，不知道是否因为max lifetime设置得为30minutes
如果长期挂着服务器，会提示Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl
作者: 37510932 时间: 2020-4-21 22:02
提示: 作者被禁止或删除 内容自动屏蔽
作者: zhanshi123 时间: 2020-4-21 22:46
完整报错发一下
作者: a154477274 时间: 2020-4-22 14:46
[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)
作者: a154477274 时间: 2020-4-22 14:49
数据库是没问题得，开启服务端都没问题，就是时间久了以后，就会出现这些报错，数据库得最**接数已经增加到了50000了，wait time设置了8小时，还是不能解决这个问题
作者: zhanshi123 时间: 2020-4-22 22:00
与本插件无关
作者: a154477274 时间: 2020-4-25 04:23
[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.)
作者: yangou11020 时间: 2020-4-25 04:29
6666666666
作者: zhanshi123 时间: 2020-4-25 18:45
这只是一个支持库
别的插件可能会包含同样的支持库
与本插件无任何关系
作者: 思念化作海 时间: 2020-6-1 13:16
加载时出现这个是正常的吗
- [13:14:54] [Server thread/INFO]: [JdbcConnectionBridge] Enabling JdbcConnectionBridge v1.3
- [13:14:54] [Server thread/WARN]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
- [13:14:54] [Server thread/WARN]: SLF4J: Defaulting to no-operation (NOP) logger implementation
- [13:14:54] [Server thread/WARN]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
作者: zhanshi123 时间: 2020-6-1 22:20
正常
作者: 无目标徘徊 时间: 2020-7-4 16:01
是不是不支持1.12.2，在1.12.2cat端上无法使用，报错
作者: zhanshi123 时间: 2020-7-4 22:42
cat的bug
作者: Sky_God_ 时间: 2020-7-14 23:22
能不能出一个这样的教程？真的十分需要...