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?