MySQL JDBC driver not found using mysql driver dependency

[Thice]

Dear

I was working on a plugin, that connects to the MySQL database.
When connecting to MySQL the way I did in paper would not work and results in the error: No suitable driver found for <database_url>
I've fixed this by adding: Class.forName("com.mysql.cj.jdbc.Driver");
And adding the MySQL connector dependency. Now I still got the error.
I've also tried to add it via the jar, in the modules, also resulting in the same error.

Java version: 20

See images.

Thank you for the help!

 

[electronicboy]

velocity does not bundle jdbc drivers, you would need to shade or otherwise provide them yourself

 

[Thice]

velocity does not bundle jdbc drivers, you would need to shade or otherwise provide them yourself

Thank you for your reply! Is it possible to give me a slight push to get me started?

 

[electronicboy]

You would want to setup the maven shade plugin, https://maven.apache.org/plugins/maven-shade-plugin/examples/includes-excludes.html
the 3rd codeblock is probably the "easiest", just remove the minimizeJar config, and remove the "provided" scope from the mysql j depenendency

 

[Digital'Inc]

The maven-shade-plugin didn't work for me. What helped me was adding (-cp "path\to\mariadb-java-client-3.3.0.jar") to the startup .bat file. But I would like to do without it. Could you show a minimal working plugin using mysql built through maven?

 

[electronicboy]

No, but if you show your build config somebody might be able to tell you what is wrong

 

[Digital'Inc]

No, but if you show your build config somebody might be able to tell you what is wrong

Thanks, I've found a solution.

 

[_1ms]

Thanks, I've found a solution.

I'm having the same issue now, I shade the com.mysql:mysql-connector-j:9.0.0 in the jar with gradle, but it still gives the same java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/mydb error as yours. Do you think you can say how you've solved it?

 

[getsmod0]

Dear

I was working on a plugin, that connects to the MySQL database.
When connecting to MySQL the way I did in paper would not work and results in the error: No suitable driver found for <database_url>
I've fixed this by adding: Class.forName("com.mysql.cj.jdbc.Driver");
And adding the MySQL connector dependency. Now I still got the error.
I've also tried to add it via the jar, in the modules, also resulting in the same error.
bisp payment check
Java version: 20

Thank you for the help!

you're on the right track by adding the MySQL connector dependency and specifying the driver. Since you're still encountering the "No suitable driver found" error, here are a few things to double-check:

1. Dependency Scope: Ensure the MySQL connector is added in the correct scope (e.g., as a compile or runtime dependency if you're using Maven or Gradle).
2. Classpath: Confirm that the MySQL connector jar is included in your runtime classpath. This is especially important if you're manually adding jars or using a modular setup.
3. JDBC URL Format: Double-check the format of your database URL (e.g., jdbc:mysql://localhost:3306/dbname). Make sure it's correctly formatted and includes the proper protocol.
4. Driver Version Compatibility: Since you're using Java 20, ensure that your MySQL connector version is compatible with that Java version.

If you've addressed these and still face the issue, please share more details about your environment or build tool setup.