我在我的项目中将Hikari库用于MySQL连接。当我尝试运行程序时,出现ClassNotFoundException:com.mysql.jdbc.jdbc2.optional.MysqlDataSource错误。我认为我必须在项目中包含mysql-connector库。
这是我的pom.xml
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP-java6</artifactId>
<version>2.0.1</version>
</dependency>
<dependency>
<groupId>org.javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.18.1-GA</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-simple</artifactId>
<version>1.7.5</version>
</dependency>
<dependency>
<groupId>io.netty</groupId>
<artifactId>netty-all</artifactId>
<version>4.1.0.Beta3</version>
<scope>compile</scope>
</dependency>
</dependencies>
<build>
<finalName>GridControl</finalName>
<resources>
<resource>
<directory>src/main/resources</directory>
<filtering>true</filtering>
</resource>
</resources>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jar-plugin</artifactId>
<version>2.4</version>
<configuration>
<archive>
<manifestEntries>
<Main-Class>net.thegridmc.control.GridControl</Main-Class>
</manifestEntries>
</archive>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-shade-plugin</artifactId>
<version>2.3</version>
<executions>
<execution>
<phase>package</phase>
<goals>
<goal>shade</goal>
</goals>
<configuration>
<minimizeJar>true</minimizeJar>
<createDependencyReducedPom>false</createDependencyReducedPom>
<artifactSet>
<includes>
<include>mysql:*</include>
<include>org.slf4j:*</include>
<include>com.zaxxer:*</include>
<include>org.javassist:javassist</include>
<include>io.netty:netty-all</include>
</includes>
</artifactSet>
</configuration>
</execution>
</executions>
</plugin>
</plugins>
</build>
该jar已成功构建,但是仍然发生错误。任何帮助都非常感谢。谢谢。
最佳答案
尝试com.mysql.cj.jdbc.MysqlDataSource
。它与
MySQL的连接器的Java 6.0.4