英文:
Creating runable jar file Intellij with mysql connector in Java JDBC
问题
我在创建一个可运行的包含mysql连接器库的jar文件时遇到了问题。
我的IDE是IntelliJ，我已经成功地将mysql连接器导入到我的库中，所以我的应用程序在IntelliJ中可以正常使用sql。
但是当我创建一个artifact并将我的应用程序导出为一个jar文件时，我遇到了错误：
`java.sql.SQLException: No suitable driver found for jdbc:mysql:`
在我的Java代码中，我使用了以下代码。在IntelliJ中，这在完全正常，但在终端中运行时却不行：
String myDriver = "com.mysql.cj.jdbc.Driver";
String myUrl = "jdbc:mysql://website.com/mydatabase_db";
Class.forName(myDriver);
Connection conn = DriverManager.getConnection(myUrl, "myuser", "myPassword");
我尝试在终端中运行以下代码：
`java -cp mysql-connector-java-8.0.19.jar -jar application.jar`
英文:
I'm having an issue with creating a runable jar file that includes mysql connector library.
So my IDE is IntelliJ and I have successfully imported mysql connector to my library so my application works fine with sql in IntelliJ.
But when I create a artifact and export my application to a jar file, I got the error:
java.sql.SQLException: No suitable driver found for jdbc:mysql:
In my java code I use the following code. And this works perfectly fine in IntelliJ, but not when I run it in my terminal
String myDriver = "com.mysql.cj.jdbc.Driver";
String myUrl = "jdbc:mysql://website.com/mydatabase_db";
Class.forName(myDriver);
Connection conn = DriverManager.getConnection(myUrl, "myuser", "myPassword");
I try to run the code in my terminal with:
java -cp mysql-connector-java-8.0.19.jar -jar application.jar
专注分享java语言的经验与见解，让所有开发者获益！
评论