在BC中使用XConomy，一直在报错，断连数据库，连接数据库[09:58:27 INFO]: [XConomy] 无法连接到数据库-----
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown initiated...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown completed.
[09:58:27 WARN]: java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnection(DatabaseConnection.java:158)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnectionAndCheck(DatabaseConnection.java:140)
[09:58:27 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:258)
[09:58:27 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:58:27 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:58:27 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:145)
[09:58:27 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:58:27 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:58:27 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:58:27 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:58:27 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Starting...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Start completed.
[09:57:57 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
[09:57:57 WARN]: at sun.reflect.GeneratedConstructorAccessor177.newInstance(Unknown Source)
[09:57:57 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[09:57:57 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[09:57:57 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[09:57:57 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[09:57:57 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[09:57:57 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[09:57:57 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:262)
[09:57:57 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:57:57 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:57:57 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:146)
[09:57:57 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:57:57 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:57:57 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:57:57 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:57:57 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown initiated...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown completed.
[09:58:27 WARN]: java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnection(DatabaseConnection.java:158)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnectionAndCheck(DatabaseConnection.java:140)
[09:58:27 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:258)
[09:58:27 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:58:27 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:58:27 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:145)
[09:58:27 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:58:27 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:58:27 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:58:27 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:58:27 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Starting...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Start completed.
[09:57:57 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
[09:57:57 WARN]: at sun.reflect.GeneratedConstructorAccessor177.newInstance(Unknown Source)
[09:57:57 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[09:57:57 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[09:57:57 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[09:57:57 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[09:57:57 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[09:57:57 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[09:57:57 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:262)
[09:57:57 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:57:57 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:57:57 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:146)
[09:57:57 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:57:57 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:57:57 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:57:57 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:57:57 WARN]: at java.lang.Thread.run(Unknown Source)
如果想要同步数据，不需要使用mysql，只需要在database.yml修改为例如
其中一个服务器是
SQLite:
#Address is the folder path
path: Default
这个服务器地址在'D:\mineserverall\Survival01\
那么另一个要同步是服务器就改为
SQLite:
#Address is the folder path
path: 'D:\mineserverall\Survival01\plugins\XConomy\playerdata\'
就可以实现同步数据
其中一个服务器是
SQLite:
#Address is the folder path
path: Default
这个服务器地址在'D:\mineserverall\Survival01\
那么另一个要同步是服务器就改为
SQLite:
#Address is the folder path
path: 'D:\mineserverall\Survival01\plugins\XConomy\playerdata\'
就可以实现同步数据