缺少构件MySQL:MySQL-Connector-Java:JAR:5.1.41,为什么会这样呢?

xytpbqjk  于 2022-10-05  发布在  Mysql
关注(0)|答案(2)|浏览(226)

我正在尝试构建一个Spring项目并添加一些依赖项。但当我尝试添加MySQL-Connector时,会弹出“Missing Artifie MySQL:MySQL-Connector-Java:JAR:5.1.41”错误。我尝试了不同的版本。结果是一样的。我怎么才能解决这个问题。

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.livingoncode.web</groupId>
<artifactId>notices</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<build>
    <sourceDirectory>src</sourceDirectory>
    <plugins>
        <plugin>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.5.1</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
            </configuration>
        </plugin>
        <plugin>
            <artifactId>maven-war-plugin</artifactId>
            <version>3.0.0</version>
            <configuration>
                <warSourceDirectory>WebContent</warSourceDirectory>
            </configuration>
        </plugin>
    </plugins>
</build>
<dependencies>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.26</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>3.2.18.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>

Error message

ha5z0ras

ha5z0ras1#

删除.m2\repository\mysql\文件夹并重建项目。这可能会有所帮助。

4c8rllxm

4c8rllxm2#

嗨,我知道你有什么问题了。尝试删除以下代码行:

<version>5.1.26</version>

从以下依赖项中:

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.26</version>
</dependency>

原因是它指向另一个版本。因此,您应该只保留以下内容:

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

您的应用程序.Propery应该如下所示:

注:CRUDUSERS是数据库中的模式。

注:pw是您的数据库服务器的密码。

spring.datasource.url = jdbc:mysql://localhost:3306/crudusers? 
useSSL=false&serverTimezone=UTC

spring.datasource.username = root
spring.datasource.password = PW
spring.datasource.Driver = com.mysql.cj.jdbc.Driver
spring.jpa.hibernate.ddl-auto = update

向克里斯·穆肯格沙伊致敬

相关问题