huskehhh / mysql Goto Github PK
View Code? Open in Web Editor NEWSimple JDBC MySQL database wrapper for Java
License: MIT License
Simple JDBC MySQL database wrapper for Java
License: MIT License
Could not find artifact pro.husk:mysql:pom:1.2 in papermc-repo (https://papermc.io/repo/repository/maven-public/)
When compiling using maven, I get this error:
cannot access pro.husk.mysql.MySQL
IntelliJ is very unhelpful, I know :(
I'm getting failing building from my Travis builds, 1.8 java.
Failed to execute goal on project Parkour: Could not resolve dependencies for project io.github.a5h73y:Parkour:jar:6.0: Failed to collect dependencies at pro.husk:mysql:jar:1.4.0: Failed to read artifact descriptor for pro.husk:mysql:jar:1.4.0: Could not transfer artifact pro.husk:mysql:pom:1.4.0 from/to husk (https://maven.husk.pro/repository/maven-public/): Received fatal alert: protocol_version -> [Help 1]
Hey,
I just noticed that the project cannot be used as your maven server (maven.husk.pro) is offline.
Maybe that's a stupid question, but I'm new to this topic.
I heard that using a pool of MySQL connections is more efficient if you have a lot of requests.
I saw a few examples of pools, which I didn't really understand, so
can I use this wrapper to create a connection pool easily?
Hey, currently getting this issue when I try to connect to my database...
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Communications link failure at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:589) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:575) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at pro.husk.mysql.MySQL.<init>(MySQL.java:68) at codes.benh.XXX.XXX.main(XXX.java:25) Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554) ... 4 more Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:338) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1340) at com.mysql.cj.NativeSession.connect(NativeSession.java:157) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ... 12 more Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(SSLSocketImpl.java:1321) at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1160) at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1063) at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:402) at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:336) at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:329) ... 19 more Caused by: java.io.EOFException: SSL peer shut down incorrectly at java.base/sun.security.ssl.SSLSocketInputRecord.decodeInputRecord(SSLSocketInputRecord.java:239) at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:190) at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:108) at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1152) ... 25 more
Initialising it with this:
sql = new MySQL("192.168.1.XXX", "3306", "XXX", "XXX", "XXX", "");
Visiting https://maven.husk.pro/snapshots/ will currently result in a 502 Bad Gateway error causing builds to fail, please could this be fixed.
when i reload the minecraft server the HikariPool create a new pool connection. However when it arrives at the 20th connection, i get an error. This error: "Too many connections"
My code of start and disable mysql:
private void disableMySQL() {
try {
if (mysql != null) {
mysql.closeConnection();
}
} catch (SQLException var2) {
var2.printStackTrace();
}
}
private void startMySQL() {
if (this.getConfig().getBoolean("mysql.enable")) {
String url = "jdbc:mysql://" + this.getConfig().getString("mysql.host") + ":" + this.getConfig().getString("mysql.port") + "/" + this.getConfig().getString("mysql.database") + "/" + this.getConfig().getString("mysql.username") + "/" + this.getConfig().getString("mysql.password");
mysql = new MySQL("jdbc:mysql://" + this.getConfig().getString("mysql.host") + ":" + this.getConfig().getString("mysql.port") + "/" + this.getConfig().getString("mysql.database"), this.getConfig().getString("mysql.username"), this.getConfig().getString("mysql.password"));
}
}
When I or dependabot try to access the maven repo I get access denied
Not entirely sure why; 1.4.0 works fine but the 1.4.1-SNAPSHOT build results in failed to transfer.
When I try to connect into database it give me Public Key Retrieval is not allowed error.
I know that I can solve this problem by removing useSSL = false or adding option allowPublicKeyRetrieval=true, but I can't remove any parameter from pro.husk.mysql.MySQL Object or add any option.
I am getting 404 error when I try to sync maven settings.
This link is broken -> https://maven.husk.pro/snapshots
SQLite.java, line 50: getDataFolder().toPath() should be getDataFolder().getPath()
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.